Airtable stands out as a powerful tool for data organization and project management, thanks in part to its advanced formula capabilities. Use the Replace formula: REPLACE (“Project to Archive,”, 1, 19, “”) Use the Substitute formula: SUBSTITUTE (“Project to Archive,”, “Project to Archive May 13, 2024 · Using the \n formula in Airtable. Mar 5, 2024 · Formatting number-based fields. You can add in-line breaks as needed by using "\n" in a formula. Daniel_R. If can go from 1 minute, to 5 and then to 8 or 9. The essentials of Airtable formulas actualizar ; Formula writing tips for beginners ; Resolución de problemas con fórmulas. Jan 20, 2023 01:46 PM. So Jan 10, 2024 · It offers multi-page forms, conditional paths for pages, accepting payments on forms, updating Airtable records from a form, creating linked records on a form, specifying the maximum number of linked records, displaying lookup fields & formulas & rollup fields on forms, and dozens of advanced Airtable-specific features that are not available in Apr 17, 2024 · The primary field is always the first column, or field, in any table. Counting records in Airtable linked record fields ; Word and character count in Airtable ; Finding the sum of fields in Airtable ; Common Solutions: Advanced Jan 11, 2024 · Converting numbers and text in Airtable formula fields ; Converting unix and epoch time in Airtable ; Using formulas in Airtable's primary field ; Common Solutions: Intermediate. On the left side of the screen, click the Add a form option or the + icon next to the “Forms” section. apples apples, pears pears, bananas, strawberries I've been using the formula IF(FIND("apples", {fruitName}), "yes", "no") In this case, I woul Mar 5, 2024 · This article covers how to calculate the difference between two dates in Airtable. Counting records in Airtable linked record fields ; Word and character count in Airtable ; Finding the sum of fields in Airtable ; Common Solutions: Advanced May 21, 2024 · Power Formulas provides a series of advanced Google Sheets™ formulas that boost your spreadsheet productivity. I’m trying to get the formula to say . 1) Any other combos I try using AND statements where I have followed other similar examples Mar 28, 2024 · Converting numbers and text in Airtable formula fields ; Converting unix and epoch time in Airtable ; Using formulas in Airtable's primary field ; Common Solutions: Intermediate. Dec 14, 2023 · The essentials of Airtable formulas actualizar ; Formula writing tips for beginners ; Resolución de problemas con fórmulas. IF({production Pipeline} CONTAINS "Transcripts", Assignee) Dec 7, 2023 · Advanced work with percentages in Airtable While considering a storewide sale of 25% off, the purchasing manager needs to ensure that each item will remain profitable when discounted by the sale. Out of curiosity, I’m curious as to why you’d like to automate moving the value from the formula into the new date/time field. This will produce a date/time value in the format of 6/20/2022. You can do so by scrolling to the right of your base in any grid view and clicking the "+" icon. Apr 22, 2024 · Hello there, I am trying to create a formula that calculates the total cost of items based on their quantity and unit price; while also factoring in a discount percentage if applicable. Plain text. NOTE. The functions below format datetimes into specific strings - either as a time, or as a date. Pruébalo en Airtable. Post Options. While basic types include text, number, and date fields, Airtable’s advanced field types offer much more functionality, turning your base into a fully customizable data management tool. {Expert Threshold} = 100. Counting records in Airtable linked record fields ; Word and character count in Airtable ; Finding the sum of fields in Airtable ; Common Solutions: Advanced Jun 6, 2024 · The essentials of Airtable formulas. Zapier is a third-party service that connects Airtable to many other apps and services. Power Formulas is designed to help you work smarter, not harder. If you want the field to be in the past, you would just put a minus sign before the number in the formula. This calls up a box where you can write your formula. Browse product documentation to find answers and support for Airtable. Share. 1 Kudo. To access formatting options in number-based fields: Click the ⌄ icon next to the name of the number-based field you want to format. You can use formulas to create advanced calculations, manage budgets, set recurring events for project management, and much more. Adds decimal and trailing zeroes if needed to ensure price portion of string is 7 characters long. Counting records in Airtable linked record fields ; Word and character count in Airtable ; Finding the sum of fields in Airtable ; Common Solutions: Advanced Mar 5, 2024 · The SUM () function allows you to find the sum, or total, of any amount of numeric values. May 31, 2024 · Hi Community, this is a little brainteaser for advanced formula wizards. I have 2 columns: Show Name and Episode Number. Jan 11, 2024 · Converting numbers and text in Airtable formula fields ; Converting unix and epoch time in Airtable ; Using formulas in Airtable's primary field ; Common Solutions: Intermediate. Dec 12, 2023 · Converting numbers and text in Airtable formula fields ; Converting unix and epoch time in Airtable ; Using formulas in Airtable's primary field ; Common Solutions: Intermediate. Image 1 Description: An illustrative chart showcasing Mar 13, 2024 · This article covers the DATETIME_PARSE () function—taking date & time information and interpreting it as structured values that Airtable can use to streamline your team's and organization's work. May 6, 2023 · For example, a 1# pkg costs $12. and then filter it if the project status matches certain conditions. Jun 6, 2024 · The essentials of Airtable formulas. Here are seven time-saving substitution formulas that demonstrate simple and creative ways to solve many common problems. g. 5 - Automation Enthusiast. Jan 31, 2024 · Date and time field. Counting records in Airtable linked record fields ; Word and character count in Airtable ; Finding the sum of fields in Airtable ; Common Solutions: Advanced Mar 29, 2024 · Converting numbers and text in Airtable formula fields ; Converting unix and epoch time in Airtable ; Using formulas in Airtable's primary field ; Common Solutions: Intermediate. First to extract the beginning of the {Part} field. Dark. Getting the length of a string is useful in many use cases, such as: Ensuring text doesn’t exceed a certain character limit. Fields come in a variety of types, storing data in the form of text, single- or multi-selects, images, checkboxes, numbers, user tags, and more. She can use this formula in order to determine which items would be priced too low given the sale. Form 2 gets a few checkboxes and IP address → Search for records that matches the IP address and update the record with the checkboxes. Note. This article covers how to use the formula field to streamline your team's and organization's work. Feb 7, 2024 · February 7, 2024. (period key). En una fórmula, puede hacer referencia a campos (columnas) por su nombre. In general, Airtable’s functions are relatively basic with a very limited amount of power. Using logical operators to compare field values in Airtable Jun 10, 2021 · I want to do a DATEDIFF formula really basic). Counting records in Airtable linked record fields ; Word and character count in Airtable ; Finding the sum of fields in Airtable ; Common Solutions: Advanced This exam is 65 questions and requires a passing score of 75%. Maybe someone else will be able to figure this out for you using a series of multiple different formula fields, but my guess is that you would probably need to turn to JavaScript to do this. Adding formula fields in Airtable Adding formula fields NOTE Formulas allow you to output numbers, dates, strings, and more in each rec Updated on : 27 Mar 2024. IF (OR ( {Sub-Category}=“Coffee Retail Beans”, “Coffee Retail Ground”), {Calc Price}+0. That said, if you aren’t able to do that, you could use a few different formulas to accomplish this. Apr 27, 2020 · Sadly, unlike more advanced database systems, there is no automated linking in Airtable… all links must be explicitly & manually chosen by the user every time. You can use this function to individually reference numbers or to reference a field name that contains numeric values. Next, click on the Formatting tab. Let’s say you want to check on the status of Dec 1, 2023 · How To Use Formulas In Airtable. Jan 28, 2020 · On a side note, your use of CONCATENATE() wrapped around that other formula is a little redundant. May 07, 2021 07:31 AM. This article will cover how to write and format the formula field type. Here’s a sample of my zapier advanced search formula that’s not working: (FIND (" { {43369726__from}}<TriggerValue", {Phone Number}))>0. ARRAYUNIQUE(values) => " [1, 2, 3]" when values are [1, 2, 3, 3, 2, 1] ARRAYSLICE(values, start,[end]) Returns a subset of the array from the first index number—starting from 1. To see multiple lines show up in Airtable make Apr 9, 2024 · Airtable formula field overview ; Using array functions in Airtable ; Fundamentos de fórmulas. 00 to ship, and on the next row, a 2# pkg costs $12. However, I have no idea if the software is advanced enough to handle what I use Google Sheets for. Counting records in Airtable linked record fields ; Word and character count in Airtable ; Finding the sum of fields in Airtable ; Common Solutions: Advanced Dec 7, 2023 · Converting numbers and text in Airtable formula fields ; Converting unix and epoch time in Airtable ; Using formulas in Airtable's primary field ; Common Solutions: Intermediate. Pull each of those values into Table A with lookups – presumably you will have 3 fields each containing an integer value… for example: {Intermediate Threshold} = 70. From automating data collection to creating powerful reports, our formulas will The Airtable formula LEN () will return the length of a string. Jan 31, 2023 · 1. Mastering Airtable formulas can elevate your bases from simple data repositories to dynamic, automated systems that can significantly boost your productivity and efficiency. Oct 25, 2021 · Hear an Airtable expert answer the top questions on formulas from last week's episode of Table Talk. Troubleshooting common Airtable formula errors ; Cálculos básicos. Feb 5, 2024 · Although formulas are often associated with math and numbers, Airtable formulas can be used for other purposes as well. In my base I have 2 tables: a recipe table with each ingredient in its own field, linked to my ingredient table. Last modified time field. I’ll use FIND() in this example. Create a "Date" field called "Date changed" or anything you want. The Airtable formula editor tends to show wavy red underlines even when the formula is correct, especially with multi-line formulas. Optionally specify an end index to stop. Using logical operators to compare field values in Airtable ; Formula field calculations in Airtable ; Enunciados condicionales Jun 1, 2020 · Hello AT community! I have a question regarding creating formulas. It represents a description of each record in the table and cannot be deleted, moved, or hidden. Solved See Solution in Thread. Status = “In Progress”, Status = “With Client”, Apr 23, 2022 · For that, you can use the DATETIME_FORMAT function like so: DATEADD(. I am attempting to search the {Phone Number} field to see if it CONTAINS my trigger value “from”. Light. Reply. The time displayed in minutes on the field does not update every minute. Hopefully someone here that’s more familiar with the functions of Airtable can let me know! Right now, I use Sheets to dump data I scraped from Indeed. In the ingredients table I have several single select fields for each allergen that a particular ingredient contains. I’m trying to set a column to display “on track” or “overdue” depending on what the due date and status of the item is. If the formula saves and gives the correct result, you can ignore the wavy red underlines. You can add in-line breaks as needed by using "\n" Updated on : 05 Mar 2024. If an interface or form has previously been configured in the base, then you’ll be brought to a new screen. To create a formula in Airtable, click on the " + " icon and choose the " formula " field type. DATEADD ( { {datetime field}},number, ‘unit specifier’) Although it has ‘add’ in its name, this formula can add or subtract time from a date field. Sep 30, 2020 · I have tried this which returns a result for all products and not just those where the Sub-Category is “Coffee Retail Beans” or “Coffee Retail Ground”. 2. Mar 5, 2024 · Using the \n formula in Airtable. Counting records in Airtable linked record fields ; Word and character count in Airtable ; Finding the sum of fields in Airtable ; Common Solutions: Advanced Apr 18, 2016 · To make that more clear, I would rename it to “Score Threshold”. Show is single select and Episode is multi. Jan 17, 2023 · I want to create a formula where if a person has completed Training A and Training B, then the result is 'completed'. From the formatting tab, you have a variety of options to choose from: Format, Presets, Decimal places, Thousands and Apr 1, 2023 · Hello , we've built an app that you may find helpful here. Create custom interfaces that give each and every teammate the relevant information they need, and a simple way to take action. Getting started with formulas. Using logical operators to compare field values in Airtable ; Formula field calculations in Airtable ; Enunciados condicionales Feb 7, 2024 · In Airtable, a field type determines the kind of data you can store in each column of your table. Converting numbers and text in Airtable formula fields ; Converting unix and epoch time in Airtable ; Using formulas in Airtable's primary field ; Common Solutions: Intermediate. Using the dates you listed in the previous Mar 25, 2024 · Converting numbers and text in Airtable formula fields ; Converting unix and epoch time in Airtable ; Using formulas in Airtable's primary field ; Common Solutions: Intermediate. Sep 17, 2019 · Hi, I have the following formula that works by displaying a ! when col1 is empty: IF({Col1} = BLANK(), “!”, “”) However I would like to add OR statement so that the ! is displayed if either Col1, Col2 or Col3 have no entries. Añadir un campo de fórmula. Counting records in Airtable linked record fields ; Word and character count in Airtable ; Finding the sum of fields in Airtable ; Common Solutions: Advanced Jun 6, 2024 · In Airtable there are many different fields that you can add to a table; one of them is the formula field type. Para devolver el valor de un campo existente, simplemente tienes que introducir el nombre de ese campo: Price. The syntax is quite straightforward: Syntax: LEN (string) Example: LEN (“Build internal tools with Softr”) will return 31. It’s best to use a plain text editor—or better yet, a dedicated Oct 20, 2021 · This can be done using either the FIND() or SEARCH() function (not field ). Airtable terminology. {Created}, NOW(), 'minutes') * -1. 173. On a second table, I want to have a formula that takes an item's weight x qty, and display the cost to ship . Suppose you wanted to have a Status field that would automatically mark overdue tasks in a way that makes them obvious. Apr 19, 2021 · Using Zapier's Multi-Step Zaps to find and update records. Duration time field. You have a Due Date column with dates, and a checkbox Jan 25, 2024 · 1 Solution. No links between the lines there are working with … The two fields use in the formula are two dates with european format. IF >=0, 3>= then True (Checkbox 1) IF >=4, 6>= then True (Checkbox 2) IF >=7, 9>= then True (Checkbox 3) IF >=10, 12>= then True (Checkbox 4) I have an automation that sends a specific email based on the selected boxes, but I do not have the time to manually check The formula will follow the recipe of: DATETIME_FORMAT ( [yourDateTimeField], ' [format specifier]') The format specifier will allow you to dictate the structure of how your date should be returned. The app will generate a script that you can add to your "Run a Script" automation action, and the script will split the long text from multiple cells in the first table and create records in the second table, as well as linking the records May 22, 2024 · Formatting strings in Airtable. Mar 27, 2024 · Converting numbers and text in Airtable formula fields ; Converting unix and epoch time in Airtable ; Using formulas in Airtable's primary field ; Common Solutions: Intermediate. Here's an example of how to set up a conditional emoji formula. Counting records in Airtable linked record fields ; Word and character count in Airtable ; Finding the sum of fields in Airtable ; Common Solutions: Advanced . I have suggested automatic linking as a feature request for Airtable — perhaps you can comment on this thread to add your voice into the mix, so Airtable employees can understand Jan 22, 2024 · I'm new to Airtable and I need a formula to check a box from a form submission. It sounds like you want to know the percent change, which is slightly different from what percent is x of y. The formula editor will appear below with suggestions. The format specifier can be something like 'DD-MM-YYYY,' 'YYYY/MM/DD,' 'MM. I did : DATETIME_DIFF({FIN PE},{DATE ENTREE},‘days’) But it’s really weird it work for some lines and don’t for the others. My current formula is written like so: IF (. OR (. I tried different formulas but the issue I am having is that when Form 2 is submitted all the records on my table are updated. This article cover leveraging formulas in the primary field. Each Initiative is linked to one or more Tasks and each Task Aug 2, 2022 · Form 1 gets email address and IP address → Create a new record. This article is specifically designed to teach you how to design Multi-Step Zaps for the purpose of creating Apr 20, 2021 06:35 AM. Counting records in Airtable linked record fields ; Word and character count in Airtable ; Finding the sum of fields in Airtable ; Common Solutions: Advanced Sep 2, 2021 · Sep 02, 2021 02:47 PM. The Airtable Builder Certification is designed for those who want to master the art of building and managing workflows in Airtable. I have tried using nested IF statements; but I am running into some challenges with getting the formula to calcula Jan 17, 2024 · Converting numbers and text in Airtable formula fields ; Converting unix and epoch time in Airtable ; Using formulas in Airtable's primary field ; Common Solutions: Intermediate. I am stuckHere is the situation:Up to 3 "quality checks" need to be done for some workflow. Feb 16, 2024 · Converting numbers and text in Airtable formula fields ; Converting unix and epoch time in Airtable ; Using formulas in Airtable's primary field ; Common Solutions: Intermediate. com , de-dupe it, and keep status records of what I’ve done with each record. Dec 17, 2020 · I’m using this formula in the column (the DATE and Project Start are the columns I’m having it pull data from): DATEADD (Date,- {Project Start (Months/Weeks/Days Out)},‘months’) Date is pulling from the Date column that i have the first day of the event in. [item wt] x [qty] = [total weight] and then display the cost to ship that TOTAL WEIGHT, and then lookup the cost to Apr 26, 2020 · Apr 26, 2020 08:11 AM. This is equivalent to manually adding each value using the + operator, like Number 1 + Number 2. Retyping the apostrophes in Airtable seemed to fix the issue. Print. Aug 30, 2018 · However, my problem is not with the Airtable formula, but with the Zapier advanced search. Formulas can be used with the CONCATENATE() function or the ampersand sign (&) to link data from other fields and text. ), 'l'. If you expand the cell by clicking on that little blue icon that appears (or by hitting SHIFT-SPACE on your keyboard), the cell will open up and you will see that your line breaks Mar 7, 2024 · Converting numbers and text in Airtable formula fields ; Converting unix and epoch time in Airtable ; Using formulas in Airtable's primary field ; Common Solutions: Intermediate. Scroll down to see the full list of trainings currently available. {Estimated Start Date}, {Calculation}, 'days'. So basically, out of the many options that present themselves in the multi-selection field, I need to select 2 specific pieces of training that indicate that a program has been completed. If your notes app defaults to styled text, that would explain the problem. My desired output is a string that loops the show name before the episode number; instead I only get Show Name Jun 22, 2020 · Airtable formulas also do not offer any recursion abilities. When working with formulas, especially when combining several fields of information, it is often helpful to program in line breaks and other formatting features to better display a formula's result. Jul 21, 2022 · Formatting a Formula. 🎓. Step 1: Dec 4, 2023 · Returns only unique items in the array. You can build a formula to output the correct quarter and fiscal year based on an existing date field. Counting records in Airtable linked record fields ; Word and character count in Airtable ; Finding the sum of fields in Airtable ; Common Solutions: Advanced Jun 8, 2023 · To use an IF function in Airtable, you’ll need to create a new field. {Payment Received}, {Invoice Billed}, 'days'. Give it a descriptive name, then choose the field type “Formula. Subtracting From a Date. Jul 21, 2022 09:01 AM. Mar 24, 2023 · Creating a New Date Based on an Existing Date. Jan 29, 2024 · Converting numbers and text in Airtable formula fields ; Converting unix and epoch time in Airtable ; Using formulas in Airtable's primary field ; Common Solutions: Intermediate. {Advanced Threshold} = 85. Jan 25, 2024 02:11 PM. Create a "Last Modified" field. Using the DATETIME_DIFF () function in the example below, we'll find the difference - in days - between two dates. I got the first part to work using: DATEADD({Project Date},7,"days") which worked perfectly, Nov 22, 2023 · Need: What I'd like to happen then is after the Opt-In option is discussed and if the volunteer decides to add 1 more year to their volunteer work, a formula runs that gives a new end date. I’ll start with an IF() function just to make sure that something is selected there, and then remove the characters on the left that fall before the colon: Dec 8, 2023 · To access the emoji keyboard on a Windows-based computer, press the Windows logo key + . 3. The formula inside that: First & " " & Last & " " & {With First} & " " & {With Last} …outputs exactly what you want, without using CONCATENATE(). Learn more about Interface Designer →. So the formula would be. ”. Jan 11, 2024 · Airtable formula field reference. With =API(), =SQL(), =AI(), you’ll be able to perform complex tasks in seconds. Jan 20, 2023 · 0 1408 4. These lookup fields might contain one or multiple values, e. In Airtable there are many different fields that you can add to a table; one of them is the formula field type. Plataformas. Counting records in Airtable linked record fields ; Word and character count in Airtable ; Finding the sum of fields in Airtable ; Common Solutions: Advanced Oct 23, 2023 · I'm trying to write a formula to check whether a lookup field contains a specific value. Let us know in the comments if you like these livestream Jan 15, 2019 · When you think of a substitution formula, the concept of "find and replace" likely comes to mind. Jun 28, 2023 · Now I’m writing a similar formula but the record has multiple selections and there are too many combinations to use the same formula, so rather than use “=” I would like to use “contain” but I can’t find a way to express contains. If this is the first interface/standalone form in the base, then click Start building, then select Build a form. In your grid view, it actually did work, but it’s truncating all of your data onto the same line for you so you can see more of your data. 18 - Pluto. Counting records in Airtable linked record fields ; Word and character count in Airtable ; Finding the sum of fields in Airtable ; Common Solutions: Advanced Jan 11, 2024 · Airtable formula field overview. I can't seem to figure out how to loop a concate formula. Field - A field contains details or metadata for each record in a table. Project Start (Months/Weeks/Days Out) is the column that has the # of Months May 13, 2024 · Displaying fiscal year quarters. Each training is facilitated by an Airtable expert who'll guide you through the session, step-by-step. Create an automation that triggers when the field has that value, and its action will be to update the record by pasting the value in "Last Modifed" from Step 1 into the "Date" field from Step 2. Related reading. This will give percent change: ({Current Value} - {Original Value}) / {Original Value} Be sure to adjust the format settings of the formula field to display as a percent. AND (IS_BEFORE (Due,TODAY (), IF (. 90 to ship. This article covers how to use formulas involving numeric, logical, and text operations to streamline your team's and organization's work. May 6, 2021 · The source of the problem is me writing out my formula in a separate notes app, and then copying and pasting it in. Web/navegador, app de Mac y app de Windows. PDF. Formulas let you reference other fields in a table and create different functions based on the content of those fields. Then, click Edit field. Jan 11, 2022 · You may be able to take care of it prior to it coming into this primary field. Counting records in Airtable linked record fields ; Word and character count in Airtable ; Finding the sum of fields in Airtable ; Common Solutions: Advanced Interface with work in a new way. 15 Minutes to read. Feb 2, 2023 · Want to have a form with logic, calculation, and payment in your Airtable base? Watch this video to learn how to create an advanced form in your Airtable bas Mar 29, 2023 · Watch a free, on-demand training webinar—covering topics from building your first base to streamlining your workflows with automations. Greetings Airtable Community, Several weeks ago I received great assistance with a formula quandary involving the combination of two multi-select fields: {College (s)} & IF ( {Department (s)}, " and " & {Department (s)}) This formula assumed that the {College (s)} field would always be populated. I have tried varying different ways with no luck, such as: IF({Col1} or {C Oct 7, 2021 · The board is a basic project overview. As an example, let's say your fiscal year runs from June through May; that means your first quarter (Q1) of the year would start on June 1. Another common use of DATETIME_DIFF() is to find the difference between a record's date and today's date. The function is written as: SUM(values). Counting records in Airtable linked record fields ; Word and character count in Airtable ; Finding the sum of fields in Airtable ; Common Solutions: Advanced Mar 28, 2023 · Solved: I have a column named MIN and need to add leading zeros when the value in column is less than 4 numbers: Before After Formula 22 0022 456 Sep 3, 2021 · According to the column description, the original formula (which I’ve modelled this off) “Concatenates 5-digit ‘days since epoch’ value of Date + “:” + Price to create day-specific persistent price record. Use negative numbers to begin to count from the end of the array. May 28, 2024 · The essentials of Airtable formulas. For a full list of supported format specifiers, please see Jul 17, 2023 · Hello guys, I have a field that use a simple formula to calculate the time passed (in minutes) between the created time of a record and Now that goes like this: DATETIME_DIFF(. DD,' etc. Updated on 11 Jan 2024. Based on: What that said, I'd want the formula to run only if YES is selected from a drop down. Give your field a name and start crafting your formula in the designated box. TIMESTR() DATESTR() For example, if you wanted to format the current date and time provided by NOW() only as the time, you would use this formula: TIMESTR(NOW ()) Plain text. Plan availability. In Airtable, however, you can use substitutions to perform powerful workflows. Counting records in Airtable linked record fields ; Word and character count in Airtable ; Finding the sum of fields in Airtable ; Common Solutions: Advanced The essentials of Airtable formulas actualizar ; Formula writing tips for beginners ; Resolución de problemas con fórmulas. Each "quality check" has a check box fieldQC1QC2QC3Each quality check also has a sing Jul 6, 2023 · So i was wondering if it was possible to create a formula (or combine formulas) in order to use the data from one date field and add 7 days to it in another. Counting records in Airtable linked record fields ; Word and character count in Airtable ; Finding the sum of fields in Airtable ; Common Solutions: Advanced Jul 25, 2019 · I’m hoping someone can help here… I have a base with two tables (Initiatives and Tasks). kuovonne. This certification goes beyond the basics, providing you with the knowledge and skills to create custom applications, design interfaces, automate Apr 8, 2024 · Converting numbers and text in Airtable formula fields ; Converting unix and epoch time in Airtable ; Using formulas in Airtable's primary field ; Common Solutions: Intermediate. I've tried using the IF (FIND) formula. All plan types. That’s because the & operator is designed essentially as a shortcut alternative for CONCATENATE(). Platform (s) Web/Browser, Mac app, and Windows app. Options. uc oo pn im me rd je vt jd ez