Formulas

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?

I have a field with the number of days, and the total fee. I wanted to create a formula field where I could add this logic below. Is this possible to compute? One month or less (≤ 30 days)10% of the Fee2-3 Months (31-90 days)20% of the Fee4-6 Months (91-180 days)50% of the Fee7-8 Months (181-240 days)60% of Tof the Fee9-10 Months (241-300 days)75% of of the Fee

If I have one date in a single cell, then I would use the formula DATETIME_FORMAT({}, 'MMMM) to convert that date into a month.  However, sometimes when using a Look Up I'm pulling multiple dates, separated by commas, into one cell. I'd like to find a formula that will convert all of these multiple dates into the month equivalent. So solving the 'error below'.  Any help much appreciated. Thanks. 

I'm using formula: SET_TIMEZONE(NOW(),'America/Los_Angeles') I want it to show the current time in LA but it keeps returning the UTC time instead. Any idea what's wrong with the formula?

Hi everyone,I am having trouble with a SEARCH() formula that isn't acting as I would expect. I have this long text in the field "FORMULE" :"1: Pratiquer une activité2: Me consacrer3: Vivre des expériences4: Pratiquer un sport"I want to search for the position of this string : "Vivre des expériences"Here is my formula : LEFT(FORMULE,FIND("Vivre des expériences",FORMULE)) And here is my result : "1: Pratiquer une activité2: Me consacrer3: Vi"-> The end string finishes by "Vi" which is one caracter to long, it should finish by "V" only... It is an example but it changes when you look for the other words, other example, when I search for "Pratiquer un sport" it gives me this result :"1: Pratiquer une activité2: Me consacrer3: Vivre des expériences4: Pra"-> It is now 2 caracters too long, it shloud finish by "P" onlyDo you have any solution about this ? I am surely missing something...Thanks a lot for your help

I know using a formula like this-IF({T-Shirt Size} = "extra small",DATETIME_FORMAT(WORKDAY({Expected Final Files}, -2), 'MM/DD/YYYY'),IF({T-Shirt Size} = "small",DATETIME_FORMAT(WORKDAY({Expected Final Files}, -6), 'MM/DD/YYYY'),IF({T-Shirt Size} = "medium",DATETIME_FORMAT(WORKDAY({Expected Final Files}, -13), 'MM/DD/YYYY'),IF({T-Shirt Size} = "large",DATETIME_FORMAT(WORKDAY({Expected Final Files}, -22), 'MM/DD/YYYY'),IF({T-Shirt Size} = "extra large",DATETIME_FORMAT(WORKDAY({Expected Final Files}, -30), 'MM/DD/YYYY'),""))))) Gives me the date in the format I want but I would like to have it in bold and Airtable says "Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date." I know this is a result of using DATETIME_FORMAT. I updated the formula to:IF({T-Shirt Size} = "extra small",DATEADD({Expected Final Files}, -2, 'days'),IF({T-Shirt Size} = "small",DATEADD({Expected Final Files}, -6, 'days'),IF({T-Sh

Hi, I've looked up my situation to see what the problem is and I'm still getting an error message.  I want to multiply two fields to get a total.  Qty field and Cost field.  Here is my formula.  I get #ERROR Thank you for the help.  

Hi! Does anyone know how to restrict access to a shared interface? I gave a read-only user access to an "editable" interface I made for my creators so that she couldn't utilize it. For her to submit information, I made a read-only version with a form; however, I cannot unshare the editable interface at this time. I can't find a "remote access" option for her account. How come? If it helps, my account is Pro.

Hello, I would like to ask someone from the community for advice, or the correct formula, since within Airtable I solve such tables, or a linked table with several fields / windows, while it is a kind of recorder and at the same time an evaluation of records in the recorder of activities of members of a team.So I have one table called Schedule of activities where I have the first column which belongs to the Activity ID, the second column which belongs to the date and the third which belongs to the Type of Activity and then there are other columns with checkboxes, each one belonging to a specific member - e.g. Member A, Member B, Member C etc. (one column for one member).And then I want in the next table, or table field /table window called Summary of members' participation in Type of Activities, I wan to make a summary of the number of participation of specific members in specific types of activities. So I have in it the first column belonging to the ID of Summary, then there is a colu

Hello all, I am stumped. I am trying to combine data from two multiple select fields, into one. For the sake of confidentiality, I have created an example of what I am working with, using part of the Greek alphabet instead of the actual data: The goal is to combine these two columns into a third that looks and behaves exactly the same as the first two, simply with the data from both combined, into one. As easy as this feels like it should be, every single option I’ve seen either turns the output into text strings (which renders it useless for our tracking purposes), or else it requires a great deal of manually typing or copy-pasting the individual options of the multiple select, into the formula, one by one. It should be noted that while I have only used four Greek letters here, the actual number of entries we are working with is well over 600, and with far longer names, so such a process would be a grueling time-consumer. Surely there must be some way to automate this? Also note t

Hi I have a formulaDATEADD({Kick off},{Time Estimate (Fibonacci Minutes)},"minutes") Whereby {Kick off} is an date field set to ISO and 24 hour time{Time Estimate (Fibonacci Minutes)} is a drop down with a Fibonacci sequenceI want the DATEADD formula above to return the expected job completion date and time so that I can feed it straight into my calendar. Weirdly, it's an hour out.For eg a kick off date of  2023-05-10 00:01 with a fibonacci of 21 returns 2023-05-09 23:22, when it should be 2023-05-10 00:22.Any ideas? 

Hi all,I'm using Airtable to plan and track renovation and landscaping tasks. I have a table that has one field (text) for tasks and a 'prerequisites' field that is linked to the tasks field. This shows me other tasks that need to be done first. I am trying to create a formula that will show me whether the task at hand is a prerequisite task for any others.I tried  IF(FIND(Task, Prerequisite), "Yes", "No")  but that (kind of obviously) always return "No" because a task is never a prerequisite of itself.How can I get it to identify if the a task is a prerequisite for any other task?Alternatively, is it possible yet to automatically produce a field for the link in the opposite direction when records are linked within the same table?Thanks!

I am using a date and time field that shows in ET- i.e 9/22/2023 11:00am. It was showing up in a weird way in automations, so i followed a formula that i saw in a pervious post to format it -DATETIME_FORMAT({Launch Date & Time},'M/D/YYYY \\at h:mma') - but then for some reason it's showing is as "9/22/2023 at 4:00pm". I obviously want it to show as "9/22/2023 at 11:00am"- What am i doing wrong?

Hi everyone,I'm trying to create a formula field that pulls either one of two dates (depending on which one is the earliest) or gives "Pending Date" if both columns are empty. I've tried several different formulas and have gotten close, but I can't get the formula to fill in "pending date" still -- it always gives me #ERROR. Here are two formulas I have tried: IF(IS_BEFORE({Date 1}, {Date 2}), DATETIME_FORMAT({Date 1}, 'YYYY'),IF({Date 1}=BLANK(), DATETIME_FORMAT({Date 2}, "YYYY", "Pending Date")))and  IF({Date 1}, DATETIME_FORMAT({Date 1}, 'YYYY'),IF(NOT({Date 1}), DATETIME_FORMAT({Date 2}, 'YYYY'),IF(NOT(AND({Date 1}, {Date 2}, "Pending Date"))))) Can someone tell me where I'm going wrong? 

Hello Everyone!Can someone help me troubleshoot why using IF formula with arguments containing field values with decimal points return errors? All the fields are in currency format with precision of 1.00 except one with duration type field in seconds and in decimal format. Here's my formula and there's at least 4 different results to expect (FULLY-PAID, PARTIALLY-PAID, OVER-PAID, NO PAYMENT and N/A if all 4 logical arguments are false. Below is my formula.  IF({Total Amount Paid (ToDate)}=0,"NO PAYMENT",IF({Total Amount Paid (ToDate)}<{Total Amount Due (ToDate)},"PARTIALLY-PAID",IF({Total Amount Paid (ToDate)}={Total Amount Due (ToDate)},"FULLY PAID",IF({Total Amount Paid (ToDate)}>{Total Amount Due (ToDate)},"OVER-PAID","N/A"))))  There are only two fields used in the formula and i noticed that whenever the value of the {Total Amount Due (To

Hoping for some help! I have a column with a date in, and two other columns, one with a start date and one with an end date, I want to do a conditional / IF rollup that brings me through a value if the date in question falls between the start date and end date in my other columns grateful for any help!

I’m brand new to Airtable and getting to grips with it all so forgive me if this is a simple and stupid question. I’ve got a table logging expenses by two people. I’m using a currency field to add the amounts spent by each person. Now I want a second table that shows the overall funds both people start out with and then a field that shows the current funds available which updates according to the expenses logged in the expenses table. Can someone explain to me how to do that? I don’t even know what sort of keywords to look for in the help sections. Thank you so much for any help! Anna