System Column - Last Modified

edited 12/09/19 in Formulas and Functions
12/04/19 Edited 12/09/19

Hi everyone!

Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified" 

Here's the problem: If someone only "views" the sheet & doesn't make any updates, every single row in the sheet updates as if it were modified. 

Any feedback would be greatly appreciated!

Thank you!


Screen Shot 2019-12-04 at 11.36.45 AM.png


Sign In or Register to comment.