Lock or Store Date/Value Solution without using Zapier

@Andrée Starå I just emailed you as well. I really hoping this is the solution I've been looking for!

You can now record a date in a field based on row additions/changes via Workflow. I am using this to track the contract lifecycle and duration of each step as it moves from Draft-->Peer Review-->Finance Review-->Legal Review-->Approved.

@Andrée Starå

I'd love to know how you capture the time. I've sent you an EM. Thanks, Doug

@Andrée Starå ,

I am attempting to capture a timestamp once a "response issued" checkbox has been selected - based off of the initial "Submittal Date" timestamp in a separate column, one could derive turnaround time for the request. This would all be integrated into PowerBI, so simply viewing cell history on a case-by-case basis would be nearly impossible.

Does you workaround solve this issue I'm running into? As of now, all I can do is run a workflow to capture a date when the "response" checkbox is selected ... but what I'm really looking for is a timestamp.

If your solution is on par with what I'm looking for, would you be willing to forward on your example?

Thank you, and have a great day!

Nick

Hi Andrée,

Is there any particular reason why an email interaction is required to get an example? I got as far as getting the row copied from one sheet to another on setting the open ticket status to closed. Rows shared the ticket id so this is easy to match. but any efforts to copy the time stamp column data to any column not set to date, only results in an error invalid data for this column type and date column only presents date. So I'm back to square one.

I'm just trying to figure out how to copy all the information (including time) and have it present back on the original sheet.

Hi again,

@Andrée Starå I have sent you an email

@Andrée Starå Is this still the most current best practice to capture time stamps (other than created and modified dates) ? I need help