Nesting multiple functions



I'm struggling to nest 3 IF functions extracted from 2 separate columns into 1 cell. The one column is a checkbox(ENM INITIATED) and the other is a drop down(JOB STATUS: COMPLETE, WIP, ON HOLD and NOT STARTED). Also the column in which the 2 functions are nested is a symbol type? These formulae all work individually but the moment I group them it gives me the error unparseable. Can someone help me with the structure of it?

This is the formula I've created: IF([JOB STATUS]@row = "COMPLETE"; "Green"; IF([ENM INITIATED]@row = 0; "Red"; IF([ENM INITIATED]@row = 1; "Yellow")))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!