Count if - Text
Hi,
Can you please help me to figure out why this formula is returing 0 while the range contains this text? =COUNTIF([Data]:[Data], "*Risk01*") The range is a drop down column allowing selection of multiple risk. I'm looking to obtain a number how many times each risk was selected. Risk01 is not the full text, only part of a sentence.
thank you
Answers
-
It's not working because you need the full text in the parenthesis. If you are trying to use a shortcut by looking for a part of text, you can do =COUNTIF(Data:Data, CONTAINS("Risk01", @cell))
-
thank you Eric, unfortunatelly it's still not working. I'm unable to put the full text as in some instances we can have multiple risks mapped while I'm interest in number of incidents mapped to each risk. I'm using a help column with =IF(CONTAINS("Risk01", [Data]@row), 1, 0) but it's polutting my sheet (we have over 50 risks). This information is feeding to a sheet summarry that feeds to a dashboard and I feel like I'm complicating things unnecessary
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 358 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 135 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!