Making Status at risk colored formulas

Newcomer2 ✭✭✭
edited 02/15/24 in Formulas and Functions


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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!