IF Function

Wanda Jackson

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?

Jeff M.

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

Wanda Jackson

If there are more than 15 days remaining, the status should turn green (sorry, I omitted this in my original question)

Jeff M.

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

Wanda Jackson

Yes, it worked. Thank you so much!