COUNTIF formula across multiple columns with same dropdown options
I have a COUNTIF formula across multiple columns in a range from another sheet with same dropdown options:
Formula: =(COUNTIF({Pipeline Status Inputs - MPP Delivery Assu All Are}, (HAS(@cell, "DA Not started / On hold"))))
The result is giving me a count of every cell with the "DA Not started / On hold" selection but I need just the number of rows that contain the selection regardless of how many times in the row is appears.
I tried to change to @row instead of @cell but received an Unparseable error -
Formula: =(COUNTIF({Pipeline Status Inputs - MPP Delivery Assu All Are}, (HAS(@row, "DA Not started / On hold"))))
I would appreciate any assistance with this. Thanks!!
Gina Alexander
Business Analyst Consultant, Client Delivery Assurance | Optum Insight Provider Market
M 1-702-218-0919
OUR OPTUM360 VALUES
Integrity Compassion Relationships Innovation Performance
Gina Alexander
Business Analyst Consultant, Client Delivery Assurance | Optum Insight Provider Market
Answers
-
@Galexa0711 You have a lot of superfluous parenthesis. Try
=COUNTIF({Pipeline Status Inputs - MPP Delivery Assu All Are}, "DA Not started / On hold")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!