How to change date modified update to be triggered at the row level?

Hi All,

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!