How to change date modified update to be triggered at the row level?
I found a formula in the forum to calculate duration of time in days, hours and minutes and it works flawlessly.... except.
The issue is after all of the searching for a solution if I add a new row, hit save, modify anything on the sheet it updates the entire modified by column. Notice both rows have the exact date and time.
So if I add a new line via a Form it changes all the values rendering my precious formula useless.
Does anyone know what may be causing the issue or a viable work around?
Help Article Resources
Check out the Formula Handbook template!