Is there a way for me to Reference the Summary bar that is built into Airtable in another column with a formula?
I know AirTable doesn’t have normal sum function (which makes my job so much harder) but I didn’t know if I’m missing an option or an extension that can reference those Airtable built in summary bars?
I want the formula to be something like:
If column Part name = xxx-xxx-1315-xxx, then reference summary bar of column QTY used, then if that sum is equal to 1,000, then “Correct” if not “incorrect”.
I need to be able to do this with quantities that match 4,6,500, and 1,000. I currently use a switch function to achieve something like this with a very basic formula, but if we receive part numbers with different lots and they don’t total to one of my set numbers, it looks like it’s incorrect (but it’s not-it just has different quantities that all collectively should total to 1,000)
Furthermore, rolling up data in to a separate column will require me to have 8 different tables that rolls up 8 different sums of different part numbers and that’s just too much data for my employees to have to deal with on top of having to manually drag that SUM column I create (based on this article) every-time they create a new record. It’s just not adequate for what we need.
Any help, or suggestions would be appreciated. Trying to move away from Excel as I don’t like the fact that I can’t prevent people from editing my formulas in columns that have items they need to edit data on + it doesn’t have great traceability.