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

Erick Tirrel

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?

Neil Watson

Hi, is the "record a date" automation an option for your solution?

Andrée Starå

Hi @Erick Tirrel

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

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!