I am trying to solve the following problem:
One table lists all our available products, another table lists projects/jobs in which our products were used and sold for. A rollup on the inventory table counts how many times each product was sold.
But here is the problem - in the project/job table I have an option column that allows me to list a job either as “bid” or as “actual sale”. A custom view in that project table allows me to easily view bids and sales, but the rollup in the inventory table counts both options, bids and sales.
Is there a way to tell the rollup to only count sales and ignore bids? That to me sounds like a pretty standard database function, but I cannot figure out how to do it in Airtable.
I am really grateful for any advice.