Formulas

Hello,I configured my date format to European on Airtable, however, when I send this data to Integromat and making a Google Sheet template, it reformats the date in US.Date on Airtable (03/12/2022) :Date format received by Integromat (2022-12-05, yes I know is not the same date :p) :Date on the template :Do you have any idea why the date format changes on export?Do you know any way to circumvent this?Thank you in advance!

Hello, I have one formula field {Ball 1 ?} in the table A . The formula checks another table {Ball 1} via a linked record to see if it contains an attachment. If it does, the computed field writes "Yes", if it is empty, it writes "No". This part works fine.I have another field (checkbox) named {Balloon 1} in the table A, that I want to add to the logic.But when I add {Balloon 1} to the condition:Meaning : If {Ball 1} OR {Balloon 1} is true, then writes "Yes" in {Ball 1 ? } and "No" if it is false.I receive an error and it doesn't accept the formula.Here is how I wrote it in the formula field {Ball 1 ?} : IF( OR( {Ball 1},{Balloon 1} ), " Yes", " No", )  How can I fix it ? Any advice ?

Working on costuming for a film - have 4 main tables of Actors, Costumes, Scenes, and Characters.There's a lot of table to table referencing going on w/ lookups...But one thing I would LOVE to be able to do:When looking at the COSTUMES table (characters have multiple costumes) - there is a lookup field that shows what SCENES that costume is used in.  (Scenes are described by a number).In the SCENES table - I have a check mark field to keep track of what scene is wrapped (already shot)Back in the COSTUMES table, the scenes a costume is used in all show up as a list of numbers in little grey pill boxes. I'd LOVE it if the color of those pill boxes could be colored differently if they have a checkmark in the "wrapped" field in the scenes table.I created a conditional coloring of records in that SCENES table... but alas, it does not translate that record color over to the pills in the lookup field in the COSTUMES table. This image is from the COSTUMES table - pointing at a lookup fiel

I don't understand why this formula isn't working ... I can only think it has something to do with the Now() calculation.IF({Quote Status}="Selected" And(Now()) > {Scheduled Date},     {Scheduled Date},     IF({Quote Status} = "Fulfilled",          {Adj. Fulfilled Date},          {Dummy Date})   ) Any thoughts?  

I have a field with a formula that calculates total days using this formula: IF({Status 📝}="Unassigned", WORKDAY_DIFF({Create Date},TODAY(),'2023-09-04'), "N/A")The formula works, but returns results of 1, 2, 3 etc., which when i try to use this column in a graph it does not sort correctly.  I need the results to be 01, 02, 03 to be able to sort in ascending or descending order or I need a field that reads the formula field and converts it to a number that can be sorted. Any suggestions are appreciated. 

Is there a way to sort the contents of a cell alphabetically? If I create a cell that is gathering data from other sources (linked file, concatenated), can I then take that data and arrange it alphabetically? I'm struggling to find anything that works with the data in a single cell.Thank you for any tips you might have!

Hi!Is there any easy way to add a unit to the number field?I have a lot of tables with dimensions. Some of them are metric, some imperial.I want to show them as:0,234 => 0,234 mmor0,234 => 0,234"Of course without changing numbers to texts - because I do a few calculations on them. Let's say "just view"Thanks for the help,if this is something easy and obvious  - sorry I'm a newbie 🙂regardstomek

I have a form that a member uses to search for their name using a lookup from another base. Because of PII Standards, I can't have their full name listed for others to also see. This basically works as a task tracker so (external) users have to enter their name and what they worked on.A) Is there a way where I can only show the first OR last name OR an abbreviation (John D.)? I have tried using the Regex formula which works (don't have split function), but that only helps me put the first name in another column and won't affect the lookup that is what members use when they open the form to search their name. The lookup is critical because it uses other values associated with their name that helps me in the form to track other things. Or....B) Is there a way so that when they search their name that it doesn't automatically list all the other names? This would be easily solved if the first column of the table that I'm using for a lookup would just show the first name instead of

I am trying to create a field that tells me is a date field, called Purchase Date, is before a specific date, 04/09/2023 (did/mm/yyyy, same format as the date field). This is my formula so far, but it returns a “0” (ie false) on all records so many what date I enter between the “ “ in the formula. IS_BEFORE({Start Date}, "04/09/2023")How do I fix this? Thanks!

Hi, does anyone have any ideas on how to write a formula to mark a previous date for each person?

I am looking for a way to split expenses amongst people in our company without duplicating the total. We purchase company merch/promo items and that expense goes under our expense table and is assigned to 1 of our 7 offices, or corporate. We assign all promo expenses to "corporate". We then have an Inventory and an orders table. I add the inventory in as we buy more and add that to our expenses. Then, as the items are distributed to employees and partners those go under the orders table. The issue is the full expense amount remains under "corporate" instead of splitting it amongst the employees (who are assigned to a branch in the employees table) based on what is distributed to them in the orders table.

Good day to allI am looking for some help for my problem after spending all morning on it. My table is an 'audit table' for blood tests. I have a colum that is a linked field to another table that allows me to select the blood test requested (Samples requested). With each Sample there is an associated turnaround time from the lab. I have set this up as a single select and it is either 24hrs, 48hrs, 72hrs or 5 Days. To view these TAT, I have a colum with 'expected TAT' and this is a lookup field. However, when I select several Samples, I can have several TAT. I only want to see the longest TAT ie if I had 24hrs, 24hrs, 48hrs - I would only see 48hrs. I have tried several different formulas and scripting and not wining at all. Any help is appreciated.

I have a lot to learn in terms of building formulas, and I'm found myself stuck and not sure what I'm missing.What I'm trying to accomplish:If the Completed column checkbox is ticked, display "Completed"If the checkbox is not ticked, display the time difference between the 'Ready for Pickup' Timestamp column timestamp and now in days.My current (not working) formula:IF({Completed}=TRUE, "Completed",(DATETIME_DIFF(NOW(), {'Ready for Pickup' Timestamp}, 'days')) Thank you!!

Hi, I'm feeling a little stupid in this moment, because I know that I'm doing a little mistake🤣 but I can't find it!I need to print the actual hour, so if now it is 10:31 am, I need that the result is 10. I'm trying to use DATETIME_FORMAT and SET_TIMEZONE.. but it gives me error. do you know how can I solve this problem? 

I'm working with a long-text column in Airtable and need to insert line breaks into my text to help improve readability. Could anyone guide me on how to add a break (\n) in my text within a long-text field in Airtable? Any help or guidance would be much appreciated. Thank you!

List A: the, cat on, was not, sat onList B: cat on, sat onoutput: the, was notEDIT: List A & B are linked fields. Linked to the same original field.I want to implement this functionality. It is achievable using a SUBSTITUTE on list B to add the relevant REGEX characters []* etc.This substitute would be placed in a REGEX_REPLACE to remove all the words in list B.I know it’s doable - but I struggling with the regex. Can anyone help please?

I want to be able to extract capital letters from a string (name of a type of event) to create its ID CODE.This way I can keep my ID CODE as a formula, not manually, and still control how it comes out through the capitalizing of letters in the name.For example: NeuroGym = NG Business Meeting = BM Annual global Event = AE Monthly internal Event = ME Business Event = BE

Hello community,My script do not work if the field is blanc there is a line break. however, i need the linebreak when there is a record.How can I do ? Thanks in advance {MARQUES} & IF({DESIGNER}, " X " & {DESIGNER}) & IF({DATATION}, " - " & {DATATION}) & "\n" &IF({COLLECTION}, " " & {COLLECTION}) & "\n" &IF({FABRICATION}, " " & {FABRICATION}) & "\n" &IF({PRODUIT}, " " & {PRODUIT}) & IF({MODELE}, " - " & {MODELE}) & "\n" &IF({MATIERES}, " " & {MATIERES}) & "\n" &IF({COULEURS}, " " & {COULEURS}) & "\n" &IF({DETAIL}, " " & {DETAIL}) & IF({GRIFFES}, " , " & {GRIFFES}) & "\n" &IF({PROVENANCE}, " " & {PROVENANCE}) & "\n" &IF({TAILLES}, " " & {TAILLES}) & "\n" &IF({CONDITION REPORT}, " " & {CONDITION REPORT} & "\n" &IF({ICONOGRAPHIES}, " " & {ICONOGRAPHIES}))

Concept:  I have 3 columns  i  have a multi-select field of Job Types as followsAerial Display - Water / BargeAerial Display - LandClose ProximityI have a total invoice column in $ (approved spend)I have a formula column with the current formula "IF({Job Type}="Aerial Display - Water / Barge", ({ApprovedSpend}-2000)*.27, {ApprovedSpend}*.27)I have run into the issue that when the column 1 (job type) has more then just "aerial Display water/barge" selected it ignores the first, part of the formula. so I'd rather it be something along the lines of IFCONTAIN?  

As I've searched the Community, big shout out to folks who have shared formulas which convert dates to quarters and fiscal years. I'm currently using the formula below, and I'm trying to find a way to blank out cells which have no date. Any suggestions/help much appreciated!IF(AND(MONTH({Invoice Date}) >= 1, MONTH({Invoice Date}) <= 3),"Q1",IF(AND(MONTH({Invoice Date}) >= 4, MONTH({Invoice Date}) <= 6),"Q2",IF(AND(MONTH({Invoice Date}) >= 7, MONTH({Invoice Date}) <= 9),"Q3",IF(AND(MONTH({Invoice Date}) >= 10, MONTH({Invoice Date}) <= 12),"Q4"))))& " FY '" & RIGHT(YEAR({Invoice Date}) & "", 2)

Our Attachments field ("Images") contains sometimes five or six images. Is there a formula I can use to copy just, for example, the first or first & second images only?THANKS!

Hi everybody!I'm trying to modify the formula below so that the empty lines don't show up and don't make a line break with empty lines.For each of the 18 lines I have {FormatX EANX Concatenated} from an other field where {FormatX EANX Concatenated} can be empty or not.If the {FormatX EANX Concatenated} is empty, I don't want an empty line.  {Format1 EAN1 Concatenated} & "\n" & {Format2 EAN2 Concatenated} & "\n" & {Format3 EAN3 Concatenated} & "\n" & {Format4 EAN4 Concatenated} & "\n" & {Format5 EAN5 Concatenated} & "\n" & {Format6 EAN6 Concatenated} & "\n" & {Format7 EAN7 Concatenated} & "\n" & {Format8 EAN8 Concatenated} & "\n" & {Format9 EAN9 Concatenated} & "\n" & {Format10 EAN10 Concatenated} & "\n" & {Format11 EAN11 Concatenated} & "\n" & {Format12 EAN12 Concatenated} & "\n" & {Format13 EAN13 Concatenated} & "\n" & {Format14 EAN14 Concatenated} & "\n" &am

Hello!I'm using DATEADD inside an IF. It returns a time with the date, and I would like to remove the time. I tried formatting the field but it says that it can't do that because it's neither text or a number:The issue:My formula:The error message:Any help is greatly appreciated!George  

Hi, I have multiple Image attachments in airtable I want to show only 1st image in the pic#1 column is that possible i try few solution/formula it showing image URL ? any quick solution? 

I am using a formula field and selected decimal format, but it doesn't return with a thousand comma separator. Does anyone have a workaround?