Showing ideas with label formulas and calculated fields.
Show all ideas
Submitted on
Jan 06, 2020
07:02 AM
Submitted by
Olly_L
on
Jan 06, 2020
07:02 AM

It would be useful to be able to use a whole column as an array to use for Numeric functions. For example I could use a formula that shows how much variance there was in a number field from the Average, Max or Min of that field. Basically it would be the same functionality that is in the Summary Bar, but available in functions.
... View more
Submitted on
Nov 15, 2019
12:13 PM
Submitted by
Tom_Lucido
on
Nov 15, 2019
12:13 PM

I wish I could write formulas with line breaks so that it’s easier to read, comprehend, and modify. For instance, I wish the first formula could be written like the second. It currently returns an error.
Current:
IF(FIND( “engineer”,LOWER( {Collateral Title})) > 0, “Engineer”,IF(FIND( “engineer”,LOWER( {Overview / Short-form content} )) > 0,“Engineer”,IF(FIND( “engineer”,LOWER( {Preloaded Topic} )) > 0,“Engineer”,IF(FIND( “coding”,LOWER( {Collateral Title} )) > 0,“Engineer”,IF(FIND( “coding”,LOWER( {Overview / Short-form content} )) > 0,“Engineer”,IF(FIND( “coding”,LOWER( {Preloaded Topic} ))>0,“Engineer”, IF(FIND( “developer”,LOWER( {Collateral Title})) > 0,“Engineer”,IF(FIND( “developer”,LOWER( {Overview / Short-form content} )) > 0,“Engineer”,IF(FIND( “developer”,LOWER( {Preloaded Topic} )) >0,“Engineer”,"")))))))))
Desired:
IF(FIND( “engineer”, LOWER( {Collateral Title})) > 0, “Engineer”,
IF(FIND( “engineer”, LOWER( {Overview / Short-form content} )) > 0, “Engineer”,
IF(FIND( “engineer”, LOWER( {Preloaded Topic} )) > 0, “Engineer”,
IF(FIND( “coding”, LOWER( {Collateral Title} )) > 0, “Engineer”,
IF(FIND( “coding” , LOWER( {Overview / Short-form content} )) > 0, “Engineer”,
IF(FIND( “coding”, LOWER( {Preloaded Topic} ))>0, “Engineer”,
IF(FIND( “developer”, LOWER( {Collateral Title})) > 0, “Engineer”,
IF(FIND( “developer”, LOWER( {Overview / Short-form content} )) > 0, “Engineer”,
IF(FIND( “developer”, LOWER( {Preloaded Topic} )) >0, “Engineer”,
“”)))))))))
... View more
Submitted on
Nov 01, 2019
09:49 AM
Submitted by
Evos_World
on
Nov 01, 2019
09:49 AM

Having left Airtable a while ago I thought I would check back in to see if they had implemented these two features yet?
Sharing between bases has been requested from long before I even knew about Airtable, I think the dinosaurs were around when that first got requested, any news? Will it happen? Do they still ignore requests?
Another request was for using regex in formulas, any news on this?
... View more
Submitted on
Oct 28, 2019
05:57 AM
Submitted by
Mark_Pettit
on
Oct 28, 2019
05:57 AM

Please include “countif” and “sumif” functionality on the roll-up field reference. The “if” criteria could either be written manually or even better you could have an additional dropdown where you tick the relevant data you want summed or counted.
This would be incredibly useful.
Thanks!
... View more
Submitted on
May 16, 2019
09:52 AM
Submitted by
Ryan_Whitney
on
May 16, 2019
09:52 AM

I’d like to request a product enhancement to allow formula fields to take a value, and assign a plain text input on a formula field. Currently, you can go from text to number, but not the other way around. Use Case: We currently calculate date a project is overdue. We’d like to take that number and auto-update a formula field called Timeline Health. If date overdue is < 0, enter Healthy If date is 1-10, enter At Risk If date is > 10, enter High Risk
... View more
Submitted on
Jan 30, 2019
12:04 PM
Submitted by
Gert_Kohler
on
Jan 30, 2019
12:04 PM

Are there any technical scientific formulas at airtable? I need a solution for the triangle calculation of a right triangle at given distance and 2 angles. Analogous Excel =SIN(BOGENMASS(B2))/SIN(BOGENMASS(B4))*B1
... View more
Submitted on
Dec 21, 2018
06:47 AM
Submitted by
Florian_Kleinic
on
Dec 21, 2018
06:47 AM

Why isn’t it easy and intuitive to access elements from other tables. I could use a formula to show only elements of another table, that have certain attributes. For example, when I have a table Students, and I want to generate a new table young students, I could simply type: if(students.age<20, students, ””) How is something like this possible right now? Can it even be done since I really want to generate a table with elements that only fulfill certain criteria. I think it’s really annoying that you always need to use a lookup table where the relevant information of a connected table is pulled before you can use this information in a formula. It would be much better if Airtable would adapt the writing I used above, so all rows of a table can be accessed as members of the table name from outside. tablename.row By the way the formula field is really messy for a long, nested formula.
... View more
Submitted on
Nov 29, 2018
03:13 PM
Submitted by
Neal_Thornton
on
Nov 29, 2018
03:13 PM

My base is begging for a PMT or Payment function, but there isn’t one I can find… I am hoping someone has found a workaround to calculate a mortgage payment. Kind of critical to our client and sales processes. I realize this is not a spreadsheet, but other databases can do it.
... View more
Status:
Already in product
Submitted on
Nov 19, 2018
04:14 AM
Submitted by
Kofifus
on
Nov 19, 2018
04:14 AM

This is useful to look at the records you just or recently added. Thanks!
... View more
Submitted on
Nov 14, 2018
03:24 AM
Submitted by
Goce_Ristov
on
Nov 14, 2018
03:24 AM

What I find lacking over and over again is time when a field(not record) was last updated. Example: I have a field status. I need to know when the status was changed from In Progress to Completed. That way I can group all Completed tasks by month and calculate pay for this month. I think it is not too much to ask and it is a very basic and must-have feature for a project manager softwaer.
... View more