How to record automatically closed hour

Souheyla Derraz

Dear all, I would like to record the exact hour when a ticket is closed. is there a way to do that? thank you in advance for your support

Paul Newcome

Here is a method I developed to capture the date/time stamp of a specific action. The only thing to add to this method would be an INDEX/MATCH to bring the static date/time stamp from the second sheet back to the first based on a unique identifier on every row.

https://community.smartsheet.com/discussion/63561/date-time-stamp-option

Andrée Starå

https://community.smartsheet.com/discussion/132336/how-to-record-automatically-closed-hour

Hi,

I hope you're well and safe!

Please look at my post below, which contains a method I developed.

More info: 

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

Would that work/help?

I'd be happy to share an example. 

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

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!