Help in writing a custom column (what's wrong with my formula?)

[rashel2002]

Hi everyone!

i'm working on my data and i'm trying to add a new column that will tell for each task it's status (Not start yet/WIP/Done). so here's what i have now and what i'm trying to get (marked in yellow)-

Now here's the formula i wrote-

NotStarted/WIP/Done = if([TaskDuration]-[CurrentStatus])=0, "Done", (if([TaskDuration]=[CurrentStatus], "Not started", "WIP"))

Can you please tell me what's wrong with my formula and how can i make it work?

(Edit: the error message says "The syntax ',' is incorrect" but i don't know what should i write instead [i tried to put "then" & "else" instead of the commas , but it atill not working)

Thx!!

[JoHo_BI]

Hi Rashel,

You're closing the brackets too early, your formula should read: 

=IF(([TaskDuration] - [CurrentStatus) = 0, "Done", IF([TaskDuration] = [CurrentStatus], "Done", "WIP"))

Hope that helps!

[rashel2002]

Hi.

thank you for your time - it's still not working (and have the same error message) \

[JoHo_BI · Accepted solution]

Oops! If you copy and pasted I made a slight syntax error. Try this: 

=IF(([TaskDuration] - [CurrentStatus]) = 0, "Done", IF([TaskDuration] = [CurrentStatus], "Done", "WIP"))

[rashel2002]

Oops, i didn't add it to the right place and that was the problem!

thank you so much for your help :

[rashel2002]

haha I know, i changed it already. it's not it 😕