If and date functions; sorting rows by priority
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?
Help Article Resources
Check out the Formula Handbook template!