Excluding data from a linked sheet

I have many categories in my products(PO) section, but do not want the goods categorized as “service” and “maintenance” to be ported over to the inventory section.

Is there a way to write a script like in Sales Product where these two categories of items will not be listed in the inventory?

You may consider apply fixed filter with the query according to your category field.

1 Like

For the company I am with, we have inventory split into multiple categories as well. Because they need to be separate, we have two separate subtables. Each of these subtables load into their own sheets. They both affect the total available, total on hold and total sold balances.

Do you think this might work for what you need? I could go into more detail with screen shots if needed!

1 Like