Needing Two Timestamps in One Smartsheet

Options

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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!