Formulas for Blocks


I’m running into limits in Blocks. I want to be able to create formulas beyond just SUM, AVG, MEAN and other standard formulas. For example, I want to look at all the data from my NPS survey and calculate the NPS score automatically using the Summary Block. But these are the only options I get:

Is there any way to run calculations on the entire data set? Seems like Airtable doesn’t support this.


Actually, looks like I can fake it by creating a formula within each row and then getting an average of that. It’s backwards but I think it could work.