Are there any way to capture date and time of a particular dropdown status?

Vivien Chong

We want to track the timing from Process A to Process B, and to minimise the update action by the Field Workers.

For example:

cell A (dropdown list) | cell B (date) | cell C (time) | cell D (date) | cell E (time)

*Note: Cell B & C can also be separated into date and time column respectively

Cell A is a dropdown status column = Submitted, Assigned, Pending, Complete

When status in cell A changes to "Assigned," update date and time into cell B and C

When status in cell A changes to "Complete", update date and time into cell D and E

In the above scenario, Field Worker will just need to focus on Cell A to update their status.

Appreciate any guidance or workaround.

Thank you and have a blessed day!

Andrée Starå

Hi Vivien,

The third-party service, Zapier, is an excellent option for this scenario. Is that an option for you?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help 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!

Vivien Chong

Hi @Andrée Starå thanks for the input that Zapier is able to capture the date and time and populate it in another cell.

We are not looking into 3rd party app at the moment. However, thanks for letting me know that if we really need to do this, we have to do it through Zapier.

Thanks so much!

Andrée Starå

Happy to help!

Hopefully we will soon have something in Smartsheet natively.

Please submit an Enhancement Request when you have a moment

✅Remember! Did my post help 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!