Help

Formulas for Blocks

2398 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Sergie_Magdalin
5 - Automation Enthusiast
5 - Automation Enthusiast

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:

Screen Shot 2018-12-13 at 1.32.04 PM.png

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

3 Replies 3
Sergie_Magdalin
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

Chris_Forster
5 - Automation Enthusiast
5 - Automation Enthusiast

Would love to know how you set up the NPS system on Airtable. I have a form collecting feedback with one of the questions being the NPS per individual. How do you recommend going from there?
Thanks for all your help!

Sergie_Magdalin
5 - Automation Enthusiast
5 - Automation Enthusiast

We created a new field with the formula:

IF(Score < 7, -100, IF(Score > 8,100,0))

Then create a new view and filter by a specific time period that you want to calculate the NPS.

Then create a new block and specify that view, the field with the formula and choose “average”:

27%20AM

Hope it helps!