Unparseable Error


I would like to add a health status formula but i am receiving an error.

=IF(Status@row = "Not started", "Blue", IF(Status@row="In Progress", "Yellow", IF(AND(TODAY() > [end date]@row, Status@row="In Progress"), "Red", IF(Status@row="Complete", "Green"))))

Any help would be greatly appreciated.

Best Answer

  • Ashley L.
    Ashley L. ✭✭
    Answer ✓

    Yes and i realized i was missing some additional parenthesis.

    Correct Formula

    =IFERROR(IF([% Complete]@row = 1, "Blue", IF((1 - (NETWORKDAYS(TODAY(), [End Date]@row) / Duration@row)) - [% Complete]@row >= 0.2, "Red", IF((1 - (NETWORKDAYS(TODAY(), [End Date]@row) / Duration@row)) - [% Complete]@row >= 0.1, "Yellow", "Green"))), "")

    Thank you so much!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!