Help with formula - COUNTIF and ISBLANK

Options
laura.sandoval
laura.sandoval ✭✭✭
edited 03/01/24 in Smartsheet Basics

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

Answers