COUNTIF Blanks From Metrics Sheet based on Status Column
First I have 2 sheets:
Sheet (data is collected from a Form)
Metrics Sheet (data from Sheet is counted so dashboard can be cvreated)
My counts have been working no problem. The formula I use right now is:
=COUNTIF({Workstream Name}, [Primary Column]@row)
But Now I need to count the number of blanks, without getting the blank rows at the end of the sheet. So like with Excel I thought an IF statement would work. However, this statement results in "Invalid Operation". I do not understand why this is happening. I want the count to be, based on how many records in the Status Field have an entry (or not a blank field), how many records in the Workstream field have blanks, otherwise enter 0.
=IF({Status} <> "", COUNTIF({Workstream Name}, ""), 0)
Sherry Fox
Business Process Analyst 3 | C5ISR Group
HII | Mission Technologies
EAP | Mobilizer | Automagician | Superstar | Community Champion
Original Smartsheet Profile: @Sherry Fox
Best Answers
-
You would use a COUNTIFS for this.
=COUNTIFS({Status}, @cell <> "", {Workstream Name}, @cell = "")
-
Happy to help. 👍️
Answers
-
You would use a COUNTIFS for this.
=COUNTIFS({Status}, @cell <> "", {Workstream Name}, @cell = "")
-
That worked like a charm!!!! Thanks for the super quick answer and a perfect solution! Greatly appreciate it!!!!
Sherry Fox
Business Process Analyst 3 | C5ISR Group
HII | Mission Technologies
EAP | Mobilizer | Automagician | Superstar | Community Champion
Original Smartsheet Profile: @Sherry Fox
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!