Formulas

I’m importing a google spreadsheet of workers and their trades. The sheet has over 11,000 rows (each worker = 1 row). There are 40 trades. Each trade has its own column, and there is an “X” if the worker is skilled in that trade. I converted each “X” into the name of the trade that it represents. I now want to combine all of the columns for each worker into 1 multiple select field so that each worker has one field where it lists all of his/her trades. Any ideas?

Looking for a formula where if a field is left blank it will automatically be filled in with the same info from the previous field. For example: I have a field for dates. Fill in date on line #1. Move to next line (line #2) and leave blank. Move to next line (line #3) and line #2 automatically gets filled in with the date from line #1. Any suggestions?

I swear this must be really easy, in fact in excel it’s really easy what am I doing wrong :frowning: I have one sheet on there I have a variety of columns I want to create a column at the end that says how many out of columns xyz (which are all single line text columns) contain text - please can anyone help as 4 hours later a rabbit hole of videos and posts on here I still cannot get it to do anything - thank you in advance

I have a column for “Completed?” with a checkmark option. When this is checked, I’d like for that column (“When complete?”) to populate the time it was checked. I think I need to combine something like this: IF({Completed?} = 1, LAST_MODIFIED_TIME({Completed?})) with DATETIME_FORMAT(SET_TIMEZONE({Completed?}, ‘America/Chicago’)‘M/DD/YYYY h:mm’) but I’m not getting it to work the way I was hoping. Thanks in advance! Rachael

I have 2 fields that both sum up strings of currency. One is the sum of services and the other s a sum of the money paid in. If they total to the same, then my drawer should be balanced. The sums are the same in both fields. Originally, I had an if formula that contained the same sum action that is in {Paid In} because I would rather use an IF formula to tell me if they are the same, rather than comparing the two myself. I thought they must not be the same, so I created the {Paid In} field to check. They are indeed balanced, but the formula does not recognize this as so. My formula: IF({Paid In}={Gross Income},“√”,“CHECK BALANCE”)

HI! I’m concatenating a few name fields and have been running into what seems like a bug. An errant space shows up before the first field insert in some, but not all instances. Code: CONCATENATE("Set (",{Score Name}," + ",{Part Set Name},")") Output: Thoughts? Thanks –

I’m trying to list all records using the Airtable API that have been updated in the last 24 hours. This job will run each day and check for the last modified column and if the date `IS_AFTER(TODAY()-1 DAY, TODAY()). I’m struggling with the syntax. Does anyone have any guidance on this?

I need to round off a list of values ​​to 0.5 With the formula “Ceiling” they all go with the highest value, instead I need that the values ​​under 0.25 or upper 0.75 etc must go to 0. With the “Round” formula I can’t understand where I’m wrong. I’m using Round ({column of values}, 0.5) Tnx in advance

Hello, I have a column that is called Contacts that lives in table Publications. In this column, each cell has one or multiple linked records that can be found in another table called Press & Media Contacts. A cell inside Contacts looks like this What I would like to do is to filter and select the rows that have a certain contact in, using the record id. The only way I could do this was to use filterByFormula and Name, not record id: "filterByFormula" => "FIND('Keith Shearin',Contacts)" What I would like to do is something like this: "filterByFormula" => "FIND('reclhWRUlh9q47Zfd',Contacts)" Where reclhWRUlh9q47Zfd is Keith Shearin record id. FIND is obviously not

Can someone help me combine multiple roll-up fields into one? These fields are notes from another table. Instead of having multiple roll-up fields spreading across the projects table I’d like to combine them into 1 field. I’d like to add a “heading” of text in between each rollup to differentiate each note field. My current formula gives me an error. CONCATENATE("Incoming Request: " & {Incoming Request}& "\n" & "Contractor Notes: "{Contractor Notes}& "\n" &"Client Notes: " & {Client Notes}& "\n" &"Project Notes: " & {Project Notes}&"\n" &)

Hi I am a complete Novice with Airtable. I was once OK with Microsoft access but a long time time ago. I have a website and I sell subscriptions which go up in the following increments 48hrs 1 month 3 month 6 month 12 months In my orders table I have the date ordered field and other field called Item’s Name. This contains the following text 12 months Subscription, UK TV, Box Sets, This has been imported via a CSV and whilst it is showing as a single line text field the contacts are part of a url. I am looking for a formula to create a renew date 1 month, 3 month hence etc please. I hope all this makes sense. Any help appreciated please. Andy

The funny part is that when I change the data type in field in question from a formula to a plain decimal number - it all works! Does Airtable not support this kind of calculation when the primary field is a formula deriving data from another formula, or I am doing something wrong?

Hi, I am trying to divide two fields using the following formula: {Variable1}/{Variable2} However I am returned a #ERROR!. I have checked and both fields are coded as Integer types and no value in “Variable2” is a zero. Can you help me find out why I’m being returned this error?

Hi squad, First of all I swear I’ve googled this, and I’ve seen some answers that indicate the thing I’m trying to do is possible but I haven’t actually been able to make those solutions make sense for my purposes. Basically, I have two tables. I’m planning a wedding. So one table has our guest list broadly, with columns for “table” and “household” and “category” and “plus one?” and such. The primary field is “Name” However, we’re using airtable to collect addresses for save-the-dates/invitations/etc. So there’s another table called “Addresses,” which receives form submissions (it’s actually a whole zapier/netlify situation because I wanted the form to be prettier, but basically, it’s a form). The addresses table also has “Name” as the primary field. All I want to do is automatically link one table to the other. Theoretically the names are the same, and if they aren’t, it usually means I need to update the “guests” formula with the perso

I have a formula which looks for the string “geo” in my URL column {Cloaked Link} then display all text it finds after it. But sometimes I will have the text “visit” in the {Cloaked Link} URL column instead of “geo”, so if that’s the case I want to pull out all the text to the right of that string. How can I do that? Here’s what I have so far: RIGHT( {Cloaked Link}, LEN( {Cloaked Link} )-FIND( 'geo', {Cloaked Link} )-3 ) Basically I want to combine that with this: RIGHT( {Cloaked Link}, LEN( {Cloaked Link} )-FIND( 'visit', {Cloaked Link} )-3 )

I have two currency fields: Current Balance and Previous Balance. When Current Balance is updated, Previous Balance changes to reflect what Current Balance displayed previously. Is there a formula that can address this? (Have done this many times in SalesForce but that has engendered a workflow rule which I’m not sure is available in Airtable.) Thank you!

Hi all, I’ve been searching on the ressource center but I didn’t see anything. Does somebody have a template or formulas to calculate MRR ? best, Ben

I want to build a pdf catalog of my products grouped by product type. Not seeing an easy solution to this and I missing something? Terri

I have found that formulas entered on iPad don’t work correctly; especially if there’s a literal in them. I can go to my Mac and enter exactly the same thing and it works. Any solutions?

I am trying to write a simple formula: If field X contains ‘Apples’ or ‘Cats’, or ‘Chocolate’, or ‘Dogs’, then ‘Enter in the database’. I am not well-versed in formulas, as you will see, and am probably using a convoluted way, which is the following: IF( OR( FIND(‘Apples’, {Field X}), FIND('Cats, {Field X}), FIND(‘Chocolate’, {Field X}), FIND(‘Dogs’, {Field X})), ‘Actionable’). The formula works for the first two values, but breaks on the last two. (Airtable also inserts backslashes there.) Can someone kindly help me figure this out? Thanks.

Hello all, This is my first post to the community. I’ve seen other posts similar to this topic, but they don’t quite address what I’m trying to achieve. I’m having an issue with a nested IF statement and not sure whether a combination SWITCH/IF would be best for this formula. I have two columns - column 1 (Date) and column 2 (Location) that is single select. I want a third column (Status) that returns a value based on what is populated in the first two. Logical Argument 1: If column 1 (Date) is not blank OR column 2 (Location) is ‘Outside Area’, the Status column should return “Yes”. Logical Argument 2: If column 1 (Date) is blank the Status column should return “No”. Any help would be greatly appreciated. @Jeremy_Oglesby

Hello, I have a database that is updated live (through an integration), but some records can go directly to archive (via a filter). I am trying to build a formula that will identify as many archivable records as possible and mark them with :white_check_mark: . Such records would march either of the following criteria: marked (manually) as non-actionable in a multiple-select field type OR contain a certain word in a single line field (e.g., if a single-line cell contains ‘no-reply’ => archive) I already have a formula for the former, but I wonder if a formula that would combine both is possible to build.

Hi All, We are using airtable to create a delivery schedule for our team every week. We have many columns to keep track of each product. I would like to create a summary column which lists each product that was ordered. We then export this file to import into a route planner. We want the final output to follow this format: Name: 123 Address, City (Prod1qty, ProdNqty) $owing {comments} Our Columns: Name Address (with city) Products Ordered Balance Comments Product1 Product2 … Product50 The trouble I’m having is with the product list. We need it to show only “Product1” if there’s just 1 and “Product1*#” if there are multiple. And I need each product to be separated with a ", " without having a coma at the end of the list. I’m pretty sure I can use an extensive IF formula to create the list of products based on how many are ordered. I have no idea how to remove the coma at the end of the list tho. I

I have a unique situation that I couldn’t find an answer to, possibly to my lack of patience. But I am trying to create a pricing sheet of products. I have two manufacturers. I have installer and wholesale accounts that only get a discount on one of the manufacturers’ products. I was trying to come up with a formula that calculated the accounts discount automatically since I change prices every so often, but want it conditional to the one manufacturer it applies to. I need it to be that if the manufacturer cell says SCF, the installer sell is retail * .9, and wholesale is retail*.75 and if the manufacturer cell says Maven, installer and wholesale are both same as retail. Is this possible??? (I tried attaching a screenshot of my table, and it’s not letting me so I’m explaining it as best as I can)