Forum Discussion
Formulas in form responses spreadsheets breaking on new responses
Hello all,
I've hit an unexpected snag with a forms response spreadsheet.
Form was created through onedrive, so that the responses go to specific spreadsheet.
I want to be able to create some dynamic info on other sheets.
In simple terms, even if I literally just do =forms!a2 etc on the second sheet to just mirror a column on a new sheet. As soon as a new responses is added, instead of the cell on second sheet showing the new result, it skips a row. So if the last response was in =forms!a2, when the cell below with =forms!a3 reacts to a new response, instead of just showing it, it changes the formula to =forms1!a4.
I assume it has something to do with responses spreadsheets extending tables on the forms sheet?
If that's made any sense, help would be appreciated.
(I'll add pics when on other laptop.)
6 Replies
emilym557 That's what I used. And it works fine. iferror is just to keep things clean. The table you're sending stuff too is probably going to be bigger than the table you're sourcing from, so I just like to have NAs and #VALUEs blank.
Does that make sense? Someone smarter than me will need to explain the use of @for table references as opposed to the Table [#all] methods. Not sure what the functional difference is between them, but they both seem to work.
