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 ...
Davidm54 do you mind screenshotting or elaborating a bit further? You're tackling exactly what I'm looking for!
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.