IF Function

I'm trying to use the IF function for 3 different columns, using a comma after each "Green" and adding ))) at the end of the formula, but I keep getting errors: Unparseable

=IF([Submission Deadline]@row - TODAY() < 15, "Red", "Green", IF([Application Deadline]@row - TODAY() < 15, "Red", "Green", IF([Booth Deadline]@row - TODAY() < 15, "Red", "Green")))

I want to use only (1) status column instead of (3) different ones and I want the status to turn red if either of these columns have less than 15 days remaining. What am I doing wrong?

Best Answer

  • Jeff M.
    Jeff M. ✭✭✭
    Answer ✓

    Hi Wanda,

    Plug this into your status column and see if that works for you.

    =IF([Submission Deadline]@row > TODAY(-15), "Red", IF([Application Deadline]@row > TODAY(-15), "Red", IF([Booth Deadline]@row > TODAY(-15), "Red", "Green")))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!