System Column - Last Modified

lisarae723
lisarae723 ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

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!

Lisa

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

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!