Formulas

Multi-select fields containing a value with a " (double quote) in it yield unexpected results with formulas—essentially because Airtable seems to escape double quotes in arrays with another double quote rather than a backslash or something else. Here’s a series of formula results on a multi-select field named {multi} containing a single option with the value: 6" Bar Pull Formula: {multi} Result: “6"” Bar Pull" Formula: FIND('6" Bar Pull",{multi}) Result: 0 Formula: FIND(‘6" Bar Pull’, REPLACE(multi, FIND(’""’, multi), 2, ‘"’)) Result: 2

How do I reference a second table in a formula? I need to sum all the values of a column in a second table and then divide it by a rollup of a records associated values in that column. What I am trying to do: I have an event where all the people attending are in one table. I have another table where I have all the receipts people submitted for things they had to pay for and there’s a link between the two. (IE, attendee x paid for receipts A, B and F) What I want to do for each attendee on the attendee table is sum all the values of the receipts, divide it by the number of attendees and and subtract the total receipts that attendee already paid for. That way I can get an average cost that each person needs to pay for their “share” and automatically subtract what they’ve already paid. Thanks for any help.

Hi, I am trying to replicate payout from server. The server calculates 34.9345 as 34.94 but on airtable it gets rounded off as 34.93 What should I do to make sure it gives the same value 34.94? Thanks in advance Regards, Gokul

Hi, Trying to add Minutes to a DateTime seems not to work when the minutes comes from another column. Col1 : DateTime Col2: Duration in Decimal (ie: 3.5 for 3h30m) Col3: DateAdd(Col1,Col2*60,‘minutes’) Result: Col3 = Col1 If instead of using Col2 in the second parameter, I use a constant value (ie:210), then it works. If I create a Col4 as a formula of Col2*60 and then use Col4 as the second parameter of DateAdd, then it’s also not working. Am I doing something wrong? Cheers, Berni

For us newbies, is there a place where users are posting tips and techniques? For example, I finally came up with a formula to determine someone’s age if you have their date of birth. DATETIME_DIFF({D.O.B.}, TODAY(), “days”) / (-365) Anyway, just thinking that there are a lot of experiences users who might want to share their own tips.