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

Options

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")))


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!