Auto-Update Status Based on Start and Finish Dates Without Helper Column

System

This discussion was created from comments split from: IF todays date is between start date and end date then check this box.

SSFeatures

Hi @Cam G38,

We can do this by updating the formula that you currently have. Instead of the "1" and the "0" in the formula, we can replace that to "In Progress" and "Not In Progress".

=IF(AND(TODAY() >= Start@row, TODAY() <= Finish@row), "In Progress", "Not In Progress")

This will perform the calculation and set the text directly in that column.

Best!

Cam G38

Hi! I reopen this ticket because I can't make it work.

This is a PTO tracker.

I would like to have the status automatically updated to 'In progress' when the current date is on and between the start and finish dates.

I can't make a formula working to achieve this.

Any support?

26/05/25 update:

Right now I succeeded to add a column 'status calculation' where it input 1 or 0 and then an automated rule to defined on 'in progress' if 'status calculation' = 1 so 'status' column goes to 'in progress '

I used this formula:

=IF(AND(TODAY() >= Start@row, TODAY() <= Finish@row), 1, 0)

But i would like direct update of the status base don start and finish date without any additional column or calculation.

Regards,

SSFeatures

Hi @Cam G38,

We can do this by updating the formula that you currently have. Instead of the "1" and the "0" in the formula, we can replace that to "In Progress" and "Not In Progress".

=IF(AND(TODAY() >= Start@row, TODAY() <= Finish@row), "In Progress", "Not In Progress")

This will perform the calculation and set the text directly in that column.

Best!

Cam G38

hi

it works

thank you

SSFeatures

No problem!