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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!