Creating Formula to COUNTIFS two referenced columns from another sheet.
I'm attempting to create a formula that COUNTIFS two columns from a referenced sheet and am having no luck. Here are the two I've tried:
=COUNTIFS({Start Date}, 0, AND({Not Applicable}, 0)) Error - #Incorrect Argument Set
=COUNTIFS({Start Date}, 0, AND({Not Applicable}, 0)) Ends in a total of 0
The 0 isn't a true result.
References are as follows:
Start Date - a date field, I want to count how many are blank
Not Applicable is a Checkbox field, I want to count how many are not checked
I want the total if both conditions are met.
Best Answer
-
I think you've actually overcomplicated it, which is good because it is much easier to simplify than to add complexity.
COUNTIFS in Smartsheet formulas is, by its nature, and AND formula. What you're doing is saying COUNT IF a AND IF b. So you don't need the AND function for the formula at all. I think what you're looking for is:
=COUNTIFS({Start Date}, ISBLANK(@cell), {Not Applicable}, false)
Answers
-
I think you've actually overcomplicated it, which is good because it is much easier to simplify than to add complexity.
COUNTIFS in Smartsheet formulas is, by its nature, and AND formula. What you're doing is saying COUNT IF a AND IF b. So you don't need the AND function for the formula at all. I think what you're looking for is:
=COUNTIFS({Start Date}, ISBLANK(@cell), {Not Applicable}, false)
-
Works perfectly!
-
Awesome! Glad it's working.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!