Making Status at risk colored formulas
Options

Newcomer2
✭✭✭✭
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.
Answers
-
You would need to adjust the column properties to change it to a symbols type column and select that particular symbol set.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!