Capture modified date and time stamp

Hello. I have an system column that records modified date and time I also have one that records when the entry was added to the Smartsheet.

We have 4 hours to respond to a new entry. What I would to do is when the status of a row changes to reviewing it would record the date and time stamp then we would use a formula to pull out the total time it has been open for before being changed to reviewing.

I created an automation to copy the row to another sheet when changed to reviewing, this way I have the correct "modified" time and it doesn't get changed again. I figure then I would use a formula to calculate the time difference and then Index/Match to look up the value and populate it on the main sheet. Whenever I try a formula to get the time difference I get an invalid operation error.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!