Formula for Changing Symbols

I am trying to create a formula where the symbols (red, yellow and green circles) change when red when it is passed the Extension Deadline date, yellow when it is 60 days from the date, and green when it is more than 60 days from the date. What is a formula I can use to achieve this?

As of right now this is the formula I have: =IF([Extension Submittal Deadline]@row < 60, "Red", IF(AND([Extension Submittal Deadline]@row > 60, [Extension Submittal Deadline]@row = 60), "Yellow", [Extension Submittal Deadline]@row > 60, "Green"))

But it only shows red for all the other rows under 60 day notice.

Find more posts tagged with

Accepted answers

All comments

Maaik Meijerink

@J_Meyer,

In your current formula you are comparing the value 60 with the value of the date, which makes no sense: You will have to use the TODAY function in combination with your date column:

... [Extension Submittal Deadline]@row - TODAY() < 60 ... if you want to compare today's date with the specified date and see if it has passed 60 days from now.

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.