Formula for Health Symbols
Could you please help me to create a formula?
There are 3 columns, Start Date, End Date and Completed (this is a check box)
I would like to have the symbols change
if a date is between today and the due date = Green
if the date is 3 days before the due date from today, then turn Yellow
if the date is on or past due date from today = Red
if completed column is checked, then turn Blue
Thank you so much and any help would be greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!