Nesting multiple functions

Yusuf Safudien

Hello

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

Thanks

Paul Newcome

The above formula doesn't have any obvious issues. Are you able to provide a screenshot of the formula within the sheet similar to the screenshot below?