Making Status at risk colored formulas

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.

Paul Newcome

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