Updating the Red or Green Status Column based on Dates from another column

I'm trying to create a formula that changes my status column to the red or green symbols.

I want to base it on my Renewal Date column.

I looked at some examples on the site, but wasn't able to get it to work on my sheet. I was trying to set up a formula around the following parameters..

If date is in the past turn status symbol Red.

If date is in the future, turn status symbol Green.

Thank you in advance for your help

Find more posts tagged with

Accepted answers

All comments

Ray Lindstrom

Hi @Anthony Nicholas,

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

Anthony Nicholas

Thank you Ray.

I was able to get the formula to work. However, is there a way for it to show the red or green symbol instead of the word "Red" or "Green"

SS snip.JPG

Anthony Nicholas

Hi again,

I was able to figure this one out. I had the color name in all CAPS instead of just Red or Green.

Thank you!!

Andrée Starå

Hi @Anthony Nicholas

I hope you're well and safe!

Excellent!

Glad you got it working!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!

Sign in to join the conversation!

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.