Hi Airtable Geniuses,
I am having trouble with something and I am at a dead end. I will try to explain best I can.
The base in question is a tracker for my Sample/Demo Chairs that I send out to clients.
I am trying to create a snapshot of the data in my “Lending History”.
I have created a table that links to my “Lending History”. From there I have used rollup to find the total # “Opportunities MTD” and total # “Chairs sent out MTD” using SUM.
Using the same linked information, I would like to calculate how many times a specific chair was sent out mtd by NAME since I have many different types of chairs. I would like to rollup the “Lending History” then take the “Chair Name” (which is multiple select) and COUNTIF that name appears.
I see COUNTIF is not available. How do I get around this? Any ideas? Is it even possible? Do I have to use a straight formula? I am at a loss.
Any advice would be great!