How to automatically check a checkbox ?

J.Vaillancourt

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.

J.

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)

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.

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!

J.

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)

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!

J.

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!