Formulas

Hello everyone,I'm trying to extract the first Date&Time from an array from a lookup field that looks like this:2023-06-02 11:00, 2023-06-07 11:30, 2023-06-12 11:45, 2023-06-23 11:00, (etc)But using this formula: ARRAYSLICE({Lookup field}, 1, 1) Gives this result: 2023-06-02T09:00:00.000Z which doesn't get recognized as a Date&Time, so I can't format it.  Is there maybe something I'm doing wrong? Thanks in advance for any advice

Hello,I have a formula in Airtable which should output "SMS" if certain conditions are met.This formula has worked for a long time and has not been changed. Now I have noticed that something has been changed in the formula function and Airtable indicates that the formula is incorrect. I can save, but I can't find the error that Airtable is referring to. What am I doing wrong in the formula?  IF( AND( OR( {Terminart} = "Hauptuntersuchung (HU)", {Terminart} = "Sicherheitsprüfung (SP)" ), OR( AND( MONTH(TODAY()) = MONTH({Datum nächste Prüfung fällig}), YEAR(TODAY()) = YEAR({Datum nächste Prüfung fällig}) ), {Datum nächste Prüfung fällig} < TODAY() ), WEEKDAY(TODAY()) = 1 ), "SMS" )   Please correct the following errors in the formula: Missi

I am using a form with some prefilled fields. It works great as long as the item name doesn't include certain special characters. For instance, if it includes an "&" anything after the "&" won't be prefilled. So "Mop & Broom Holder" prefills as just "Mop". Some of the product names we have are a bit long, so it can be a pain to have to type everything out. I know why this is happening, but I'm wondering if there is a way to include the "&" in a url and have it be part of the prefilled information. This is the formula I am using in the button that leads to the form.Form URL'&'?prefill_Name='&Item&'&prefill_Quantity='&{Received Qty}&'&prefill_Project+Tag='&{Project Tag}&'&prefill_Date+of+Update='&

Is there a formula to have a checkbox automatically checked if the current date is later than a specific date field in that record?  We want to be able to sort by "eligible" records and have it automatically updated as each goes past its "eligible date."  Thanks!

Can anyone please help me solve this issue? Before 1/1/2024 I have to calculate a 2.99% fee and after is different 2.29%. I am trying a formula but only giving the result after 31/12/2023, before the result is blank: IF(    {Date Booked},    IF(        IS_AFTER(                {Date Booked},                DATETIME_PARSE(                 &nb

Hello - I'm trying to figure out how to set a price based on 2 other columns. One column is Product Type (Socks) and the other would be Variant (single or 3-pack). So for example if Product Type is Socks and Variant is Single, the Price should be $3; if the variant is 3-pack, the price would be $8.Both Product Type and Variant are single select values, and I could potentially make the Price a single field as well. I also thought of combining Product Type and Variant into one column (Socs - Single, Socks - 3-pack, etc) and do Link Records instead, but I would like to eventually sort by Product Type alone (all socks, for example). Does anyone have any experience in this for inventory tracking? Thanks!

Hi all,Airtable Table Newbie, but feel in love.I want to group rows by partial text in the field.(CDPA) Campaign 1(CDPA) Campaign 2(CDPA) Campaign 3I want to group all three above using the (CDPA).I assume it would create a formula row to do this, but I do not know how to create the formulaCan someone help?Thanks,Judd 

Hello,I have been using the article "Writing nested IF statements in Airtable" as my template for assigning performance ratings based on a percentage score. This is basically exactly like the example in the article, however, I have not been successful. I cannot get "MSE", "FME", "EE", etc. to populate at all, only "DME". I tried using SWITCH as an alternative and was not having success there either. Can anybody tell what I'm doing incorrectly, and how I can remedy this problem?

Hi Airtable Community! I am looking for a way to pull values from multiple columns into a single cell. The setup is as follows: I have a list of countries, and each country has a team comprised of people from multiple departments. The departments each have their own table in the base, so when I create a table of Country Teams, each line item (country) has multiple departments that it's pulling from. In the example above, the bolded columns represent linked records. I need help creating the "Team List" column and eventually the "Team Email List" column (which will likely use a Lookup or Rollup function to pull emails from the different Department tables). But I have been having trouble figuring out how to create a column that pulls values from multiple columns across an entry. Can anyone help with this? Thank you! 

Hi there,New to Airtable and have been experimenting with it, together with ChatGPT and reading the community treads.I'm trying to create a system for my new video production company, where I'd like to add single or multiple freelancers to each project and set their day rates and number of days worked. Ideally I would have a default value, but I want to be able to set different day rates for different freelancers even if they are working on the same project. This would be helpful to track what each of my projects costs (I have an Expenses table as well) and I want to incorporate these to a Cashflow table later.I have a Freelancers and a Projects table so far, they are linked to each other. ChatGPT and Bard recommended me to use formulas that try to reference fields from the linked tables, but as I read it here, that is not even possible.What would be the best way to go about it?Many thanks,vor

Hi! I am working on maintaining student learning records. I have two multiple select fields: one with "Student" names and one with demonstrated "Competency". I would love to create new rows for each combination of Student and Competency, and copy over the same Date, Experience Description, and Location. For example, record number 2 on the screenshots,, I would like one record with the same date/description/location for Chloe/STEM-Scientific Application, one record with the same date/description/location for Chloe/Design-Outcome, one record with the same date/description/location for Emily/STEM-Scientific Application, Emily/Design-Outcome, one record with the same date/description/location for Kendall/STEM-Scientific Application, and one record with the same date/description/location for Kendall/Design-Outcome. 

Hello All, I’m trying to build a checklist. I want to Compare all linked Field “Items Needed” with linked Field “Items Owned”; and then output difference between the two in Field “Missing Items”. I tried the simple Min() formula for Items Needed - Items Owned = Missing Items, but I don’t the Airtable likes the Min() with linked records. Also, I converted the linked Fields with arrayjoin() and made two more fields, but again Min() does not work on that either. (Not to mention the array join option would run into issues with order of which the linked fields were created). Is there a function I am missing? How do you guys compare and output the difference with linked fields or list of alpha-numeric/array data? Thanks.

Hi… Here’s my scenario Table 1 has one column called Tags and has multiple single word values Table 2 has the columns: Phrase, Primary, Secondary and Tertiary. Primary, Secondary and Tertiary are linked records and contain tags from Table 1. Multiple tags exist in each column I need a formula that checks if primary, secondary and tertiary has common values.

Hey Lovely People, I have been searching endlessly on Airtable community for a formula that helps convert numbers into texts (such as 1,555 into one thousand, five hundred and fifty five). There were some extremely complicated formulas that simply didn’t work the way they should and there are no scripts. I wish I was a developer to do one. Is there someone out there interested in helping creating such a script? Please note that I need them more than 9,999 (meaning I have some numbers in millions as well). Best, Hady

I'm new to Airtable and I need a formula to check a box from a form submission.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 boxes. I also tried setting an automation to check the box if it meets criteria but that isn't working either.Any help is greatly appreciated.

If my muliselect field has 25 things in it.I want to find Apples and return apples in the formula field, and I want to find Pears and return Pears to the formula field and if that multiselect field finds both i want it to return Error and if none i want it to return a blankthanks for your help!_Mary

I am such a novice at this, I hope I can accurately explain the problem. My goal for this to combine the sales and listing data from online source with my product data that I need to help me understand what is working and what designs I need to focus more on. Within a single Base, I have 2 tables with 2 sets of Data that are not currently linked. I will call them TABLE A & TABLE B. TABLE A - contains rows of listings for online products. Each row contains a single product with various details about the listing. This data is updated from an external source of my online vendor. For Example, A1 Title / A2 Listing Copy / A3 Number of Sales / A4 Product type / A5 UPC / etc… TABLE B - Contains my information about the online product. This is info and categories that I have created to help me track my designs and organize them for my use. Fo

I have the following formula in a field names "Status":IF({Current Performance}=5,"5: Excellent",IF({Current Performance}>=4,"4: Good",IF({Current Performance}>=3,"3: Fair",IF({Current Performance}>=2,"2: Poor",IF({Current Performance}<2,"1: Very Poor")))))The Current Performance field is a lookup field set to show the last (most recent) item from the related table.If the Current Performance field is blank (no record in the lookup table) the formula will return "Very Poor" even though there is no number in the Current Performance field. I've tried various iterations of the formula, but can't seem to make it behave properly. Essentially, if the Current Performance lookup field is empty there should be no corresponding record in the Status formula field. Any ideas/suggestions?

Formula for 1st Column:IF(IS_AFTER(TODAY(), {MOC Requested}),  DATETIME_DIFF(TODAY(), {MOC Requested}, 'days')) Formula for 2nd Column:IF(IS_AFTER(TODAY(), {MOC Requested}),  DATETIME_DIFF({MOC Submitted Date (from Memo of Correction)}, {MOC Requested}, 'days')) 

Hey there, I'm trying to gain access to the Download Attachment URL (without using the API) so I can upload images from the Attachment of a record to a social media platform. I've tried using a workflow of AirTable --> Zapier --> Social Media Platform, but I can't find a way to get the image in my AirTable's attachment field to the social media platform. Let me know if you know how to help! PS -- The reason I don't want to use the API is that I saw AirTable's recent notice that they are disabling API access at the end of this year. 

I have a table with work months like here: I'm trying to calculate the start and end datetimes of the month but the formula is giving inconsistent answers. It's correct for some months but there's an error in End Dates for March, May, July, October and December.Here is the formula I'm using for Start and End dates:Start Date:DATEADD(DATETIME_PARSE(YEAR({Work Month}) & "-" & MONTH({Work Month}) & "-01", 'YYYY-MM-DD'),-7,'hour') End Date:

Hi I really need help for this and I have a deadline. So basically, I was wondering if there's a way that I can create a formula that add's up the number of time "" is used across all fields and shows the result as a number in the "s Used" field.. For example for the highlighted square, since "" was only used once, it would appear as 1. But for the cell above, because "" was used twice across all fields it would be entered as 2. thanks so much! 🙂

Hi ,I am creating an airtable automation for recurring task for weekly, daily, monthly, 3 times per week and twice a month  In the next to perform date i used this formula DATEADD({Due Date},SWITCH(Frequency,'DAILY',1,'WEEKLY',7,'MONTHLY',30,'TWICE A MONTH',15,'3 TIMES PER WEEK',3),'days') It works perfectly well for daily, weekly and monthly, twice a month but it doesn't work for  3 times per week i need (Monday, Thursday and Sunday)can you please help me with the formula?

Tracking nurse staff schedules with doctors.Column 1 lists nurse staffs, column 2 the doctor engaged with that staff, column 3 = # of patientsFor example, column 1 may have the following fields:A1 = Betty, Joel, CindyA2 = Suzanne, Betty, MikeA3 = Cindy, Beatrice, RosariaB1 = Dr RodriguezB2 = Dr BlakeB3 = Dr BakerThe goal is to be able to add up patients between a single nurse w doctor combination, i.e. Betty with Dr Rodrigueza normal CONCATENATE of A1 and B1 will say Betty, Joel, Cindy with Dr Rodriguezanyway to be able to recognize all 3 combinations?I have a junction table with a CONCATENATE of Betty with Dr Rodriguez but I don't know how to then go grab and sum the # of patients anytime where Betty is true in column A and Dr Rodriguez is true in column B.

Hi,I am trying to write a formula to write the wider region that the project is related to, e.g. if it's in Germany, it's in EMEA. This formula works; however, I now want it to be able to list multiple regions for projects that are taking place in two different countries that aren't in the same region.e.g. a project that is in Germany and in Canada should show 'EMEA, CAN'. Currently it just shows 'EMEA', not both. Please could someone suggest how to change this formula to print all that apply? (Tagging @Databaser who helped with my previous question in case they can help, "Complex Nested IF AND statement (dates and regions)")Thanks,  IF( REGEX_MATCH({Division}, "UK|ROI|France|Spain|Italy|Greece|Poland|Germany|Portugal