Using ISBLANK with a checkbox cell
I'm trying to create a formula for my sheet that is counting a total number of items in the sheet within certain parameters, I've gotten the formula down for most of them but where I've run into issues is that my final formula either needs to be based on a column that is a checkbox OR if another column is NOT blank.
The formula I have so far is:
=COUNTIF({PoD}, ISBOOLEAN(@cell)) or =COUNTIF({PoD}, ISBLANK(@cell))
if I use the first formula it counts all the orders on the sheet, because its not checking if the box is checked or not. The second doesn't work because the column is a checkbox.
Best Answer
-
The ISBLANK should work, but generally I use slightly different syntax to say "is checked" or "Is not checked".
Is checked
@cell = 1
Is not checked
@cell <> 1
=COUNTIFS({Range}, @cell = 1)
=COUNTIFS({Range}, @cell <> 1)
Answers
-
The ISBLANK should work, but generally I use slightly different syntax to say "is checked" or "Is not checked".
Is checked
@cell = 1
Is not checked
@cell <> 1
=COUNTIFS({Range}, @cell = 1)
=COUNTIFS({Range}, @cell <> 1)
-
@Paul Newcome That's perfect, thank you so much!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!