I am having issues referencing multiple columns using the IF statement.

Vaughn

I have 2x formulas:

=IF([Delayed?]@row = "Customer Delay", "Customer Delay")

=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row = 0, "Not Started", IF(AND([% Complete]@row > 0, [% Complete]@row < 1), "In Progress")))

Both work independently from one another. I'd like for this formula to used in the 'Status column (once combined). The challenge I'm having is combining the two into one cell. When I combine them, I get the "UNPARSABLE" message:

=IF([Delayed?]@row = "Customer Delay", "Customer Delay"), IF([% Complete]@row = 1, "Complete", IF([% Complete]@row = 0, "Not Started", IF(AND([% Complete]@row > 0, [% Complete]@row < 1), "In Progress")))

Paul Newcome

Try removing that first closing parenthesis after "Customer Delay".

Vaughn

Ah! I was sooo close! THANK YOU!!!!!!!

Paul Newcome

Happy to help. 👍️