IF/THEN Checkbox formula: IF (cell contains ANY content), then checkmark
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!!
Answers
-
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
-
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
Help Article Resources
Categories
Check out the Formula Handbook template!