Sergie_Magdalin - profile

Sergie_Magdalin · Dec 13, 2018

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...

Sergie_Magdalin · Nov 13, 2019

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 formul...

Sergie_Magdalin · Dec 13, 2018

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.

Sergie_Magdalin · Apr 11, 2018

We don’t need just a gantt view! The awesome thing about Airtable is that it allows you to organize and view data any way you want. The timeline is a great start because it’s the foundation of a gantt view, but imagine being able to group the records...

User Statistics

User Activity

Formulas for Blocks

Re: Formulas for Blocks

Re: Formulas for Blocks

Re: [SOLVED] Gantt view/Gantt chart capability