Help with formula to change symbols based on status of task?
I'm developing a project management protocol for an educational intervention implementation. Want the task complete status to change color symbols based on:
Red = task is past end date (have end date column)
Yellow = task is 7 days from end date
Green = task is in progress between start date (have start date column) and 7 days prior to end date
Blue = task completion (have task completion column) checked
Blank if start date, end date, or task completion blank.
Pretty new to Smartsheet and would love help with this formula.
Help Article Resources
Check out the Formula Handbook template!