Multiple IF functions


I would like to Nest two If functions in one cell. Below is what I have, but I am receiving an error #unparseable.

=IF([ENM INITIATED]@row = 0; "Red"; "Yellow", IF([JOB STATUS]@row = "COMPLETED"; "Green"))

I would greatly appreciate your help.

Thank you


  • James Keuning
    James Keuning ✭✭✭✭✭

    Put this:

    IF([JOB STATUS]@row = "COMPLETED"; "Green";”Yellow”))

    where you currently have "Yellow"

  • I've tried it, but it's still giving me the error. I'm not exactly sure if I structured it correctly. Could you possibly type out the entire function please?

  • Genevieve P.
    Genevieve P. Employee Admin
    edited 05/20/22

    Hi @Yusuf Safudien

    I believe James was pointing out that the "Yellow" instruction would need to be at the very end, instead of in the middle.

    This would be the full structure:

    =IF([ENM INITIATED]@row = 0; "Red"; IF([JOB STATUS]@row = "COMPLETED"; "Green"; "Yellow"))

    If this hasn't helped, it would be useful to see a screen capture of your sheet and a detailed instruction of when you want each colour to appear, but please block out sensitive data.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!