Help with formula - COUNTIF and ISBLANK
Hello! I'm looking for help with a formula that is on a dashboard metrics sheet that is summarizing some numbers. I took a screenshot of the formula — essentially I'm looking to count all the # of sites in a specific Cohort but I also want to make sure it doesn't count any sites that are marked inactive in the main sheet.
I took a screenshot of the dropdown "inactive status" column in the main sheet. I'm stuck on how to write the formula...I use the "ISBLANK" one right?
So:
=COUNTIF({Master Data Sheet Group Assignment}, HAS(@cell, [Primary Column]@row), {Master Data Sheet Inactive Status, ISBLANK
and do I put @cell? what do I reference here?
please and thank you!
Best Answer
-
You need a COUNTIFS (with the "S" on the end) to allow for multiple range/criteria sets.
As for the ISBLANK and @cell question, the @cell goes inside the ISBLANK function.
{Range}, ISBLANK(@cell)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
You need a COUNTIFS (with the "S" on the end) to allow for multiple range/criteria sets.
As for the ISBLANK and @cell question, the @cell goes inside the ISBLANK function.
{Range}, ISBLANK(@cell)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
This worked thank you!! I get caught up in the little things, I appreciate the help :)
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 371 Global Discussions
- 203 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives