IF Statement with Color Symbols

I am having difficulty getting the following function to work.

=IF([End Date]@row > TODAY(), "Blue", IF([End Date]@row < TODAY(), "Red"), IF(Done@row = 1, "Green"))

The blue and the red function work perfectly, but when adding the green if statement comes back with "# Incorrect Argument Set". The odd thing is that if I only apply the green statement to the row, it works fine.

Find more posts tagged with

Accepted answers

Mark Cronk

Hi @Matt Atkins ,

Try:

=IF(Done@row = 1, "Green", IF([End Date]@row > TODAY(), "Blue", "Red"))

When using nested IF statement the order matters. The function stops as soon as it finds a true statement.

Work?

Mark

Matt Atkins

Perfect, I should have asked sooner!

All comments

Mark Cronk

Hi @Matt Atkins ,

Try:

=IF(Done@row = 1, "Green", IF([End Date]@row > TODAY(), "Blue", "Red"))

When using nested IF statement the order matters. The function stops as soon as it finds a true statement.

Work?

Mark

Amber Benge

Mark is on it! Let us know if that solves it.

Matt Atkins

Perfect, I should have asked sooner!

Mark Cronk

Hi Matt, Glad you found a solution. Would you tag my response as accepted? Appreciate you contributing to the Community.

Mark

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.