Showing ideas with label formulas and calculated fields.
Show all ideas
Submitted on
Apr 30, 2020
11:33 AM
Submitted by
Michael_Andrew
on
Apr 30, 2020
11:33 AM

It would be great if Airtable had a STDEV roll up field. I would think it would be easy, since the calculation is available (you can set the field summary at the bottom to stdev). To create a manual formula is difficult with variable data otherwise. Please add these feature (as well as other statistics that are already available and calculated in the summary at the bottom of the field).
... View more
Submitted on
Feb 24, 2020
11:44 AM
Submitted by
Kevin_Li
on
Feb 24, 2020
11:44 AM

Grouped records and the summary bar - functionality here is great, but the only way to sort the grouped records is by the order of the grouped by field options. I’d like to be able to sort by the numerica values in the summary bar (e.g. revenue or # of records)
... View more
Submitted on
Jul 25, 2019
09:44 AM
Submitted by
Zollie
on
Jul 25, 2019
09:44 AM

The formula field reference is missing the most basic array functionality - retrieving information based on index. If implemented, there are many use cases. Here’s one: Assignments collaborators Amy, Peter, Tanya Stage number (int) 2 Current Assignment formula {Assignments}[ {Stage} ] => Peter
... View more
Submitted on
Feb 12, 2019
12:57 PM
Submitted by
Roman_Scher
on
Feb 12, 2019
12:57 PM

It can be difficult to understand what someone’s formula is doing when the editing window is so small and the formula is huge, spanning many lines and wrapping many times, sometimes with deeply nested IF statements. It would be great to have a larger space to view and work with the entirety of the formula, especially if the formula is also prettily formatted and structured to make it more readable!
... View more
Submitted on
Apr 02, 2019
09:58 AM
Submitted by
Jeffrey_Bowdoin
on
Apr 02, 2019
09:58 AM

It would be nice if we had a global filter that we can apply to all the views. You could have the option of having a filter per view as it is, but another feature of a global filter that affects all views. My use case is an editorial calendar with multiple sites. I still need the individual views to have different filters, but it would be nice to have a global filter to only show one website I am working on, while going to each view. This would be an easy, yet very useful feature. One that probably a lot of people wouldn’t realize how useful it is until they tried it.
... View more
Submitted on
Jun 17, 2020
04:33 AM
Submitted by
Chris_Polus
on
Jun 17, 2020
04:33 AM

I’ve seen questions if formulas can access other tables, and it’s a no. Workaround is that you use lookup fields and calculate with those fields from within the same table. But this very quickly clutters the table with fields from other tables, only to get them into a formula. Our tables quickly grew and got really messy.
I’d like to skip one step and directly access other tables in formulas:
{DesignTable.TimeEstimation}+{ProgrammingTable.TimeEstimation}
This would de-clutter a lot of tables for us. Since I haven’t found a feature request for this, I’d like to request it here.
Thanks! Chris
... View more
Status:
New Ideas
Submitted on
Oct 01, 2024
03:02 AM
Submitted by
SamGluck
on
Oct 01, 2024
03:02 AM

What is the proposed idea/solution? Currently we've got the option of formatting a formula field as a single select, I'd like to format it as a muliple choice How does is solve the user problems? I'd use this feature for labeling records with what fields still need to be filled. Lets say the Name and Email fields are empty, it would show at the top of the record red labels of what information still needs to be filled in the record, and as you enter the info, the labels disappear. Yes you can use automations with a script for this, but it doesn't work instant. it takes 10-15 seconds per run. using a formula would be instant.
... View more
Status:
New Ideas
Submitted on
Jun 06, 2023
09:55 AM
Submitted by
Danarone
on
Jun 06, 2023
09:55 AM

What is the proposed idea/solution? A Project Archive Feature to make it easy to 'deactivate and hide a project when certain criteria are met. An archived project would be grayed-out, hidden completely everywhere in the base or moved into an Archive Table. It would no longer affect any rollups or calculated fields. To make it active again, the user goes to Archive settings, click 'Show Archived Projects' then changes the criteria back to active. How does is solve the user problems? Current solutions only hide the project from view. it is still active and you need to consciously filter it from view everywhere in the base. Or you need to manually copy the project to an Archive table and delete from active which is tedious. How was this validated? No validation has been performed. Who is the target audience? Project managers with multiple projects that have a lot of fields/data. Their organization is known to pause or cancel a project and re-activate it again at a later date. Or they simply want to save old projects for reference.
... View more
Status:
New Ideas
Submitted on
Mar 07, 2023
07:47 AM
Submitted by
estevamfurtado
on
Mar 07, 2023
07:47 AM

I think it is time for Airtable to add recursive capabilities to data inside a table. I know it is challenging to implement, but the workaround users have been doing are truly not delivering the intentions and expected experience. It just feels limited not to be able to create subtasks, goals and subgoals, accounting systems, etc. There are so many ideas that would be finally unlocked and it would definitely take Airtable to a whole new level!
... View more
Submitted on
Apr 26, 2020
08:47 AM
Submitted by
ScottWorld
on
Apr 26, 2020
08:47 AM

This post inspired me to make this product suggestion. We already have the DATETIME_FORMAT function, which lets us use a formula field to reformat the data from a date-type field into a text string of our specifications. But it would be really great to have that exact same ability to reformat a number field or a currency field into a text string of our specifications. For example, take these 2 fields: Currency Field — formatted as currency with $ sign and precision of 2 decimal points Number Field — formatted as decimal with precision of 4 decimal points If we put these 2 fields into a formula that results in anything other than a single number result, they lose all of their formatting. So instead of a desired sentence which looks something like this: “You bought 0.4500 pounds at $2,200 each.” The formula currently looks like this: “You bought 0.45 pounds at 2200 each.” We can easily add in the dollar sign, but adding in the commas and trailing zeros is harder to do in a calculation.
... View more