How to automatically check a checkbox ?

J.Vaillancourt · 01/05/22

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 · 01/05/22

@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 · 01/05/22

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 · 01/05/22

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 · 01/05/22

Hi @J.Vaillancourt

You can use IF formula:

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

Jeff Reisman · 01/05/22

@Christina Lam

Jinx! 😂

J.Vaillancourt · 01/05/22

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 · 01/05/22

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 · 01/05/22

@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 · 01/05/22

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 · 01/05/22

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!

How to automatically check a checkbox ?

Best Answer

Answers

Help Article Resources

Categories