Needing Two Timestamps in One Smartsheet

aeverson

Hello,

Can someone please assist with having two timestamps?

I need to have our "Timestamp" in the first column when the customer submits a quote request, and another timestamp in "Arista Timestamp" (with date and time) of when "Quote Request Sent To WWT?" changes to "Yes".

Right now my workaround is to have it record a date when it is changed to "Yes", but most are 0-1 days so I want to show it by date and time so I can see what the turnaround time is by hours.

I have looked at a few articles using index and collect, etc but I am running into issues.

Andrée Starå

https://community.smartsheet.com/discussion/122015/needing-two-timestamps-in-one-smartsheet

Hi,

I hope you're well and safe!

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/help?

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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

aeverson

Hi Andree,

I tried to go through this step by step but I still do not understand.

My unique ID is the reference # for each new line as well

Andrée Starå

https://community.smartsheet.com/discussion/comment/436174#Comment_436174

I'd be happy to share an example.

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

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

aeverson

I have emailed you. Alysha McPeak

aeverson

Hi Andre - Are you able to post this here in the thread?

Andrée Starå

https://community.smartsheet.com/discussion/comment/436187#Comment_436187

I've shared it with you!

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