Auto Check a box after 24 hours

I have tried to get smartsheet to auto check a box 24 hours after a row is created and column "Task Started" is not checked.

=IF(AND([Task Started]@row <> 1, TODAY() - Created@row >= 1), 1)

This returns #UNPARSEABLE. Any help would be appreciated.

Find more posts tagged with

Formulas

functionality

Accepted answers

JR90

Hi,

Im not sure how you have yours set up, but here's how I did it for this example:

In the "Today - Date in "Created" Column" I have the formula:

=TODAY() - Created@row

In the "24hr Check" column I have this formula:

=IF(AND([Task Started]@row = 0, [Today - Date in "Created" Column]@row >= 1), 1, 0)

Please let me know if this helps

All comments

JR90

Hi,

Im not sure how you have yours set up, but here's how I did it for this example:

In the "Today - Date in "Created" Column" I have the formula:

=TODAY() - Created@row

In the "24hr Check" column I have this formula:

=IF(AND([Task Started]@row = 0, [Today - Date in "Created" Column]@row >= 1), 1, 0)

Please let me know if this helps

Twitch the Itch

It worked! T

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.