Forum Discussion
Formulas in form responses spreadsheets breaking on new responses
Davidm54 Well, to answer my own question: I must have manually typed formulas for reasons. If you put = in the cell you want, then select the heading of the column you want in a table. It does it right!
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.
Hopefully you can see this now.
- Sorry, only just saw this. I'll try and nab screens. (I'm three sheets ahead of this now, so I need to find which one I was referring too.)
