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



  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭


    Try this.

    =COUNTIFS({Parent Education Survey Classroom}; Center2; {Adult Education Checkbox Range}; 1)    

    The same version but with the below changes for your and others convenience.  

    =COUNTIFS({Parent Education Survey Classroom}, Center2, {Adult Education Checkbox Range}, 1)

    Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

    Did it work?


    Andrée Starå

    Workflow Consultant @ Get Done Consulting


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Kidco Head Start

    Hi @andreestara

    Thank you for the response! I tried using

    =COUNTIFS({Parent Education Survey Classroom}, Center2, {Adult Education Checkbox Range}, 1)

    however I get an #INVALID REF error. 

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!