Formulas

Hello, I am a pro writer for companies and I am looking to generate quotes automatically.Depending on type of report (4 types) selected by the customer AND the time of writing (full day or half day) the price will vary.I want to convert this example to formulas :If half day and very synthetic = price 1If day and very synthetic = price 2If half day and abbreviated summary = price 3If day and abbreviated summary = price 4If half day and standard synthesis = price 5If day and standard synthesis = price 6If half day and exhaustive = price 7If day and exhaustive = price 8I have already created

Hello- Does anyone know how to remove the : in front of asset type when the Item Descr and the Multi game is blank? I keep getting this : EMAIL - ANNOUNCEMENT: COMICS PRO - FEB: 2023 Email is the Asset Type IF( {ASSET TYPE}, CONCATENATE({ITEM DESCRIPTION LOOK UP}, IF( {MULTI-GAME TASK TYPE}, “” & {MULTI-GAME TASK TYPE}), IF( {ASSET TYPE}, ": " & {ASSET TYPE}), IF( {ASSET TASK}, " - " & {ASSET TASK}), IF({ADDITIONAL ASSET DESCRIPTION}, ": " & {ADDITIONAL ASSET DESCRIPTION}) ))

Hi AllI'm currently scraping data from a few event listing websites into Airtable to create a database of events for the LGBTQ community.On a few of the websites, I can't extract the full event date from the listings, this only appears in the URL.An example of the URL is:https://www.admiral-duncan.co.uk/soho/02-01-2023/karaoke-showdown-with-candy-healsIs there any easy way to do this?The other issue is that each site link has a different URL length, but the way they show the date is the same each time:https://www.the2brewers.com/london/08-12-2022/pantoAny suggestions?Thanks

Dear All,I have come across a dilemma and see if anyone of you could give me a hand. Is it possible to transform a lookup value, which is dependent, to an independent value in the same table?Like in the above diagram, Main (from Set) is a lookup value, which it changes everyday. Since I am using this table to record the transaction, I would like to see if there is any way that I don't need to cut those records and paste it to Main Dish column manually.Or is there any script that can help making this happen? For example, on a daily basis, it would carry out a schedule job by copying one column to another one?Appreciate your kind advice and comment.🙏

Hello, there is a way to link a field to another table,other than the, master key field?See attached fileThanksSylvain

Hello,I'm totally new in the formula game, I created mine by putting pieces of tutorials together and using answers obtained here (by the way, thanks to the community!)That's the deal :When my cell x show 1h, I need to show 0When my cell x show 2h, I need to show 0When my cell x show 3h, I need to show 0When my cell x show 4h, I need to show 1When my cell x show 5h, I need to show 2When my cell x show 6h, I need to show 0I wrote :IF( OR( {Durée estimée} = "1h", {Durée estimée} = "2h", {Durée estimée} = "3h" {Durée estimée} = "6h" ), "0" ) IF( OR( {Durée estimée} = "4h", ), "1" ) IF( OR( {Durée estimée} = "5h", ), "2"I do not yet master the closing of the comman

Hey everyone, I’ve been doing a couple of automation with Airtable and I use a formula to pull in data, this is the formula I use for it. "input.email"={Email} I use that to pull in any record on Airtable that has the email I am inputting, what I realized is, it doesn’t work when the casing is different i.e. I noticed john@gmail.com is not equal to John@gmail.com, so the formula will say nothing found although the same email exists with just an upper case. So I have 2 solutions in mind, lowercase all the emails in the Airtable email field cause the input data is always lowercase, or tell the formula to take in upper cased similar emails as well. Could anyone here help me with it?

Hello community!I'm trying to extract some words of a column in 2 new columns. The number of words is always the same before the parentheses, example :2 big cars (With little windows)3 big cars (With black roof)4 big cars (With a lot of gas)I'm trying to get on column 1 :2 big cars3 big cars4 big carsAnd on column 2, only the information in parentheses :With little windowsWith black roofWith a lot of gasCan you please help me ? 🙂Cheers

Hello,I have a following situation:Table buyers has 8 rating columns (AAA,AA,A,NR,B,C,No Rating) which are determining different interest rates for each rating value. Each buyer has different interest rates in these rating columns.Table invoices has lookup field which looks up from a supplier table the rating of the supplier and adds that to the supplier_rating field.Now I want to get the correct interest rate from the buyer table based on the rating value of the supplier into invoices table.How should I do this?

Hi!I have this small test function to reproduce my issue:```IF(AND(5=6,LOWER(50)), 'ok', 'not ok')```Normally I would expect this to output "not ok", but it gives an error. The AND operation does not stop after the first mismatch. Usualy in programming languages you would stop then and no further arguments will be evaluated.This looks like a bug, right?Does anyone know how to work around this?

Hi! Im trying to assign a currency value from a single select field text and am having trouble. I've tried using the IF function and I can get it to look how I want, but the field is not a number field and so will not give me a sum. For example my single select has 2 options "Regular" or "Reserved" . If I select "Regular" I want my formula field to automatically assign a monetary value of $100. And then I want to see the sum of all of those. How can I do this?Thank you!

Hi Airtable Community!In essence, I want to be able to divide multiple numbers from lookup field (Quantity / Count). The formula that I have returns the value of 1.000 if there is more than one number in the lookup field (Quantity).I have attached two screenshots below 👇Thanks! 👌

I've done a few things in Airtable, but have lots to learn still. I'm creating a database with the contacts across all my organization. We would like to keep track of individuals who work in several organizations, so we have one field for ORG 1 and another for ORG 2. We would like to see all the ORGs a person is involved in at the field ALL ORGS. (See image)How can I create a formula to include ORG 1 and ORG 2 values in ALL ORGs field?Thank you very much!

Hi everyone. I’m looking to create a IF statement where if date B exists, then it will calculate the working days between from date A to date B. However if date B does not exists then it will calculate how many days it’s been from date a based on the real time current date. The if statements that I have been trying to create does not work with multiple formulas embedded.

Hi thereIs it possible to make a linked field case insensitive?If in a source table I have "Blue", and in another table a record is created with "BLUE" in a linked field (response from a user form entry, which I have no control over... this is a simple example, I can't do a select field question in the form, it must be user text), I would like the "BLUE" entry turn into the "Blue" that already exists in the source table, rather than creating another "BLUE" record in the source table. How to best go about it?Many thanks!

Is it possible to total a full table and calculate the % complete?Example:InfoClientsInvite AcceptedTotal CountPercent AcceptedInfoClient AClient BClient CClient DIf I have invited all 4 clients to an event but only 2 have confirmed, I have 50% done. Can Airtable calculate this?I'm looking for it to trigger a completed task in another tab once it hits 100% - is that possible?

Hello guys, is there a way to archive this scenario with Airtable. Let’s say I have a field with multiple ids/skus (kind of an array) and a table with ids/sku and name column. I need to somehow lookup the name of multiple ids in a field and display them like the picture above.

Hi, good people of the Airtable community! I am a therapist who sees clients. Each client will be charged a fee in Great British Pounds (£). If attended, a client will be charged £50. If a client does not attend or provides a late cancellation, their fee will be £35. I have a Google Calendar synced table. I have added one tick box column titled ‘Did Not Attend?’. I want a formula that records £50 if attended (default state) but changes the fee to £35 if I tick the box that denotes a did not attend/late cancellation status. A little problem to be solved that I hope someone might enjoy.

I’m trying to use function IF , but it seems not to work with entire columns, only with specific values or texts. I need to compare like I do in sheets, e.i : IF(A2 = D2, “Valid”, “Not Valid”). I don’t know how to use formulas with cells or if it’s even possible. I have another question regardings lookup, is there some way to use like a vlookup with fields that arent the key ones?

Hi all, New to formulas in Airtable and need a bit of help. My Formula is designed to complete an equation from two different columns, and if the result returns as an error in a cell, then to replace it with a message. The formula can be seen here. IF( ISERROR({TSINGLES} / ({LM}-{TSINGLES})),“No Sales”,{TSINGLES} / ({LM}-{TSINGLES})) Ultimately, as the column now contains numbers and also text, I can’t implement formatting in the dropdown at the top of the column. Could I add something to my formula to ensure that the result from the calculation are returned without any decimals? Here is a screenshot of what we’re working with - not brilliant.

The status bar at the bottom of each table shows the total of each field. So we have X records and X sum. What I need is to use those values in formulas. How can I call the total records of the table 1? How can I call the sum of a field in the table 2? Etc. Could you help me with that?

Hello to the AT community, I need to list some related records with arrayjoin(linked field,"\n") in a formula field. Unfortunately, this is not working on linked records as it is on lookup records. (See picture below). I would d like to avoid creating 28+ additional lookup fields in the table (this is a person table linked with 28 project tasks table) to get the proper list with carriage return. I will use this in automatic SendGrid mail blocks. Does anyone knows how to arrajoin linked records instead of lookup records. Thanks a lot. Thierry

I tried the already existing topic about duplicates but was unable to find what I am looking for. So basically, I have a list of applicants listed chronologically according to the day they applied, and each of the applicants has their own unique ID number. What I need is to be able to see automatically if someone with the same ID applies…I don’t need to remove duplicates from the list, nor to regroup them or anything. I just need them to be marked somehow in case the same ID occurs, so that I can now immediately if someone is applying again or for the first time. I google sheets I use the =countif(A:A,A1)>1 …is there an equivalent in airtable? Thanks and sorry if this was already asked.

Hi! I had the following situation when using the following formula to compare dates and determine the current row as the current date. the first part state if the count I less or equal to 1, that’s the current row, then if the count is above 1 and now is greater than the start date and now is previous to next date or next date is empty, that’s the current row IF({Count}<=1, “current”, IF(AND({Count}>1, Now() > {Start date}, OR(Now() < {Next date}, {Next date}=“”)),“current”)) This would give the correct output. But when I tried using instead of NOW() > TODAY() IF({Count}<=1, “current”, IF(AND({Count}>1, {TODAY()} > {Start date}, OR(TODAY() < {Next date}, {Next date}=“”)),“current”)) It would throw a completely different result, completely shift on dates. WHY?

Hi, I’m trying to figure out why I’m experiencing issues with my nested IF(AND()) function on Airtable. When I limit the fields in AND() to just two conditions, it works, but anything else and Airtable won’t let me use the formula at all. Please advise! Thank you. What works IF(AND({Person}= “1”, {A}= “Yes”), “Approved”, IF(AND({Person}= “2”, {B}= “Yes”), “Approved”, IF(AND({Person}= “3”, {C}= “Yes”), “Approved”, IF(AND({Person}= “4”, {D}= “Yes”), “Approved”, IF({Quote} = “0.00” , “Temporary approval”, “Unapproved”))))) What doesn’t IF(AND({Person}= “1”, {A}= “Yes”), “Approved”, IF(AND({Person}= “2”, {B}= “Yes”), “Approved”, IF(AND({Person}= “3”, {C}= “Yes”), “Approved”, IF(AND({Person}= “4”, {D}= “Yes”), “Approved”, IF(AND({Person}= “5”, {E}= “Yes”, {F}= “Yes”), “Approved”, IF(AND({Person}= “6”, {E}= “Yes”, {F}= “Yes”, {G}= “Yes”), “Approved”,