Is there a way to capture modify timestamp per individual record rows and not entire sheet?
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?
Best Answer
-
Hi,
I hope you're well and safe!
Please have a look at my post below with a method I developed.
More info:
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!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
Hi @Natye Briggs -
I am interested in working this out. Initial thought did not work but will continue to work on this one.
-
Thank you!
-
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.
-
Hi,
I hope you're well and safe!
Please have a look at my post below with a method I developed.
More info:
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!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thank you so much, this is perfect!
-
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!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!