Formulas

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. This is incorrect and should have picked up the $0.00 amount as per the order of the IF statement. Any help would be appreciated! 

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))' column or any other recur units beyond Month(s). I've tried removing parts, but then the formula doesn't create the Next Due Date.  

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 the code to update the field value in the ASSETS tableMaybe such logic can be incorporated into Kuovonne's Prefilled Form extensi

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}' '&hide_Vehicle=true'I

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?

Hi all - I'm trying to write a simple formula that returns a Yes or a No if the Role Rollup (from People) field contains CROPPS Member anywhere in the list. As you can see, it's only returning Yes if the field equals CROPPS Member, not contains CROPPS Member. I've tried several iterations of this formula (search, switch, trim) none returning correct results.  IF(  FIND("CROPPS Member", {Role Rollup (from People)}),  "Yes",  "No")Any ideas?Thanks!Kelsey

Hello,Using a last modified field type named "Closed" and a lookup field showing the last one called "Meter Type" and "Repeat Interval" I am trying to calculate and output the appropriate date when closed is 7/17/2024 16:41, meter type is Calendar Month, and repeat interval is 12, the formula should produce 07/31/2025. However I am repeatedly running into issues with this where 6/30/2025 or 7/1/2025 is all I can produce. Here is the formula I am currently using:  IF( {Meter Type} = "Calendar Month", IF( {Due Date}, DATEADD( DATEADD({Due Date}, {Repeat Interval}, 'months'), -DAY(DATEADD({Due Date}, {Repeat Interval}, 'months')) + 1, 'days' ), DATEADD( DATEADD({Closed}, {Repeat Interval}, 'months'), -DAY(DATEADD({Closed}, {Repeat Interval}, 'months')) + 1, 'days' ) ), BLANK() ) However the output is 7/1/2024 11:41pm when it should be 07/

Hello, I have a look up field which displays a value generated from a formula that lives on another base. I am trying to create a formula field that multiplies the value in the look up field by the percentage value in another field that is generated within the same base (i.e. is not a look up field).I have tried the following:"Look up field value field" * "percentage value field"and then:VALUE("Look up field value field") * "percentage value field"I have tested the percentage field with a simple calc and it works. When I try anything involving the look up field it returns error so it is definitely the look up field thats the issue I think Any hints appreciated 🙂 

Hi airtable Community, I want to prefill muliple fields in an airtable form. The first fields (Project name) is working well but the second does somehow not. Both are normal text fields..What did i do wrong? Thanks & BestMirko 

I have string fields and I want to extract the first two words (minus any punctuation or special symbols). Ideally, they would remove the white space and capitalize each word as well.So a field with “Midnight: A Tale” = “MidnightA”. ”What’s New in Books” = “WhatsNew” I’ve looked all over to find a way to get two words, but can only find out how to get one. I got into RegEx a bit, but couldn’t figure out how to account for the punctuation/symbols. If someone has a slick way to extract the first two words of a string, I’d be eternally grateful!

Hi all, I’m building a CRM and have a field for ‘Contact Frequency’ set as ‘Single select’ with 7, 14, 30, 90 as options. I have a roll up field with ‘Most Recent Interaction’ which pulls from an ‘Interactions’ table. I would like to create a field to automatically mark as ‘Overdue’ anyone who’s ‘Contact Frequency’ has been exceeded. Some searching uncovered a formula which I have tried to adapt no doubt with a glaring error! I suspect that my ‘Contact Frequency’ options are perhaps not in the correct format or need a separate field to convert them into the correct format before a formula can use them? IF({Contact Frequency}=””,””,IF(DATETIME_DIFF(TODAY(),{Most Recent Interaction},’days’)>{Contact Frequency},“Overdue”)) Any help would be greatly appreciated!

Hi Community, this is a little brainteaser for advanced formula wizards. I am stuckHere is the situation:Up to 3 "quality checks" need to be done for some workflow. Each "quality check" has a check box fieldQC1QC2QC3Each quality check also has a single select status field "In Progress", "Review" or "Done".I want to show in a cell a quick overview of what quality check is still outstanding and if all are DONE it should show "ALL CHECKED"- If a quality check "QC A" is required AND QCA STATUS is NOT done -  it shows the letter: "A" (to signal that QC A still needs to be done)additionally to the letter A possibly shown:- If a quality check "QC B" is required AND QC B STATUS is NOT done - it shows the letter: "B"additionally to the letter A possibly shown:- If a quality check "QC C" is required AND still outstanding (not done) it shows the letter: "C"Once all REQUIRED Quality checks are marked DONE, the A, B and C (if required) should dissapear/not show anymore and instead the cel

Hello,I am using Airtable in conjunction with a web app. On my web app, I have a page for a section dashboard that shows communal information. Additionally, I have an individual dashboard, which displays information about a particular user.My problem is that I need a universal link to point users to their individual data.For example, airtable.com/{project}/individual_dataTo further explain, users on my web app can submit data via an embedded form. They can view communal data via an embedded dashboard page. However, they can not view their individual data via being signed in to Airtable. Is this possible via Airtable or an Airtable extension? I would appreciate any help that I can get. Thank you!

Hello everyone. I am new to the Airtable world and I have a question that I would like your help with. I have 17 number fields. They are called A, B, C, D, E ...I want to have 5 fields called max1, max2, max3, max4 and max5. Max1 field is going to be the highest value of those 17 fields. Max2 is going to be second highest value of 17 fields and so on till max5. (They don't have to be unique.)I could find the highest value with the formula MAX(A,B,C,D,...) but couldn't find any info on how to find the other max values.Example:ABCDEFGMAX1MAX2MAX301.316.8503.45.38.58.56.855.316.27.22.3004.47.26.24.4I am not even sure if it is possible to do what I'm asking. But I hope I can get some guidance.

Hi all, I'm trying to extract the first set of data in this single select field using LEFT() and then converting that into a date field. The data extracted will be in Chicago time. When I run this formula, it assumed that the date is in GMT,  and doesn't respect the SET_TIMEZONE. (note last entry where the time should be 3pm but the formula returns 10 pm central)Any ideas what I'm doing wrong here?Thanks! 

I'm trying to use either a SEARCH() or FIND() function to locate a comma within a string. Unfortunately, these seem to be broken on Airtable right now. Am I missing something? This should be pretty straightforward, right?

Hello altogether, this is driving me crazy. I am entering some formulas in my field and while I am adding fields, they disappear. This behaviour is consistent for all the fields. What is going on? Is it because there are too many referenced fields?