Equation Assistance for Metric Sheet - Counting Survey Responses

MindyM ✭✭
edited 04/12/24 in Formulas and Functions

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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!