What is wrong with this formula?

Options

Hi,

Could one of you please tell me what is wrong with this formula:

=IF([% Complete]@row = 100%, "Blue", IF([End Date]@row <= TODAY, "Red", IF([End Date]@row < TODAY(5), "Yellow", "Green")))

I keep getting an #UNPARSEABLE error.

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓
    Options

    You need open and close parenthesis after the first TODAY function.

    =IF([% Complete]@row = 100%, "Blue", IF([End Date]@row <= TODAY(), "Red", IF([End Date]@row < TODAY(5), "Yellow", "Green")))


    If your [% Complete] column is actually set up to be a percentage, then you will also want to change your criteria there. Percentages in Smartsheet are calculates as a percentage of 1.

    So 100% = 1, 50% = .5, etc., etc.

    =IF([% Complete]@row = 1, "Blue", IF([End Date]@row <= TODAY(), "Red", IF([End Date]@row < TODAY(5), "Yellow", "Green")))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!