Method to automatically check a checkbox once it reach certain date

Options

Hi all,

I was working on the formula to automatically check a checkbox once it reach a certain date.

For example, I purchased a laptop on 3rd November, and I planning to change the laptop after 10 years of usage. And, i planned to have one helper column (Current Equipment Age) to indicate the current age for the laptop, and the checkbox to automatic check once it reaches 10 years.

Not sure if there is anyway that can helps me with this way?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!