Stuck with an IF Formula

Carl Vieira

I wrote a IF formula for a status column that is based on % complete

=IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row = 1, "Complete", "Active"))

What I want to add if there is a check box in the Task On Hold to change the status to "On Hold" which is one of the drop downs.

I am having trouble incorporating another column logic into the status.

Is it possible to accomplish the IF statement to take into consideration?

Thank you in advance!

Kelly Moore

Hello Carl,

You were almost there! Here is one solution.

=IF([Task on Hold]@row = 1, "On Hold", IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row = 1, "Complete", "Active")))

Let me know if this is not what you had in mind and we'll tweak it until it fits your needs

Kelly Moore

Hello Carl,

You were almost there! Here is one solution.

=IF([Task on Hold]@row = 1, "On Hold", IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row = 1, "Complete", "Active")))

Let me know if this is not what you had in mind and we'll tweak it until it fits your needs

Carl Vieira

KDM, this worked great, thank you so much!