Formula Column Summaries

Stephen_Prior · ‎Apr 20, 2020

Right now if you have a column you can see the sum, average, median, min, max, range, and few other summaries of every record in that column. One thing I think would be very useful for formula columns is to apply that formula to all columns. So if the formula for column 3 is Column 1 / Column 2… then the summary applies the same formula to the sum of column 1 and the sum of column 2. The closest thing that I can come up with is “average” but that isn’t accurate.

ScottWorld · ‎Jun 03, 2020

Sadly, the ARRAY functions don’t work in the way that people are expecting them to work in Airtable. And that leaves us with unresolvable problems in Airtable. The ARRAY functions work under a very limited set of circumstances, but it says right on the formula field reference page that they are supposed to work with lookup fields, rollup fields, and linked fields as an input. This just isn’t true, as you can see from this thread here. ARRAYJOIN, ARRAYFLATTEN, ARRAYCOMPACT, and ARRAYUNIQUE simply do not work under many common scenarios — even when feeding them the “approved inputs” of lookup fields or rollup fields. The ARRAY functions seem to only work when you have one input only, but not multiple inputs — even though the examples on the formula field reference page all show multiple inputs. For example, this problem remains unresolved, because the ARRAY functions don’t work as documented. Airtable Team: Please revisit these ARRAY functions and make them work under all circumstances. (And instead of changing the Airtable documentation to downgrade the functionality of the ARRAY functions, it would be better to FIX THE ARRAY FUNCTIONS so that they work as expected.) Thank you! 🙂

George_Copelan1 · ‎Sep 19, 2019

The challenge: Not being able to combine rows together with clean separation. The solution: The ability to use a formula like this =TEXTJOIN(" | ",TRUE,AQ2:BJ2) This would be a HUGE help for me (and I’m sure many others).

mtrifiro · ‎Jul 19, 2018

It would be very useful to surface the following record info into a formula: Created by (name) Last edited by (name) Last edited (date)

itoldusoandso · ‎Oct 11, 2020

Airtable needs to replicate how Excel helps with formulas: Highlight elements of the formula and show brackets in different colours and different formulas in different colours Provide basic guidance… if a bracket is missing, then tell me it is missing and suggest me where it should be and ideally perhaps show a tally of brackets I add so I can later see how many closing brackets I need to add without having to go through the formula and recount the brackets; If there is a circular reference, then show me the parts that are involved; If there is a missing argument in a formula, then show me where is the missing argument, and perhaps suggest what argument is missing; some of the formulas are specific to AirTable requirements e.g. VALUE() and BLANK(), often these are used to deal with errors in other formulas, so I would appreciate if AirTable could suggest how to fix typical errors e.g. non-number argument in a formula that requires a number and so on… When creating new formula the window shows the sample format, but clicking on the individual argument doesn’t take me to the part (and highlight the part) of that argument in my formula. I could go on and on…

Aaron_Vreeland · ‎Sep 04, 2018

The group nesting and sum features in Airtable are slick and potentially very useful, but not being able to display a weighted average in the groups’ summary bars is really painful. The solution to this problem appears, at least to me, to be very simple: Just implement an option in the summary bar pulldown of formula columns to apply their formula across the summary bar. The existence of this feature will probably make or break whether our company will use Airtable.

Dimitri_Zakharo · ‎Jun 11, 2020

I’d love to have dynamic text in a form. For instance, the subheader can reference a cell, or use formulas like COUNT.

Michael_Chou · ‎Aug 14, 2019

Is there a way to add a prefix or suffix to a number entry. Really important feature!

Karl_at_Easy_La · ‎Sep 10, 2023

This is very useful for multiple nested conditions, and is basically a string of multiple IF-conditions, with the 'ELSE" condition being another IF. The google sheets documentation for the IFS function clearly explains this. It would be very helpful to make long nested formulas much more readable! Thanks for the great work with Airtable 🙂

Stephen_Orr · ‎May 05, 2023

What is the proposed idea/solution? It would be a game changer when working with hierarchical data for the roll-up field's ARRAYUNIQUE(values) function to return clickable linked record values instead of a comma-separated string when aggregating a linked record field from the source table. Currently, users can only represent one level of a linked record hierarchy as linked record values using lookup fields without risking duplicate linked record values. Multi-selected linked record lookups/roll-ups can lead to confusing UX and fewer group-by options. How does is solve the user problems? This would serve as a workaround for the strange user experience that occurs when using a roll-up field to return a lookup field of multi-selected linked records. This can duplicate of the same record referenced in the roll-up/look-up field. How was this validated? For example: Let's say you have a base with three tables containing linked records in this hierarchy: Dashboards -> Data Sources -> Tables and you want to see a list of Dashboards related to each Table. In Tables, you would normally create a lookup field to a linked record field in Data Sources that is linked to Dashboards. The duplicated values problem occurs when a single table record is linked to multiple data source records, which are also linked to multiple dashboard records. This results in duplicated dashboard records appearing in your lookup field (which creates confusing UX in general, but also makes grouping by this field even more problematic than usual for multi-selects). Who is the target audience? Intermediate base builders, everyone.

Formula Column Summaries

Product Suggestion: Please fix ARRAY functions

TextJoin! Let's make it happen! <3

Provide formulas for created by and edited by

Make formula correction suggestions and highlight formula elements

Apply formulas across summary bars

Form text to reference table

Prefix Suffix to number entry

Implement the IFS function, like in Google Sheets

Roll-up ARRAYUNIQUE(values) should return distinct expandable linked records instead of CSV text

Format Formula as Checkbox

CSV Import in Interfaces

React to Record Comments

Allow Emoji reactions to comments

Multiplying by percent column yields result that i...