If and date functions; sorting rows by priority

Tomer
Tomer ✭✭
edited 12/09/19 in Formulas and Functions

Hi,

I am attempting to create a task priority column that is using the Harvey Balls (red, yellow, green and gray).

I am wanting these to automatically change to:

1. Gray - if the date today is grater than 60 days from my due date column or if my status column has been changed to "Complete"

2. Green - if the date today is between 60-30 (including) days from my due date column

2. Yellow - if the date today is between 29-15 (including) days from my due date column

3. Red - if if the date today is between 14-date today (including) OR if date on the due date column has passed.

also, can the rows on the sheet be automatically sorted based on this priority column? (all Red priority rows being top of the sheet, then yellow, green, gray).

Can some one help with this? 

thank you,

Tomer

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!