Formula to tell me how many times a word shows up, but only for a specific Review Board
Here is what I need:
Count how many times Strongly Agree shows up, but only when the Review Board is General Medicine TAG.
I have this to give me the # of times Strongly Agree shows, how do I ensure I only get this for "General Medicine TAG": =COUNTIF({Survey Intake - TAG Post Survey Range 2}, HAS(@cell, "Strongly Agree"))
Best Answers
-
The dirty way to do it is to add an IF:
IF([Review Board]@row="General Medicine TAG",COUNTIF({Survey Intake - TAG Post Survey Range 2}, HAS(@cell, "Strongly Agree")),"")
Or you can use COUNTIFS and add
[Review Board]@row, "General Medicine TAG
" to your formula. -
It sounds like you only want to Count the "Strongly Agree" in the other sheet if the other sheet has "Oncology Tag" (or a different tag), is that correct?
If so, you'll need to add in another criteria into your COUNTIF statement, making it COUNTIFS plural. I would even suggest you could take out the first IF and simply use the cell in [Review Board] as your value to search for:
=COUNTIFS({Survey Intake - TAG Post Survey Range 2}, HAS(@cell, "Strongly Agree"), {Column with Review Board in other sheet}, [Review Board]@row)
See: COUNTIFS Function
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
The dirty way to do it is to add an IF:
IF([Review Board]@row="General Medicine TAG",COUNTIF({Survey Intake - TAG Post Survey Range 2}, HAS(@cell, "Strongly Agree")),"")
Or you can use COUNTIFS and add
[Review Board]@row, "General Medicine TAG
" to your formula. -
@James Keuning It was working until I tried to use it for the other three groups. Am I doing something wrong? This one should come up "0" for all and it is pulling the numbers from the original one I did.
-
It sounds like you only want to Count the "Strongly Agree" in the other sheet if the other sheet has "Oncology Tag" (or a different tag), is that correct?
If so, you'll need to add in another criteria into your COUNTIF statement, making it COUNTIFS plural. I would even suggest you could take out the first IF and simply use the cell in [Review Board] as your value to search for:
=COUNTIFS({Survey Intake - TAG Post Survey Range 2}, HAS(@cell, "Strongly Agree"), {Column with Review Board in other sheet}, [Review Board]@row)
See: COUNTIFS Function
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
@Genevieve P. That worked - THANK YOU
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!