Formula to auto-update the status of a task based on Start/Finish Date Columns



How can I update the status of a task based on start/finish dates?

This is how I want it to work:

  1. Status = Not planned, if start is not the current day.
  2. Status = In progress, if start is today.
  3. Status = Completed, is end was yesterday.

Can I do this if I have drop-down in the status column?

Thanks for your help!!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!