Equation Assistance for Metric Sheet - Counting Survey Responses
Hello -
Can someone help me with an equation? I have a From that I'm using as a survey where I have collected answers to 4 questions with the options: Strongly Agree, Agree, Neutral, Disagree, Strongly Disagree. I want my equation to count how many of each answer we received per question on a metric sheet so I can display the data on a Dashboard. This is the equation I have but it's not working. What do I need to fix?
=COUNTIF({BLT Lite Survey - 2024 Range 2}, [BLT Lite Process and how to drive ITR Scores]:[BLT Lite Process and how to drive ITR Scores], HAS(@cell, "Strongly Agree"))
Thank you for the assistance!
Mindy
Answers
-
Hi @MindyM
If you're in one sheet looking at another sheet, you only need the one {cross-sheet reference} 🙂
Try:
=COUNTIF({BLT Lite Survey - 2024 Range 2}, "Strongly Agree")
If you have the status options listed down a column in this metric sheet, you can reference the cell instead of typing out the "words" so you can drag the formula down into new rows and have it auto populate:
=COUNTIF({BLT Lite Survey - 2024 Range 2}, [Text Column]@row)
Here's more information: Create cross sheet references and Create a cell or column reference in a formula
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
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!