Formula error when filtering an unchecked flag column & filled cell (in column)
Hi,
I've been trying to complete a formula that counts the number of unchecked flags when a cell states approved.
Here is my current formula that responds with UNPARS
=COUNTIF([Pause New Grp Reg Reminder]:[Pause New Grp Reg Reminder], OR(1, 0), AND([Facilitator Status - Certificate Completed]@row:[Facilitator Status - Certificate Completed]@row, 1, 0))
Here is a screen shot of the columns
I know my this portion of my formula correctly counts the unchecked flags: =COUNTIF([Pause New Grp Reg Reminder]:[Pause New Grp Reg Reminder], OR(1, 0)
But I then only want to count the Facilitators that have been Approved.
Thanks for you insights!
Char
Answers
-
As a second note, I need to understand why my formula isn't working for Approved facilitators with flags.
So I need Approved facilitators with flags; and Approved facilitators without flags.
Thanks again!
-
Try this:
=COUNTIFS([Pause New Grp Reg Reminder]:[Pause New Grp Reg Reminder], @cell <> 1, [Facilitator Status - Certificate Completed]:[Facilitator Status - Certificate Completed], @cell = "Approved")
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!
-
Works wonderfully. Thank you.
I'm now trying to figure out the formula where the the Facilitator Status row is blank. I tried "" but the counts are not correct.
-
Are they consistently ten more than what it should be?
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!
-
No. For some reason the count is off.
There are 49 applicants accepted.
There are 25 applicants accepted & are now approved facilitators.
Therefore there should be 24 non-approved facilitators (not 25).
Here's my formula: =COUNTIF([Facilitator Status - Certificate Completed]:[Facilitator Status - Certificate Completed], <>"")
-
Your formula is counting rows where the cells within the range are not blank.
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!
-
I have tried this formula and still can't get the count correct. Based on my filter (which is correct at 29 [59-30]), I'm not sure what is wrong with my formula. I have tried it several ways and even used University to see what others have done. Help!!
=COUNTIF([Facilitator Status - Certificate Completed]:[Facilitator Status - Certificate Completed], ISBLANK(@cell))
-
What is the count you are e getting with the new COUNTIF, and what exactly are your filter settings?
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!
-
The count I'm getting with the COUNTIF is 43 ???
The filter settings
-
What happens if you delete the rows below your last row of data? Not just clearing out the cells in those rows but using the row menu to delete the rows?
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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!