Autocheck a box


I know these have been asked, and I have a formula working but I have a different issue. I want to auto check a box based on the most recent modified date. Im using the following formula:

=if(Modified@row = MAX(modified:modified),1,0)

The issue is it checks the box correctly, but as soon as I set the formula as a column formula and save the sheet every row's modified date/time stamp updates to the exact same time, so every box gets checked. There are no other formulas on this sheet.

See in the screenshots. Anything I can do to stop that from happening?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!