Can Smartsheet enter a date automatically based on a progress update

caw98776

Is there a formula that would allow Smartsheet to automatically enter the current date in a separate column when a drop-down choice in another column is selected. For example, when the Progress column is updated (through the drop-down) to "Assigned", can a separate column called DateAssigned be auto-populated with the current date.

Then, when the Progress column is updated (through the drop-down) to "Submitted" can a separate column called DateSubmitted be auto-populated with the current date.

I'd like to be able to track the time to completion by including a 3rd column that calculates the elapsed days between the dates in DateAssigned and DateSubmitted.

Andrée Starå

Hi @caw98776

Please have a look at my post below with a method I developed.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work?

I hope that helps!

Be safe and have a fantastic weekend!

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!

caw98776

Thank you so much for responding; however, the Post was above my current skill set. I have yet to copy a row to a separate sheet or use the VLOOKUP/INDEX/MATCH functions. Can you provide formula examples used to complete this process. If you provide proven formulas, I believe I can edit the content to match the columns and content on my sheet.

Andrée Starå

@caw98776

Happy to help!

I'd be happy to share an example. 

Please send me an email at andree@workbold.com, and I'll share it with you.