Adding fields to Items list

GeorgeAllen

I am using the inventory with barcode scanner template. I know that the items list is an active dataset that is shared across the active files. I am comfortable using forms to add fields, but I wasn’t sure what changes we should be making to share those fields across all the files. I mainly am looking to add category and sub-category fields to the list which will help me summarize inventory levels with the those queries.

Karoline from Sheetgo

GeorgeAllen Hi George, we recommend always adding new columns on the right side of the sheet to avoid breaking formulas.
That being said, I’d create the category and sub-category for each product in the “ITEMS SHEET” Then, on the master sheet you can add new columns and work with “=vlookups” to match and bring the right info