Forum Discussion
Formula/method to link the data/responses I get from my forms into a different table.
Hi everyone! I need help with a project that I'm creating. Im making use of Microsoft Forms in order to input certain information. I made use of branching since some answers depend on the previous choice. So moving on to my problem, I want my table2 to get the responses/data from the data table created by the forms.
Table 2
Table of responses
For reference for the spill error, here is the formula that I used.
Any insights will help a lot. Thank you have a great day everyone.
1 Reply
so the problem is that "Responses[When was this transaction made?]" refers to that entire column of that table and therefor that IF statement is trying to output an array of results. It appears that formula is in a table of its own and array output are not allowed in a table.
if the tables line up the simpliest answer may be to add the @ symbol to tell excel to use the corresponding row of the array/table:
Responses[@[When was this transaction made?]]
That said the better way is to either expand on the response table and make your calculations there or just pull the whole table and perform whatevere filter/calculations you need and spill the whole table/set of data all at once.
