My board is an order form set up like an excel spreadsheet. Currently it has Product 1 then Qty column across the board for each product. There are 20 different locations ordering on this form with each one indicating the date of order then choosing the item in the product box then the qty in its column. I want to be able to list all the products across the top with the qty beneath the product so I can easily see a total for each product. During a chat I was told that this is not possible, but I can’t believe it.
So just 20 number columns named by your products?
Sorry for late reply as I was out a few days last week. You are correct. I am trying to make the form easier to manage with the product columns showing the quantities so we can see totals at a glance while fulfilling order requests. Is this possible to do?