For a formula that big, I’d recommend writing the formula out in an external editor – like notepad++ or something, and then copy-pasting it into Airtable’s formula editor. Writing big formulas inside Airtable’s built in formula editor is less than a joy.
I did something kinda similar in a base related to an online class that I teach. I wanted to tally my students’ votes on a few different options, and built a fun system of rollups, lookups, formulas, etc. In the end, I wanted a simple way of displaying the winning choice along with a list of who hadn’t yet voted. The actual data is in some hidden lookup fields, but I use the SWITCH trick to only show the pieces I want on specific lines.
Awesoooome, thank you so much guys!! My actual situation is soo much more complex, I’ve got keep inventory and purchase 200 items for 7 locations, so I went with the entity table and it makes it possible :grinning_face_with_big_eyes: