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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 67 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!