Stuck with an IF Formula

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!

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    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

Answers