I have an AirTable of product specifications for various hotel properties.
Table 1 - List of Properties
Table 2 - Rooms Matrix (each room, type of TV, TV Mount, Bed Type, etc)
Table 3 - Product Specs
In Table 3, I have a column: “Count based on:” to link to options Guestroom, TV, Bed, etc as certain specs total qty’s need to be based on total number of rooms (as every room gets one) or based on # of King beds (king sheets) for instance.
I would like the final qty column to calculate the qty based on which Property the spec applies to (Column 1) as well as on what the count should be based (“Count Based On:”, Column 23) and roll up the total.
Example: I have a Radio that goes in Suites for any property. I would want to select Suites in “Count Based On:”, then have formula reference column that it is present at every property and also that it is present in only suites, pulling count of suites from the Rooms Matrix table.
Welcome any suggestions on how to do this or how to reorganize my data. Thank you!