Automate Checkbox once date is entered

Jamie Capito

Hello, once the date column is entered, I'd like to automate my checkbox column to check off once the date has been filled in. Is this possible to automate a checkbox?

James Keuning

@lilywramirez presented a solution that requires your checkbox to have a formula in it. Which means that you cannot override the value. You can also use an automation to check a box, which does not require a formula in your checkbox field/column:

Jamie Capito

Thank you both! I ended up using the solution from @James Keuning

lilywramirez

In Smartsheets, checkbox can also be treated as 1(True) and 0 (False).

An IF statement will help you here. ISDATE will check if the there is a date in the date column and check off the box if true. You may also convert this to a column formula to have it apply to any new rows added to the sheet.

=IF(ISDATE([Date Column]@row), 1, 0)

James Keuning

@lilywramirez presented a solution that requires your checkbox to have a formula in it. Which means that you cannot override the value. You can also use an automation to check a box, which does not require a formula in your checkbox field/column:

Jamie Capito

Thank you both! I ended up using the solution from @James Keuning