How to automatically check a checkbox ?

Hi !

I'm looking for the formula to automatically check a checkbox (Column named Urgent) when the due date has passed (Column name Deadline). The column Urgent is a checkbox column and the column Deadline is a date column.

I would like that, when the date in the Deadline is passed, I want the Urgent box to be ticked automatically.

Can someone help?

Thanks in advance.

Find more posts tagged with

Accepted answers

Devin Lee

@J.Vaillancourt

The formulas that have been provided work for me. Double check the column properties and see if changing the 1 and 0 to true and false does anything. If not, provide a screenshot similar to the one below.

=IF(Deadline@row < TODAY(0), true, false)

All comments

Sanjay Cherubala WPP

You can use a formula such as the one below in the Checkbox column:

=IF(NETDAYS([Deadline]@row, TODAY()) > 0, 1, 0)

Setting the value to 1, checks the box. Note - you may get a notification on the UI about using a formula in the checkbox column, but you can safely ignore.

Jeff Reisman

In the checkbox column, create a column formula:

=IF(Deadline@row < TODAY(0), 1, 0)

Checkbox cells actually are a value, 1 for checked, 0 for unchecked.

Christina09

Hi @J.Vaillancourt

You can use IF formula:

=IF(Deadline@row < TODAY(), 1, 0)

Jeff Reisman

@Christina Lam

Jinx! 😂

J.Vaillancourt

Hello all !

I've tried all the proposed formula and I'm getting an #unparseable response in the field in question.

Any other ideas?

Thanks everyone.

J.Vaillancourt

Hi @Christina Lam !

I tried your proposed formula and I'm getting an #unparseable statement in the box. Am I missing something? Do the spaces in the formula matter? If I'm using the French version of SmartSheet, would the formula change at all?

Any other troubleshooting tips?

Thanks!

Devin Lee

@J.Vaillancourt

=IF(Deadline@row < TODAY(0), true, false)

J.Vaillancourt

Thanks @Devin Lee !

I figured out the issue. I had to replace the " , " by " ; ".

Minute detail but makes a major difference.

Thanks everyone for your help!

Jeff Reisman

https://community.smartsheet.com/discussion/comment/314971#Comment_314971

I knew there was a syntax difference with the European version, but for the life of me I couldn't remember what it was!

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.