Returning a Certain row from a table into a different table

Question

Hi All,

I have a workflow set up that when a form is filled out it fills out "Table 1" automatically.

In column A on the "Master list" there is the possibility of 12 different store #s that can be submitted. I want to make it so that whenever 1 is submitted it automatically populates into the correct table 2 based on the store # tab. For instance in Table 1 Row 44 is store # 9571, that goes to table 2 on tab 9571 and returns the same information. Then the next row in the 9571 tab would be row 47, but I can't get it to pull that next row since it is finding the same number that is in the first row.

I'm assuming I will have to make different formulas for each tab which is fine, i just need to automate the rows filling in on table 2 as the rows automatically get filled in based on the forms answers in table 1.

Thanks!

Anthony

Answer 1

Do you use comma as decimal separator? If so, try

=FILTER(Table1; Table1[Store #]=9571; "")

Answer 2

I copy and pasted that formula into A2 on sheet 9571 and it keeps giving me a "There's a problem with this formula". Attached is a snip of it.

Answer 3

In A2 on the 9571 sheet:

=FILTER(Table1, Table1[Store #]=9571, "")

where Table1 is the name of the table in the first screenshot.