Method to automatically check a checkbox once it reach certain date

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?

Find more posts tagged with

Accepted answers

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))

All comments

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! ☺️👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.