Formula

swoodring80171

VERY new to SS.  I am trying to write a formula that will insert red dot for any date that is prior to today, a yellow dot for any date that is  that is between 1-30 days from now, and a green dot for any date that is 30+days from now and I cannot get it to work...can anyone provide guidance? 

Andrée Starå

Hi,

Can you provide the column names and some screenshots?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Nic Larsen

Try this:

=IF([Column Name]@row > TODAY() + 30, "Green", IF([Column Name]@row < TODAY(), "Red", "Yellow"))

Mike Wilday

You will want to create a new Symbol column set up as a RYG column. Use Nlarsons formula in the new RYG column. Then replace "Column Name" with your date column name. You'll want to make sure that the column with the due date is also a date column type. You can right-click on the column header and choose "Column Properties" to determine if its a date column or not.