Showing ideas with label formulas and calculated fields.
Show all ideas
Status:
Launched
Submitted on
Mar 27, 2019
05:34 AM
Submitted by
DanielAssayag
on
Mar 27, 2019
05:34 AM

I have a condition that Inputs Boolean and outputs Boolean, and i wish to make it appear (format it) as a checkbox and not as a string “true” or “false” IF(Field1 = TRUE(), TRUE(), FALSE()) Thanks
... View more
Submitted on
Mar 25, 2019
07:16 PM
Submitted by
William_Yeung
on
Mar 25, 2019
07:16 PM

WORKDAY() is definitely one of the most critical function added for PM usage on Airtable - However I would sincerely ask if there is a plan for us to be able to really use a proper holiday table resource to supply the holidays list instead of using all sort of workaround?
... View more
Submitted on
Mar 10, 2019
06:02 PM
Submitted by
DanielAssayag
on
Mar 10, 2019
06:02 PM

Hi, Could it be possible to make a Lookup command so we can nest the lookup inside a conditional IF. Thanks !
... View more
Submitted on
Feb 14, 2019
04:21 AM
Submitted by
Daniel_Huggins
on
Feb 14, 2019
04:21 AM

Hi Airtable. I’d like the ability to override the contents of formulae-text cells with text of my own. I most commonly use this for record titling/naming. We use Airtable as a meeting/diary manager. So if we put in the people who attend, the formulate title could be “Roger meets David”, but we could override that title to become “Financial Planning Meeting 3”, say. You can think of it as “overriding” or as “defaulting” but the point is that there are lots of time when i want formula-based default titles which can be changed to something else later.
... View more
Submitted on
Feb 12, 2019
02:10 PM
Submitted by
Roman_Scher
on
Feb 12, 2019
02:10 PM

Currently the sort order of a single select field is only useable when records in the same table are sorted by that field. Very often single selects are looked up in another table, causing the sort order to be lost and the records sorted alphabetically instead. To preserve the sort, the current alternatives are to 1. Create a formula field in the destination table that prepends numbers to each option in the lookup, which is not so pretty and error prone if options or names in the single select ever change, or 2. Break out the single select field into a new table with an additional ‘Sort Order’ field, which has to be filled in for each record, then looked up in the destination table – usually overkill. Since sorting order is already baked into single select fields, it would be awesome for this sorting behavior to carry over to any tables that look that field up! I can see how preserving the sorting behavior of the single select may cause confusion as a user if you’re unaware that the source field is a single select, but that may be alleviated if the lookup was also formatted with the same colors as the original single select, similar to how lookups of linked records are now formatted the same as linked records.
... 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
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
Dec 20, 2018
01:44 PM
Submitted by
Kamille_Parks
on
Dec 20, 2018
01:44 PM

Right now, to format values pulled from a Currency field in a Formula field, users have to use something akin to the following formula to get “$65,756” to display as such. Otherwise, AirTable displays it as “65756”, no commas, no currency symbol: IF(
LEN(CONCATENATE({Trip Budget}))<4,
{Trip Budget},
IF(
AND(LEN(CONCATENATE({Trip Budget}))>3,LEN(CONCATENATE({Trip Budget}))<7),
LEFT(CONCATENATE({Trip Budget}),LEN(CONCATENATE({Trip Budget}))-3)&","&RIGHT(CONCATENATE({Trip Budget}),3),
IF(
AND(LEN(CONCATENATE({Trip Budget}))>6,LEN(CONCATENATE({Trip Budget}))<10),
LEFT(CONCATENATE({Trip Budget}),LEN(CONCATENATE({Trip Budget}))-6)&","&LEFT(RIGHT(CONCATENATE({Trip Budget}),6),3)&","&RIGHT(CONCATENATE({Trip Budget}),3),
IF(
AND(LEN(CONCATENATE({Trip Budget}))>9,LEN(CONCATENATE({Trip Budget}))<13),
LEFT(CONCATENATE({Trip Budget}),LEN(CONCATENATE({Trip Budget}))-9)&","&LEFT(RIGHT(CONCATENATE({Trip Budget}),9),3)&","&LEFT(RIGHT(CONCATENATE({Trip Budget}),6),3)&","&RIGHT(CONCATENATE({Trip Budget}),3),
)
)
)
) This is obviously inconvenient, and it doesn’t even take into account decimals or amounts greater than $999,999,999. I propose a new formula function that operates something like this: CURRENCY([number or field reference], [currency symbol]) => CURRENCY(12345.6,"$") = $12,345.60
... 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