Formulas

After extensive searching, I’ve confirmed that rollup functions do not support finding the mode of the values in the rollup field. I can’t be the only person who has come across this need, so I’d love to know what methods are available without using a 3rd party app. I’m not opposed to an automation, but would rather it be as simple and without the need for scripting if possible.

Hi Dear Communauty, Facing a small challenge with my apps actually i need to create a recipe directly but i have to do it into 2 steps as I have diffrents tables and really dont know how to solve itif somebody can help to fix it i will more than happy Thanks 

I have a list of names in the format John Smith MD or John Smith, MD (some with commas, some without) and I’d like them to be in the format Dr. Smith. Is there a formula that can do that for me?

Hi! I’m creating a base of videos from youtube. I have an attachment column in my base and I want to put there video thumbnail. All thumbnails have the same link but with different ID. For example: Link: https://www.youtube.com/watch?v=pAl9SayLzTE ID: pAl9SayLzTE Thumbnail link: https://i.ytimg.com/vi/pAl9SayLzTE/maxresdefault.jpg Questions: Is there a formula that will create a link to thumbnail with a known ID from another cell? So I need some formula that will insert ID in a template https://i.ytimg.com/vi/XXXXXXX/maxresdefault.jpg instead of XXXXXXX

how can we get data from API in Airtable? below is the sample API curl -X GET "https://apiv2.shiprocket.in/v1/external/courier/track/shipment/1559017361980" -H "accept: application/json" is it possible ?

I have a table (Invoices: House) that uses a sequential Invoice # entered in a field type: Number. I am currently entering each one manually as I create a new invoice record in the table. I would like to automate the process of assigning the next sequential number as I create a new invoice record.I am trying to figure out if I can do this with a formula or if I need to use an Automation or a Script.Does anyone have a way to do this?Thanks, Scott

Hello everyone,I am trying to make a nested IF/AND formula to do the following:IF the ‘Date First Contacted’ = blank, status = ‘Not Contacted.” IF the ‘Date First Contacted ‘= not blank and ‘Follow-Up Date’ = not blank, status = “Followed up.”Is it possible to write this into a formula given that ‘Date First Contacted’ and ‘Follow-Up Date’ are separate fields?  Thank you! 

I click the + below.The form opens.I click "Save" but nothing is saved.

I want to create a formula to select the SECOND-LARGEST value among five different categories. I’ve already created one to select the LARGEST value (called “Category 1), and then my thought was to exclude that category and return the max of the remaining four fields. With the help of Airtable’s AI, I got this formula:IF( {Category 1} = "Connections", SWITCH( MAX({Events}, {Programs}, {Support}, {Marketing}), {Events}, "Events", {Programs}, "Programs", {Support}, "Support", {Marketing}, "Marketing" ), IF( {Category 1} = "Events", SWITCH( MAX({Connections}, {Programs}, {Support}, {Marketing}), {Connections}, "Connections", {Programs}, "Programs", {Support}, "Support", {Marketing}, "Marketing" ), IF( {Category 1} = "Programs", SWITCH( MAX({Connections}

Hi all, I import CSV files with salary ranges.There are two fields from CSV: “Salary Min” & “Salary Max”. Their format is $75,000.00. I want to have them in one field ($75,000 - $100,000), so created a third field with the formula IF(  AND({Salary Min}, {Salary Max}),    "$" & {Salary Min} & " - $" &a

Hello, I want to create a food menu, such that customers can view the food items and other details in the gallery view and can order multiple food items at once by submitting. This will streamline process and give a better customer experience. I will provide a tablet or a link to them to make an order; At present, I have the option to give them a form which is not graphical and they have to make any submissions from their table. The data goes into the grid view and is accessed in the kitchen for processing. Thanks

Hello all, I'm looking for some help with a dynamic date filtering challenge in automations.I have a Social Media Metrics table where each record needs to link to all previous records for the same Contact/Platform combination, but only where Date Recorded is before the current record's date.The challenge: Airtable's Find Records action in automations doesn't support dynamic date comparisons (e.g., "Date Recorded < trigger record's Date Recorded"). This means I can't filter to only link previous records—it would link to all records including future ones.I've considered:Manual linking (works but not scalable) MIN/MAX rollup pattern with formula logic (works but still requires the linking step first) External tools like Make.com or scripting (viable but checking if there's a native solution first)Has anyone solved this elegantly within Airtable? Any creative workarounds I'm missing?Thanks in advance!

Hi, we're looking for someone to help us to integrate Airtable with our WordPress website (particularly Ninjaforms), with a pdf generator and with Canvas by Instructure. This is us www.thelearningcircle.co.uk Please get in touch on info@thelearningcircle.co.uk

Hello!I'm having issues with Airtable's default GMT timezone. I have a Date field (which I do not want to have time displayed for) as well as a formula field using the DATEADD formula to calculate the next time a task is due, based on frequency. In the formula field, I can specify timezone. In the Date field, I can't - without adding the time. Because of that, it's calculating incorrectly - everything is off by a day. Only when I add a time do the dates show up correctly. Is there any way to fix this? Do I need to add something to my DATEADD formula? Thank you!   

If I use an automation to update fields, does it update the fields in the order listed in the automation? So can I copy data from the existing fields first then update the fields with new data all in the same automation? If they update in order why can't I rearrange the order? just have to delete and reorder them all manually...

We have various sales/participation goals that change every year. My idea is to essentially store a unique formula for every goal, for every year, in a text field in a year table. Then in the main table, lookup that text field and somehow create a formula field based on that to do the actual calculation. Is that possible? Year Goal Name Criteria (single line text field) 2024 CP Sales Goal IF({CP Sales Rollup} >= 50000, 1, 0) 2025 CP Sales Goal IF({CP Sales Rollup} >= 60000, 1, 0)  Client Year (link) Criteria (lookup text field)

Hi All, I try to fill a formula field with an email address based on another (email) field ( Source) using a nested formula:IF(Source = "Direct", "ulf@bayinvent.com" ,  IF(Source = "Oase" , "info@camperoase.de",

I want to create an automation that triggers different emails dependent on record conditions. Mainly status changes but also some with multiple conditions. Automation:Trigger - when a record matches conditions - if status not emptyActions - If status is ‘phone interview’ then send email ‘1’Otherwise If Status is any of Phone Interview, Forward to Site interviewand if Last Modified is 5 days ago then send email ‘2’Otherwise If Status is any of Phone Interview, Forward to Site interview and if Last Modified is 10 days ago then send email ‘3’Otherwise if If Status is Site interview set then send email 4Otherwise If Status is Site interview set and if Site interview date is tomorrow then send email 5Otherwise If Status is any of Forward to Trial, Completed interview and if Last Modified is 5 days ago send email 6Otherwise If Status is Site Trial and if Area is any of Motor Vehicle Maintenance and Repair (Light

Hi all!  New Airtable user here. I need help! i have a ongoing master list of every transactions each of my credit card makes.on another table i want to be able to track the outstanding balance of each credit card. i understand i need to use to rollup function, but i cant seem to figure it out!I would appreicate any help!Credit Card Dashboard (where the it shows outstanding balance for each card) Thank you.

Hi community! I’m trying to build a formula that generates a Pre-Processing Lot ID for each seed movement record. The logic depends on whether the movement is linked to a contract or not.1. When the seed movement is linked to a contractThe Lot ID should concatenate:{Final Initials (from Farmers)} {Program (from Contracts)} {Seed Variety (from Contracts)} The last two digits of {Crop Year (from Contracts)} {Contracts} (the contract number) The final Bin code (from {To Bin}) following these rules: If the seed is moved to one of these bins — HK 01, HK 02, HK 03, HK 48, HK 49 — the lot number should display the full Bin code (alphanumeric). Any “Bin ” text prefix should be removed. If the seed is moved to HPB1, HPB2, or GP WHPB, or the movement goes to a Cleaner (

Hi! Trying to figure out how to make a field that turns these times into a 24hr format. I’ve tried 2 different time formats examples (01:00 PM - 7:30 PM) as well as (3-8 PM). I’m have a hard time figuring out a formula that will display that in a 24hr format? Any ideas? 

Hi there, I’ve been using Airtable for a while and using Pre-filled form for about 3 years now, but I’m having issue recently with some pre-filled form with linked records. I have 4 pre-filled linked record in this form : https://airtable.com/app3VaYZ9KK6HEimn/pag88B7PDY9L5izzt/form?prefill_Session=70&prefill_Formateur=Camille+Rabineau&prefill_Entreprise=Founders+PledgeAnd only 3 show up and the last one doesn’t. It does appears in the URL though, it’s just nor displaying it. Here is the formula I’m using : SUBSTITUTE(CONCATENATE("https://airtable.com/app3VaYZ9KK6HEimn/pag88B7PDY9L5izzt/form","?prefill_","Session","=",ENCODE_URL_COMPONENT({ID 2026}),"&prefill_","Formateur","=",ENCODE_URL_COMPONENT(Formateur),"&am

So I’m looking to employ a formula to provide a word count for my SEO keyphrases, which range from 2 to 8 words. Below is the formula that I thought would work, but I’ve had no such luck…does anyone have any thoughts as to what’s going on here? Thank you in advance! IF(({Keyphrase}=BLANK()),0,(LEN({Keyphrase}) - LEN(SUBSTITUTE({Keyphrase},’ ', ‘ ’))+1))

Hi everybody,Our company has 3 x sized boxes - small medium large.We fit the following quantities of our product in each  box:Small - 95Medium - 200Large - 300What I want to do is tell a user how many boxes each order will use. I’ve achieved this with nested IFs:IF({quantity} <= {Small Box (from Link To Products)}, "1 x Small Box", IF({quantity} <= {Medium Box (from Link To Products)}, "1 x Medium Box", IF({quantity} <= {Large Box (from Link To Products)}, "1 x Large Box",ROUND({quantity}/{Large Box (from Link To Products)},2)&" x Large Boxes")))This works well. My only issue is with the last statement when orders exceed 1 x Large Box. With an order larger than the size of 1 x Large Box, it returns a decimal of large boxes e.g. “2.67 x Large Boxes”. My question relates to the deicmal  - I now want my formula to say whether that residual decimal would fir into a small box,

I created a Check-In button that uses a formula, and it was working fine for a couple of weeks. However, it recently stopped pulling and autofilling the “Time Card” field. I also have staff use our interface to check in and log time for hours used on the time card.formula: "https://airtable.com/appLI7NsuW6OZb1VH/pag4DxG1LCOxskSQE/form"& "?prefill_Time%20Card=" & RECORD_ID()& "&prefill_Rental%20Date=" & DATETIME_FORMAT(TODAY(), "YYYY-MM-DD")