Forum Discussion
Shepperdd
Dec 12, 2024Copper Contributor
Table Data
So we plan to use this table to enter the inventory that we have in stock as well as anything we receive. When we enter data into this table, the data need to go into another table based on the cage selected in the cage column. I have managed to get the data to go into another table but I am running into an issue where the data enters into the other tables in the same row it is in on this table. See pictures below.
The code I am using is =IF(InventoryList[@[Cage '#]]="Cage15", InventoryList[@Serial], "") with edits to match the columns. Can someone help me fix this?
You might use the FILTER function, but that won't work in a table, so you'd have to convert the table on the Cage 15 sheet to a range.
Remove all existing formulas and values from B5:G5 down.
Enter the following formula in B5:
=FILTER(InventoryList, InventoryList[Cage '#]=B2, "")
The formula result will spill to 5 columns and as many rows as needed.