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?
The xlsx file type was not supported for uploading a sample, but perhaps there's another way of doing it?
I'm sending you a personal message. You should be able to respond to that message directly to me, attaching a copy of your file to that response, sending it back to me that way.
Look for it by clicking on your avatar at the top right of this forum page.
- Thanks! I've sent a copy of the file to you now.
joakimgg did you ever find a solution to this issue? I'm having the exact same problem but haven't been able to find anybody that has successfully solved it! Thanks so much in advance!
- If my memory serves me correctly, this was solved by discovering an error in the formula that was doing the calculations.
