How to change my status column when Completed column is not blank

Jane Miller

Hi everyone - I am new to smartsheet and am trying to figure out a formula for the following scenario:

When Completed Date is not blank, make status Complete, otherwise I want to leave whatever value is there (the value will either be In Progress or On Hold). Help greatly appreciated.

Mike Wilday

Another solution is to automate every status. If you automate each of the other status' you can also automate the completion by using your completion date. We did this by automating the in-progress by adding an Actual Start Date field to our sheet so we can determine when the task has been started. And then set the status column to In-Progress when the actual start date is added. You could have a checkbox to put the project on hold and do the same thing if you were interested.

Just something you could consider!

Andrée Starå

Hi @Jane Miller

Welcome to the Community and the wonderful world of Smartsheet!

Unfortunately, it's not possible at the moment to change a value manually and also have it changed automatically, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could use a 3rd party solution like, Zapier to make it work or so-called helper column in Smartsheet.

Would any of those options work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Mike Wilday

Another solution is to automate every status. If you automate each of the other status' you can also automate the completion by using your completion date. We did this by automating the in-progress by adding an Actual Start Date field to our sheet so we can determine when the task has been started. And then set the status column to In-Progress when the actual start date is added. You could have a checkbox to put the project on hold and do the same thing if you were interested.

Just something you could consider!