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?

Find more posts tagged with

Accepted answers

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

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.