Compiling Survey Results

Kidco Head Start
Kidco Head Start ✭✭✭
edited 12/09/19 in Formulas and Functions

Hello All,

There's a survey we ask people to fill out so we can better provide services. There are 32 specific locations and a long list of questions. I'd like to compile all of this information into a metrics sheet, and in the end create a dashboard. 

By some miracle was able to tally how many times the specific location was selected. 

=COUNTIF({Parent Education Survey Classroom}, Center2)

I'd like to be able to break it down even more by location and weather or not the option was checked. I don't know how to write the next expression needed. 

I've attached a couple images. 

Thank you in advance for any information provided.


survey sheet.JPG



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!