Forum Discussion
MS Excel formula "skips" row based on input from MS Forms
Thank you for your response!
The document is directly connected to my Microsoft Form, since it was created through "forms for excel" in sharepoint.
Every time a new response is submitted, a new row is added to the "RawData" table. What is want to achieve is: making the formula in the separate sheet reference the correct row, without having to "drag" the formula downwards manually.
The issue is that every time a new row is added automatically, the row is not added in the separate calculation sheet.
All questions have the same possible responses, and I would like to be able to measure averages etc.
The xlsx file type was not supported for uploading a sample, but perhaps there's another way of doing it?
joakimgg Hello, my spreadsheet continues to skip. Was there a resolution provided?
The original was so long ago....I gave you already my best recollection. Might I suggest you'd be better served by starting a new thread with your question and posting your spreadsheet if possible so we could take a look at it.
