Modified date column update even if there are no changes ?

keesuri25 ✭✭
edited 11/08/22 in Formulas and Functions

I have the modified date column set up as a review sign off date as well. Its part of auto update form that is emailed out to the team to verify project status and sign off. But if there are no changes say in the status. The modified date column does not update to today's date ? If the team deletes, enters the same number and save the sheet, Modified date column populates with last updates date, not today's date. Is there a work around ? Do I need to add another date column ?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!