Forum Discussion
Help with MS Forms Responses in Excel
I have created a MS Form with 35 Yes or No questions. Each Yes question has a certain numerical value that I need to tally and report on. I did do an IF statement, and it works, but I think it...
Hi NikolonoDE! Thank you for this response. I am trying to figure out how it will work. My current situation is:
I have a form with 36 questions, which could grow by 10 more over the next year. It's actually a process assessment.- On the first tab, the Form responses are captured with their answer of Yes or No.
- The second tab has the question number, and the value if the answer is Yes. Then I start with a formula, =IF(Form1!F5="Yes",3,0) that fills in the value for the 36 questions.
- The third tab breaks down each section of the assessment (Level 1, 1.5, etc.) Each section needs a certain value to be considered a Pass, else it Fails, =IF(D5>=5,"PASS","FAIL"),
- The answers from the Form are horizontal and begin with ID, email, start time, etc. The actual questions don't begin until column F.
I've attached some screenshots for reference. Thank you so much!!!!
As variant you may to the structured table on first tab which collects form responses few other columns. That won't destroy automatic update of this table.
In additional columns you may do calculations (using structured references) for number of Yes, PASS or not PASS, whatever. That will be updated with each new response added.
On another sheet(s) that could be summary, aggregation, dashboard, what you need to show based on table data.