Formulas

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

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

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" &

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, ot

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}

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,