Formulas

Is there a way for airtable to check if the single select option in my first row is different from the single select in the fourth row?The top three rows are respondent data from Pre-Surveys and the bottom three are respondent data from Post-Surveys.I want to calculate the percentage of participants who have been positively impacted by a programme.

I’ve got a database with events that I am using a list format to display -- the main reason for a list instead of a calendar is that I want people to be able to filter the type of event by tags and have a visual queue of event items. I’ve got the conditions of the list set to only display events that come after yesterday’s date, so once an event passes, it falls off the view. Additionally, this is a calendar that is populated by the community at large via a form.Most of the events are single date events, so the standard M-D-Y h:mm a format for the date is fine, but when the event spans multiple days (conferences and festivals for example), I’m having trouble figuring out the right formula to display these events with the series of dates (4/10/26-4/12/26, for example) so that they will stay on the view for the duration of their schedule. I know how I want this formula to function, but everything I’ve tried doesn’t seem to work. I’ve got a column for each event that is a checkbox -- “Is

HelloI’m currently working on a Production Planning base, which is essentially a way for us to communicate with factories on the projected production they can expect from us for the forthcoming months. Currently there are two sets of data:Projected Units  Quantity attached to a “Launch” or a “Deal”.  Confirmed Units. Quantity of confirmed units which have Purchase Orders attached As an example, we have a deal across “P6 & P7” (period/phase) with a customer and projected around 500k units. The problem is that the factory is not going to produce all 500k units at the same time and this deal stretches over a period of time - which based on the customers sales calendar is Feb-Mar-Apr. That is their sales window, so we need to work backwards around 10 weeks for shipping and then an additional 30 days for production.I’m currently trying to figure out the best way to disperse the 500k units realistically across the full period span so we can give the factory an idea of when we expect the

Today I noticed an issue with Lookup values—Airtable formulas are not recognizing them in conditions. Is anyone else experiencing the same problem?

Hi,We’re automating invoice creation, and need therefore to create payment reference numbers. I’d prefer to create these programmatically within Airtable.As a basis I wanted to use a autonumbering field we already have for creating unique IDs for the orders. Basically the base number will get an added checksum number, so that electronic banking systems can validate that the payer has entered the correct reference number.I found an Excel formula that creates the reference numbers according to our (Finland) banking standards (have tested, it works in Excel). I have been trying to convert it to Airtable, but I can’t get it to work.ORIGINAL:=IF(ISNUMBER(A2);(10*A2+RIGHT(10-RIGHT(7*MID(10000000000+A2;2;1)+1*MID(10000000000+A2;3;1)+3*MID(10000000000+A2;4;1)+(7*MID(10000000000+A2;5;1))+(1*MID(10000000000+A2;6;1))+(3*MID(10000000000+A2;7;1))+(7*MID(10000000000+A2;8;1))+(1*MID(10000000000+A2;9;1))+(3*MID(10000000000+A2;10;1))+(7*MID(10000000000+A2;11;1));1);1));"") Identified change needs:cell

Hi Airtable community! 👋I’m working on a base where I need status updates in one table to automatically reflect in another table — and I’d love advice on the best way to build this.BackgroundI have two tables:📌 Projects Project Name Status (e.g., “Planning”, “In Progress”, “Completed”) 📌 Tasks Task Name Linked Project Task Status I want to automatically update the Project’s Status based on the status of its linked Tasks. For example: If all Tasks are “Completed”, set Project Status to Completed If any Task is “In Progress”, set Project Status to In Progress Otherwise, Project Status should remain Planning Right now I’m using rollups and a formula field, but I’m wondering if there’s a cleaner or more reliable approach — especially when tasks are added or changed frequently.Specific Questions Rollup + Formula strategy: Is using a rollup of Task Statuses with a conditional formula the best practice for this? Automations: Would a script in Airtable Automations perform this m

can someone help with this formula, when there are no dates in the fields it returns 12/31/1969, i’d like it to return a blank or “none”  DATETIME_PARSE(  MAX(    IF({Last Entered Patrol Start Date (from Patrol Reports Section 1)}, VALUE(DATETIME_FORMAT({Last Entered Patrol Start Date (from Patrol Reports Section 1)}, 'x')), 0),    IF({Last Entered Patrol Start Date (from Patrol Reports Section 2)}, VALUE(DATETIME_FORMAT({Last Entered Patrol Start Date (from Patrol Reports Section 2)}, 'x')), 0),    IF({Last Entered Patrol Start Date (from Patrol Reports Section 3)}, VALUE(DATETIME_FORMAT({Last Entered Patrol Start Date (from Patrol Reports Section 3)}, 'x')), 0),    IF({Last Entered Patrol Start Date (from Patrol Reports Section 4)}, VALUE(DATETIME_FORMAT({Last Entered Patrol Start Date (from Patrol Reports Section 4)}, 'x')), 0),    IF({Last Entered Patrol Start Date (from Patrol Reports Section 5)}, VALUE(DATETIME_FORMAT({Last Entered Patrol Start Date (from Patrol Reports Section 5

Have a form that a record picker is used to select a client and am trying to get a encoded URL into a button that can be selected from within an Interface page and have the client pre-selected.Have made plenty of Forms pre-filled encoded URLs (Button linked to formula building the URL), but cannot get this one to work - only seems to be for the Record Picker elementHave other URLs for this exact form that work fine, eg:https://airtable.com/appgAgIX5zNGRiox4/pagqzLgwghd7xBloc/form?prefill_Action+Type=Maturing+Term+Deposit&prefill_Task+Name=Maturing+Term+Deposit+-+(Bank)(Amount)(Date) But when I try to pre-populate the record picker under Client (which selects record from a linked table) it just doesnt fill it. I have tired manually creating:https://airtable.com/appgAgIX5zNGRiox4/pagqzLgwghd7xBloc/form?prefill_Client=Shane+HarrisHave also tried using the Prefilled Forms extension using field names or field ID and get the same result

// change these names to pick a view:let table = base.getTable('Invoices');let view = table.getView('Grid view'); let result = await view.selectRecordsAsync({fields: ['Amount']});let runningTotal = 0;for (let record of result.records) {    // change the field names here to adapt this script to your base    runningTotal += record.getCellValue('Amount');    await table.updateRecordAsync(record, {        'Running total': runningTotal,    });}

I'm creating an athlete database. I want to create a column that shows where an athlete ranks, for various metrics, relative to everyone else. For example, let's say someone is 6'9" tall and that puts the athlete in the top 2% of all the athletes in the database. How can I calculate that for that athlete (and every other athlete)? Is that possible?

Hello - We are creating a way to track social media posts for our clients. Clients will ask us to make a certain number of social media posts on their behalf, we then want to keep track of how many social media posts have been made and how many are still required for each client contract. Here are the two tables we have created Social Media Posts Created - Airtable - Content overview Social Media Contracts (requests) - Airtable - All content and requests I’m new to Airtable, so this may be a simple formula, but any help would be appreciated.

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 

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 I insert the result of this formula in the Attachment field? Can I somehow receive other info about a video by the link or video ID? (I understand that is another question and big topic, but maybe you have some useful links to read) Thanx!

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}, {Events}, {Support}, {Marketing}), {Connections}, "Connections", {Events}, "Events", {Support}, "Support", {Market

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} & " - $" & {Salary Max} & "/yr",    "") However,  I get “$75000 - $100000/yr”.I looked around and tried AT’s AI but so far luck.Is there a way I can resolve this? Thanks a lot 

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) CP Sales Rollup Points (formula) ABC 2024 IF({CP Sales Rollup} >= 50000, 1, 0) $35,500 {Criteria} should return “0” ABC 2025 IF({CP Sales Rollup} >= 60000, 1, 0) $75,750 {Criteria} should return “1”  In the Points formula field, how do I write the formula? I’ve tried just putting in a reference to the Criteria lookup field: {Criteria}, but that doesn’t work. I assume there has to be some conversion from text