Is there a way to capture modify timestamp per individual record rows and not entire sheet?

Natye Briggs

My program has several individuals each day checking in and out. I'm using my created column time stamp to capture sign-in time with this =TIME(RIGHT(Created@row, 8)) formula in the Start Time 12HRs column. The Modified time stamp to capture THAT PARTICULAR INDIVIDUAL ROW RECORD in the End Time 12HRs column with =TIME(RIGHT(Modified@row, 8)) formula. Every time data is entered the entire modified record column changes all together. How can I make it so each record calculates separately?

Andrée Starå

https://community.smartsheet.com/discussion/122951/is-there-a-way-to-capture-modify-timestamp-per-individual-record-rows-and-not-entire-sheet

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

I hope that helps!

Be safe, and have a fantastic week!

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!

nschildt

Hi @Natye Briggs -

I am interested in working this out. Initial thought did not work but will continue to work on this one.

Natye Briggs

Thank you!

nschildt

Hi @Natye Briggs -

Here is an option. It will use the Copy Row Automation and a second copy of your sheet.

Create a copy of your sheet. On the initial sheet continue to keep your formulas how you have them and use the copy row automation to copy the row to your copy sheet when the sign out button is checked.

In your copy sheet make sure that you remove your formulas so that when they are copied to the new sheet they do not continue to formulate.

If you want to bring the time back to your original sheet you will need to first create an index column that you can use to index match the time back to the appropriate row on both sheets, or you can simply use the Copy sheet as your main sheet now.

Andrée Starå

https://community.smartsheet.com/discussion/122951/is-there-a-way-to-capture-modify-timestamp-per-individual-record-rows-and-not-entire-sheet

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

I hope that helps!

Be safe, and have a fantastic week!

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!

Natye Briggs

Thank you so much, this is perfect!

Andrée Starå

https://community.smartsheet.com/discussion/comment/439617#Comment_439617

Excellent!

Happy to help!

✅ Remember! 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!