Modified Date

Angela Logie

Looking for some assistance...so I am using the Modified Date column in one of my sheets and then using that to identify non-updated/aged rows however there is something in my sheet that is resetting or refreshing each of the rows on a daily basis even when I know there hasn't been a manual update to all the rows...could there be something else that is set up on my sheet that would cause all the rows to update?

Vague, I know. My apologies!

Andrée Starå

Hi @Angela Logie

I hope you're well and safe!

Are you using the TODAY function anywhere in the sheet?

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Angela Logie

Firstly, thank you for your quick response.

So yes I am, I am using it in a field called 'Days since last update' column which is:

=TODAY() - [Modified Date]@row

So how would I get round this then? In order to show how long a row has been unedited?

Thanks in advance!

Angela Logie

@Andrée Starå As per the above, is there a way round this? Do I just need to ensure I have no 'TODAY' formulas in my sheet?

Andrée Starå

@Angela Logie

Happy to help!

Please have a look at my post below with a method I developed to update the sheet(s) daily.

More info: 

https://community.smartsheet.com/discussion/74527/daily-update-solution-without-the-need-to-open-the-sheet-use-zapier-or-similar

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

Angela Logie

Thank you!

Andrée Starå

@Angela Logie

You're more than welcome!

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

Angela Logie

@AndreeP So I applied the solution as per your document however the automation means the modified date is still being updated...which is what I was trying to eliminate?

Andrée Starå

@Angela Logie

Apologies, I misunderstood your need.

You'd need this instead.

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

I'd be happy to share an example. 

Please email me at andree@workbold.com, and I'll share it with you.

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