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

Markximillian

Hello,

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!!

Gia Thinh

Hi @Markximillian

Try this formula. Hope it works for you.

=IF([Start Date]@row > TODAY(), "Not planned", IF(AND([Start Date]@row <= TODAY(), [End Date]@row >= TODAY()), "In progress", IF([End Date]@row < TODAY(), "Completed")))