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.

Thanks

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!