Formulas

Hi All, I’m trying to use LEFT() to convert the following input: 2020-09-30T17:30:00-04:00 to 2020-09-30 Can anyone help me with it? Thank you.

hi everyone, is there a formula that can compare 2 dates (a due date and the completion date of a project) and fill in if it was finished on time, early or late?

Hi there, I have table named “Groups” which contains fields about a Group Therapy Session along with two Lookup columns to another table called “Session Master” which contains the materials(i.e. books) used for the session in the group. Now, in the Session Master table the fields to which the Group’s lookup columns are pointing to are named “Pre-Session Materials” & “Post-Session Assets” respectively. Those two are actually links to multiple records of another table named “Content Library”. What i want to do is to find all the Records from both the Pre

I have a formula set up to calculate and display whether a customer has paid for the product they’ve taken in full, and, if not, how much they still owe. It looks like this: IF(SUM({Cases Out}*60-{Money In})=0, “Paid Up”, “Owes $” & SUM({Cases Out}*60-{Money In})) It works, but the problem is that Airtable seems to take a long time to calculate the answer. When I update the Cases Out field for instance, it’s common to see the output from this function go through two or three “intermediate” answers, where it will display one number, then another, until finally it gets to the right final result. It isn’t a big deal, but it takes a few seconds and makes the user initially feel like it isn’t working right at all. It’s also strange: why is a simple calculation taking so long? I’ve never seen a function output be anything less than instantaneous in Excel or Google Sheets. Is something about the way I’ve written this taking an outsized amount of processing resources?

I need to add an additional carriage return within this formula where the red maple leaf is in the below formula. I’ve tried multiple different ways but I’m unable to find success. If anyone has any solutions would be most appreciative!!! CONCATENATE(Patient, “\n”, DATETIME_FORMAT(SET_TIMEZONE({Start Date}, ‘America/New_York’), ‘LT - dddd :maple_leaf: MMM DD/YYYY’))

Hello everyone, I would like to have a formula column in a table where I have a code name as the first column today. This formula should check the code and give me a determinated result. Today my codes are SFPAPXXXXRI004, or SFPAPXXXXBA005. I would like a column that says “Ring” if there is an “RI” on the code or “Bracelet” when there is a “BA” and so on. Is this possible. Many thanks for your help!

I am new to airtable and trying to complete a table that has a single select choice in column A for make of the car and I want to have a single select choice in Column B that is contingent on the choice made in Column A…i.e. If Ford is chosen in Column A, then the only choices that are present to you in Column B are Explorer, Escape, Expedition, Fusion, Mustang, Thunderbird. But if your choice in Column A is Mercedes then the choices you have to choose from in column B are C Class, E Class S Class, or SUV, etc thanks shari

We have a field called Products which is a link to our “Product” table We have a field called Cost which is a lookup field. (looks up the cost from the Product table) In our “ORDER” table, we have a field called Total Cost In that Total Cost field we would like to multiply the Cost by the Qty (quantity) but if there is a value in the Misc Cost field then we would like to multiply that field by the Qty to calculate the Total Cost Here’s the kicker… Basically, we want to use the Misc Cost to override the Cost x Qty total, if there if something is entered in that field. Usually a product is full price for us. Sometimes we get a massive discount on a certain quantity or we get some of a product for free. I still want to link to

I read several posts on what I hoped was this if/then topic, but there are *so many if/then questions out there and I still didn’t find my answer (it all depends on my own keywords, of course). Please combine this into the right thread if it already exists. I need to track a biannual speaker event into am/aft/eve sessions over 2 days. I have info duplicated because: I’m still in the experimentation phase to see which formats work best I need the info to be sortable/filterable/analyzable in many different views any columns can be hidden as long as the essential result is achieved (yes messy but I’m an amateur) I’m looking for a way that a checkmark in one of 5 columns returns a unique label in one column. I’m fine if the labels are returned in text form or multiple selection form; that’s less important. I figured out the if/then assuming an on/off for one column, but I’m lost as to how to create an if/then for on/off between 5 colum

In {#Gew uit} i want to know how many times 25 (= teamnummer) is in {resul.gew.wedstr.uit} I don’t know what formula to use. I tried FIND({teamnummer}, {resul. gew. wedstr. uit}) but that counts all the nummers.

I have a duration/run time field I’m importing, currently stored in Milliseconds. Anybody have a quick formula to help convert that to mm:ss? Thank you.

I am trying to create a priority score for a team travel destination based on a series of checkboxes. This is what I tried: SUM(IF({1 Must Do}5,0),(IF({2 high on list}4,0),(IF({3 would like to do}3,0),(IF({4 maybe if in the area}2,0)) This isn’t being accepted. Any help appreciated.

I’m new to this but I am trying to check if a text field includes a set of key phrases. I have a Customer Table with a text field called “Notes” where someone could type a note in a cell. There is a Phrase Table with a text field “Phrases” that holds a set of predefined phrases. I would like to check if any of the phrases are found in the note. This is what I got, the field is located on the Customer Table. It returns False in all cases. IF(FIND(Phrases ,Notes)>=1,“True”,“False”)

Hello- I have a formula field that multiples values from two other rows. It functions properly when multiplying values without decimal points, e.g., 1, 2, 3, 4, etc. But fails to account for values with decimal points, e.g., 1.5, 2.5, 3.5. The odd thing is that for those values (the ones with decimal points), it actually accounts for the numeric portion of the values without the decimal value. Specifically, for 1.5 or 2.5, it will multiply based on 1 or 2, respectively. It ignores that there is a .5 tacked on as well… Here is the formula: IF({Mins}=15,".5",IF({Mins}=30,“1”,IF({Mins}=45,“1.5”,IF({Mins}=60,“2”,IF({Mins}=75,“2.5”,IF({Mins}=90,“3”,IF({Mins}=105,“3.5”,IF({Mins}=120,“4”," ")))))))) Not sure if this is helpful, but when I click on the “formatting” tab within the field, here is the response: “Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date.” Thanks in adv

Hi! I’m working on a database that tracks kittens placed in foster for a shelter. I know how to use DATETIME_DIFF to get weeks, but am hoping to get weeks and days. Ideally, I would like to have it read XwYd. Can anybody help?

I am trying to calculate the age of a member by counting the number of days between two date: Birthdate and the current date (auto entered) and divide by 365

Hello, I asked for some help with a formula to convert a single-select field to a date field, and was sent a link - but unfortunately I cannot access it. Can someone please provide a way to access the support article I was directed to? The topic is how to use the DATETIME_PARSE formula to convert that to MM/YYYY . Here’s the support article link I was sent: support.airtable.com

Hi everyone, What is the simplest way to convert a single-select field, which is the full word month (i.e., “January”), to a usable date field that provides the current MM/YYYY (i.e., “01/2020”)? I’m integrating to Airtable from JotForm, and the field in Airtable has to match the format of the JotForm field. So my JotForm field is formatted as Dropdown, and my Airtable field (Field 16) is formatted as Single select. My Airtable integration works for the Field 16, but I need a formula for my Activity Month field to convert that to MM/YYYY. Thanks so much for your help! V

I have records that are automatically created in my base. Some of them end in the phrase “(X of Y)” to indicate they are one of many. Others do not have this tag at all. I need help creating a formula that removes all instances of this parenthetical count. This would give me ability to group all records with identical names: Kelly’s Record (1 of 2) Kelly’s Recors (2 of 2) ----> all turn in to “Kelly’s Record” However, I need the formula to leave unique records unaffected: Kelly’s New Record —> Kelly’s New Record

I’m currently building two different pipelines, one for sales and one for recruiting. Both require a way to measure the pass-through rates from one status to the next status. Ideally, this formula would reflect the % of the pipeline that changes from one status to the next status. Any help or ideas on how to show this % change?

Hey guys, I’m struggling to get my if condition to return a value which is formatted as a currency. Formula as below IF(Client=‘Ebay’,{Qty/Hr}*{Qty/Hr Price}*0.029+0.30,’’) This is returning the value as a number with decimals, but refusing to allow me to format as currency Formatting error: Is anyone able to assist with this, thanks in advance.

Guys you are always so amazing, I have tried everything I can think of I have a table with rows that represent different branches and then there’s 15 columns representing a variety of different areas all with options red, amber, green - i would really like to have a colum that counts how many “red” responses there are, how many amber etc but I cannot work out how to do that - any ideas Thanks in advance

Hi everybody. My question is simple… (hopefully the solution also) I need a formula who automaticly tells me what date it is next Tuesday. On Wednesday it needs to update itself to next Tuesday. Thanks in advance!

Hi everyone, Im trying to put together a payroll base for my small start-up but Im finding it quite challenging dealing with the income tax calculation bit which requires the use of a progressive tax bracket system. The income tax bracket system has the following rules - Chargeable Income Rate (%) First 319.00 0.0% Next 100 5.0% Next 120 10.0% Next 3,000 17.5% Next 16,461 25% Exceeding 20,000 30% Since there isnt any vlookup in Airtable like in Excel making an if statement is impossible. I am pretty sure there is a simpler way to go about it but I just dont have the insight yet. Any help is totally appreciated.

Hello, I’ve created a table in my base called “Email Templates”. It’s a simple 2 column table. First column: Template Name, 2nd column: URL Formula. In the email template column, I’ve selected a long text field. And for each row, I’m creating test URL email formulas. Here’s an example of one of the formulas: "mailto: [lindsey@realtimesavers.com](mailto:lindsey@realtimesavers.com)"* & "?subject=" & ({Property Address}&" | Test 1")* & "&body=" & ("Good day Selling Team!* %21%0D%0A%0D%0ACongratulations on satisfying the home inspection contingency. We’re now one step closer to helping both of our clients meet their goals. Thank you for all that you’ve done to get us to this point!* %21%0D%0A%0D%0AQuestion for the lender: I understand many lenders wait to order the appraisal until after the home inspection has been satisfied. Now that we’ve checked that off, can you please reply-all with a timeframe for the order?* %21%0D%0A%0D%0AIf there