Return "pending" if project lands between two dates

thomasda

Hello, hoping for some help from the Smartsheet experts.

I am looking to return "in progress" if a project lands between a project start date and project finish date.  My start date, finish date and status are in 3 columns, side by side.

Looking to automate the status column, to reflect in progress, when falling between 2 dates on the same sheet.

Any help here with the formula  is appreciated.

 

Mike Wilday

IF(And(Today() > start1, Today() < finish1), "In Progress") should do the trick. 

• Replace Start1 and Finish1 are the column header names and row number. Update these to match.
• If your headers have spaces in them, you will need to surround the column name with brackets like this [Start Date]1 or [Finish Date]1

Hope that works out for you.

thomasda

Thank you very much, would have never figured this out.  Really appreciate your help.

Mike Wilday

Glad I could be of service!