Formulas

Hello community,I'm building some kind of table where it has repeated content in the rows that I would love to have them combined, similar to a merge cell in Excel or Google Spreadsheets.Is it there a formula or a scripting that can help me have some structure like in the attached image?Thanks!Leandro

Hi I am trying to figure out how to remove the NaN value when the formula is 0/0I need it to reflect 0.  I have tried IF() and IF(And( formula's but I cant seem to get it to work current formula is {Surveys Recieved-MGR}/{# of Managers} Does anyone have any solutions?Thanks !

Hi All,I'm attempting to calculate a simple calculation from fields that already exist in a given table: ({gross_expected_revenue_per_qty_sold} * ({your_split} / 100) * {qty_sold}) - {cogs} - ({printing_costs} * {qty_sold})I thought I was going crazy, had two different AIs look over this, and even after that, it the formula doesn't work. None of the fields from which this calculation is pulling are empty, 0, or negative, and for some reason, this still throws an error when I run it.  By the way, your_split is a switch formula that puts out a percentage like "35%" for example. Thanks.Any idea what could be going wrong, here? Thanks!

Hello,I need your help with comments. Users of my interface can easily enter comments on a records. The problem is that I have other tools linked to Airtable, and I would like to find a way to put the date of the last comment or just the comment count into another field to trigger an automation that launches a webhook. Do you know if this is possible?Thanks in advance.

Hi There -Im having trouble with adding dynamic mentions with my slack message automation in airtable. Currently my airtable is connected to salesforce where it pulls a managers name into the airtable record. I'd like to set up an airtable automations that messages a specific slack channel, that mentions that specific manager. There will be a number of different managers and I dont have an actual list.From my understanding, I need to set up a formula that looks up the managers slack id, but im not sure how. I dont want to have to manually link the slack ID as there may be new users added from time to time. The airtable documentation around dynamic mentions kind of makes sense but im still missing the piece on how to lookup the slack id. It says to use the following CONCATENATE("<@", {Slack member id lookup}, ">")but im not sure if i need to manually find the id and insert it above? or if this exact formula should au

Hi everyone,I have been struggling with comparing a date of when a record has been created to a date I am manually inputing into the formula. So basically I am trying to use the IS_AFTER function but have tried so many things and just everything is either coming up with error or false to all fields even though i know some of them are after the date i am specifying.I am trying to get all records that are true to being created after the 21/10/2024 and feed them into a make.com automation using this field or formula.This is the formula I have been using but all the fields are showing up as 0 (false) when there are definitely some records created after the 21/10/2024. I had to use the date format with the date parse as it was automatically formatting the date in US format even though I have specified the format? IS_AFTER(DATETIME_FORMAT(Created, "DD/MM/YYYY

Hi there,I'm trying to utilize Airtable to manage Shopify Metafields (among other things), but am striking out with doing this in what I believe to be the most logical way.I've configured a field (column) as "multiple select" with preconfigured options (the array). This ensures we're dealing with legitimate values.Syncing to Shopify, through the use of AirPower, requires the metafields to be in the format:["MF1","MF2","MF3"] I've used ARRAYJOIN to convert the array to a string in a separate field, but am stumped at actually formatting the square brackets and quotes.Suggestions?TIA,Jeff

Hey there. I’m using this formula for a column: DATETIME_FORMAT({Date of Donation}, ‘M/D/YYYY’) & " — " & IF({Donor Account}, {Donor Account},{Company account}) It’s pulling some company account names that have commas in the title, generating unwanted quotation marks around the field name.: 10/24/2019 — “Farrar, Straus & Giroux” Can I drop something into the formula that will eliminate the quotes?

Hello, I need help structuring my datetime_format as it has been showing inaccurate days.What I want is to have ~ Live Event ~ On-Air Start date(MMDDYY) and my formula is below:However, with this formula, it is producing a date that is the following day when any time is past 12:00. I'm using the 24 hour time clock.Can someone help me fix this? 

Hello! I am currently using the below formula to pull together a list of cities that correspond to a record. I have City 1, City 2, City 3, City 4, City 5, Cities 6 fields. Formula looks like this: CONCATENATE({BP City 1}, ", ",{BP City 2}, ", ",{BP City 3}, ", ",{BP City 4}, ", ",{BP City 5}, ", ",{BP Cities 6}) My formula works if all 6 fields contain cities although it doesn’t look great if only one city is listed. It ends up looking like this: Philadelphia, , , , , Anyone know how to fix the formula so that the appropriate number of commas appear so there will not be a string of messy commas at the end? Thank you!

Hello, and first off, thank you to everyone for all the help in the community. Long time lurker, first time poster! My business uses a series of documents that go through a few statuses - drafted - sent - viewed - and complete. The way my table is set up and with a few little automations I have the ability to know the duration between those statuses. The problem is, I only can get the duration between the statuses when they change, not the duration that’s been going on between that time - if that makes sense. My end goal is to know (even roughly) how much time (days are fine) since a last update of any of the actions. For example, I would like to know how long it’s been since ‘viewed’ so I can see if a document is past the parameters of being on-time and contact my customer to support them on completing their document. More simply - I would like to know how long something is ‘in’ one of the statuses - again, rough dates are totally ok. Initially I

I'm attempting to assign an Award Name to an Award Picked field if an applicant says 'Yes" they want to apply for that award.So, if someone says 'yes' to the First Award, I would like the Award Picked column to read "First Award Name".  Same for Second, Third, etc. (I have 21 awards). If they don't say yes, then it should be 'blank'.I tried the AI formula (which came up with the same thing I tried myself) but the Award Name does not appear, only 'blank'.Any help would be much appreciated!! 

Hi Community, i have a single select field with the following options. I want to add up the results from different columns in a formula. To do this, I need to extract the score from the rest. For example, only “2” should be extracted from “2 More then 20%” in the formula.What is the best way to do this?   Thanks & bestMirko 

Hello,I'd like to compare the date between two columns from the same table.I've used the chart extension but I can't seem to add it on my interface. Here is how the data looks like : Is it even possible to compare it on the interface? Or add the chart extension on the interface?Would like some help please.Thank you

I am facing difficulty in prefilling forms with 'Link to another record data type'Data is occasionally getting printed when the data type is 'Link to another record' with 'Allow linking to multiple records' switched 'ON' What changes should I make so that it works well? 

Hello everyone,I am trying to get my formula to recognize numbers >= $0.00 in all of the columns listed:  My formula: IF({August FY25 Projections},{August FY25 Projections},IF({FY Start Split Formula},{FY Start Split Formula},{Original FY25 Revenue Projections})) For reference:The August FY25 Projections column is a currency fieldThe other 2 fields are formulated fields with a currency format.Attached you can see the "Updated FY25 Revenue Projections" column is skipping over the $0.00 amount that is listed in the August field. T

Hi all,I have two tables: Projects and Tasks. Each task has one or more municipalities. What I'd like to do is check if all the municipalities in each task associated with a particular project are the same. I initially thought I could do this with a rollup and ARRAYUNIQUE(values) and a comparison of the Municipality field with the rolled up field. As you can see below "Glenville, Rotterdam" is a match, but that is not what I am looking for. I only want a match if all the fields are exactly the same.Any ideas on how to achieve this? 

Brand new to Airtable, so forgive me if this is a dumb question.  I've shamelessly stolen a formula to calculate start and end dates based off a T- or T+ from a specific event. DATETIME_FORMAT(DATEADD({Calculated End date},{Days Needed to Complete},'days'),'MM/DD/YY') The dates are calculating just fine, but when I try to add a Gantt view, it doesn't allow me to choose these fields to determine the dates for the Gantt.  What do I need to do to have Airtable recognize the output of this formula as a date?

Hi! Below you'll find two screenshots - one is the template I started with and the other is the base I'd like to implement the reoccuring tasks formula/automation:The OG formula is too long to allow me to copy the entire thing in. This is the template: https://airtable.com/appcm1NtFWzs7vnnM/tblE0zWlg5lUgvbFU/viwOzsxF54gJeKpdS?blocks=hide the formula is under the Next Due Date column    Can someone edit the formula to remove all of the options except for monthly reoccuring tasks? I don't need the 'Days (Only if Set to 1 Day(s))' co

Please someone help me to hide #ERROR! - not all my fields have dates insert and in this case ERROR appears IF( AND( {date}, NOW() >= DATEADD({date}, -30, "days") ), "ending time" )thanks a lot 😉

I use several different forms that let users update field values. Upon submission a new record is created in an UPDATES table and the associated record is updated in the ASSETS table. This is accomplished using Kuovonne's Prefilled Form extension.Note that if a user submits this form and the field value on the form is empty, then the associated existing value in the ASSETS table will now be empty as well, which is expected. To prevent this, I can make that field in the form mandatory in order to submit, so it contains a value.However, I am facing a situation where there are six or so fields that a user may want to update -- but may only want to update some of those fields. Is there a way to add conditional code with this logic?:Upon submitting the form     - For each field that is empty - do nothing     - Else, execute

Hi Everyone!I'm relatively new to AirTable and figured this might be a question for you all! For context... I work with people who don't always reply to their emails or often miss conversations that we need their input on. Which means process get delayed when I don't get the answers quickly. That's okay though!Anyways, I'm looking to create a prefilled form link that can list out all the questions in one place and constantly update. My idea is that those who answer the questions immediately will only see the most recent while those who miss emails or don't reply will see all of the questions they have not answered. The first part, generating the prefilled form link I figured out.Now I for my ask for you folks - Is there a way I can conditionally hide fields if they answered the question in the past in the custom link. I'll use the example of one of my questions being "Vehicle" I know it won't be as easy but imagine their is a something like '&if'{vehicle}'

Hey all I have a table where I have many hidden fields. I want to have a field only visible if a certain condition is true. Is there some kind of IF statement functionality that can conditionally toggle between showing/hiding the field if certain conditions are true? Thanks C

This should be a simple fix but I'm not seeing it.I'm doing a record search in Make.com using the Airtable Search Record module. See the attached screenshots.I'm trying to filter out records that already exist. But I'm getting the same output regardless whether I use the NOT() function.If I use the NOT() function I get 15 bundles output from that module. I get the same bundles without the NOT() function.What am I doing wrong? 

Context:I have two different tables: A User Info table, and an Event Request table. the relevant columns User Start Date, Event Start Date and Event End Date.Current Status:I am calculating the duration of the events in the Event Request table, pulling it into the User Info table and summing it to calculate total event duration per user.Issue:I want that event duration to reset after passing anniversaries of the user's start date. Any thoughts?