IF/THEN Checkbox formula: IF (cell contains ANY content), then checkmark

Bessie Koch

If one of the shaded columns (Batteries AA, Batteries, AAA) has any content in a row, then check mark the shaded row (All-Dept).

Please help!

Thanks!!

TVang

If you only care that there something in "Batteries AA" and "Batteries AAA", then try the formula, 

=IF(AND(ISBLANK([Batteries AA]@row), ISBLANK([Batteries AAA]@row)), "", 1)

In plain English, IF "Batteries AA" AND "Batteries AAA" are blank, then blank, otherwise 1 (which is also the Boolean "true" value).

You can find documentation for all Smartsheet functions here,

https://help.smartsheet.com/functions

The Smartsheet below has all of the formulas and examples of how they're used.

https://www.smartsheet.com/marketplace/us/templates/smartsheet-formula-examples

Bessie Koch

Thank you! This worked perfectly!

Quick follow up -- if I have more than 2 columns to check (+10 maybe), is there a way to group them or do they need to be listed in the formula by individual column?

Thank you,

Bess