Method to automatically check a checkbox once it reach certain date

HC. Tan

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?

Kelly Moore

Hey @HC. Tan

Would this work for you?

=IF(ISDATE([10 Years Date After Purchase]@row), IF(TODAY() >=[10 Years Date After Purchase]@row,1))

Kelly Moore

Hey @HC. Tan

Would this work for you?

=IF(ISDATE([10 Years Date After Purchase]@row), IF(TODAY() >=[10 Years Date After Purchase]@row,1))

HC. Tan

Hi @Kelly Moore,

It works! Appreciate for your help on this! ☺️👍️