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

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!
Vivien Chong
Modern Work Management Consultant @ 57Network Consultancy Sdn Bhd
Connect with us: 57network.com
Answers
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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!
Vivien Chong
Modern Work Management Consultant @ 57Network Consultancy Sdn Bhd
Connect with us: 57network.com
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.