It's me again, with another question about setting up a sheet to feed into a form. I am creating a survey with Likert scale responses. There are 20 statements in total but broken down into four sections, or Pillars, (each Pillar has 5 statements) and the responses for each statement is on a Likert Scale:
1 (Rarely), 2, 3, 4, 5 (Always) - See pic below.
Currently, I have columns listed as "Pillar #" with the five statements filling the rows underneath. Wasn't sure if I was supposed to create 20 columns, with each statement having its own column. The statements were not transferring over to the Form, So I created the Form manually, by adding fields and the statements you see below. So the form looks right, but it's not functioning right.
I did a test survey and submitted it, but all I see is "1 Submission" when I click on the "Manage Forms" button. And the dropbox options somehow appeared on my sheet (see 3rd pic). I have no idea what's happening or how to fix it.
What I'd like to have happen is - at the end of each section/pillar (5 statements) there's a tally of the score so that respondents can see how they scored in that Pillar. Then I'd like to retrieve those scores myself for the purposes of discussion with the respondent. Anyway to have the submitted form come to me via email?
Thank you for your help.
