Formula for changing symbol colors

I created a column that changes symbol colors depending on the start date column. The below formula I put together after reading through some other posts within this community works alright except for the bit to have the symbol change to gray when the start date is today or past. What am I missing?

=IF([Start Date (ET)]@row < TODAY(14), "Red", IF([Start Date (ET)]@row < TODAY(21), "Yellow",IF([Start Date (ET)]@row <= TODAY(), "Gray", "Green")))

Find more posts tagged with

Formulas

Accepted answers

All comments

Lucas Rayala

Hi @Amwil, your condition "<TODAY(14)" will always be met before your condition "<=TODAY()". Rearrange to put the gray at the start. Always check the order of your criteria -- the first "IF" that meets it's criteria will trigger first.

=IF([Start Date (ET)]@row <= TODAY(), "Gray", IF([Start Date (ET)]@row < TODAY(14), "Red", IF([Start Date (ET)]@row < TODAY(21), "Yellow", "Green")))

Amwil

@Lucas Rayala noted, thank you for the assistance!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.