Status change based on calculated dates

Cam G38
Cam G38
edited 05/20/25 in Formulas and Functions

Hi,

I have 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?

Regards,

smartsheet support request.png

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!