due date changing the status?

Hello guys,

I'm working on my project plan sheet and i'm facing some difficulties formatting the columns,

How to change the Status based on due date (if the today's date pass the due date, the status column changed to something else *red (delayed)* for example)

Here are the down list of columns:

Status: Started, on hold, completed, delayed, not started

and the dates columns: Start date, end date, due date



Thanksss!!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!