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

gina.alexander1@optum360.com

OUR OPTUM360 VALUES

Integrity Compassion Relationships Innovation Performance

Gina Alexander

Business Analyst Consultant, Client Delivery Assurance | Optum Insight Provider Market

gina.alexander1@optum360.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!