How do I automate an action between columns?

Peter Bromhead

For example, when I add a date to 'start date' column, I would like my status column to automatically change to 'in progress'?

Andrée Starå

Hi Peter,

To add to shdil's excellent suggestion.

I'd recommend using the following because otherwise, it will not show as in progress if you're looking at it today and after.

Try something like this.

=IF(ISDATE([Start Date]@row); "In Progress")

The same version but with the below changes for your and others convenience.

=IF(ISDATE([Start Date]@row), "In Progress")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Please help the Community by marking the post that helped answer your question or solve your problem with the accepted answer. It will make it easier for others to find a solution or help to answer!

shdil

=IF([Start Date]@row < TODAY(), "In Progress")

You can put this formula in your status column and it should automatically calculate!

Andrée Starå

Hi Peter,

To add to shdil's excellent suggestion.

I'd recommend using the following because otherwise, it will not show as in progress if you're looking at it today and after.

Try something like this.

=IF(ISDATE([Start Date]@row); "In Progress")

The same version but with the below changes for your and others convenience.

=IF(ISDATE([Start Date]@row), "In Progress")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Please help the Community by marking the post that helped answer your question or solve your problem with the accepted answer. It will make it easier for others to find a solution or help to answer!

Peter Bromhead

Thank you for your help. This worked - I would love to see this has a feature within conditional formatting. If 'this occurs' then change to 'this'. I added the formula to the column but there are more features I would like to do elsewhere - I think I am going to have to commit some time to learn more about writing the formulas.

Thanks,

Andrée Starå

Excellent! 

Happy to help!

And, I agree that it would be a great addition to Smartsheet features.

Please submit an Enhancement Request when you have a moment to have your vote added