Making Status at risk colored formulas

Hi,

Is there anyway to create yellow, red, and green dots based on the weeks/days the date is at? Can you help fix my formula to change red (1 week or 7 days from date rec or disclosed date), yellow (30 days from date rec or disclosed date), and green to (open actions)?

I tried =IF(TODAY() - [Date Rec Or Disclosed]@row >= 14, "Red", "Green") in a separate column to reference Date Rec or Disclosed dates. However, it only shows the world red or green, but I want a red, green, and yellow dot to show up on the column.

Thank you for your help.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

You would need to adjust the column properties to change it to a symbols type column and select that particular symbol set.

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.