Formulas

Why wouldIF(NOT( IS_AFTER( Date,'10/4/2023)function correctly andIF(IS_BEFORE(Date,'10/4/2023)not function the same in a formulais not after = is before 

Hi All! I am still new to Airtable and writing formulas and (hopefully) this is an easy question.I am trying to write a formula that will display text that matches the "checked" state of 3 different checkboxes, and also will display "New" if none of those checkboxes are checked.This is what I have written so far, and it is working to display the state of the first checkbox, but because that is true, it's not moving on to the next thing I want it to test for. Is there an additional logic I could add to the formula that would accomplish this? Or a totally different way of going about it?My current formula in the Status column: IF({Service Started}, "Service Started", IF({Ready for Pickup}, "Ready for Pickup", "New")) Screenshot for context: Thank you so much!Devon

Hi, I am trying to create a formula that accomplishes the following but am not quite sure how to set it up. Does anyone have any suggestions? IF({FPL %} > 125% but < 300% = "Eligible")Thanks!

Hello!  I'm relatively new to AirTable, we're migrating here from FileMaker Pro.  I'm forced to duplicate a calculated field in FileMaker, which is essentially the same a a Formula in AirTable.  Basically it does some complex looking at a zipcode value and either displays a Metro Region if it's a certain zipcode, or instead, just displays the City name.  I've been trying to do this:SWITCH(AND({l_zip} >= 94100, {l_zip} <= 94199), "North/San Francisco",AND({l_zip} >= 93600, {l_zip} <= 96199), "North/Other Cities",{l_zip} = 91604, "South/Los Angeles & Vicinity",{l_zip} = 91711, "South/Los Angeles & Vicinity",{l_zip} = 90755, "South/Los Angeles & Vicinity",AND({l_zip} >= 90000, {l_zip} <= 90199), "South/Los Angeles & Vicinity",AND({l_zip} >= 90200, {l_zip} <= 90599), "South/Los Angeles & Vicinity",AND({l_zip} >= 90800, {l_zip} <= 90899), "South/Los Angeles & Vicinity",AND({l_zip} >= 91100, {l_zip} <= 91199

Hi there! I am using IF formulas in two separate formula fields and they work just fine. I am trying to merge the formulas in one field and it is not working. The third and fourth IF keep disappearing. Can someone please help me?Here are my formulas :1st fieldIF(AND(Campagne = 'Grands Donateurs - Somme à amasser', {Progrès de la campagne} = 'Somme à amasser'), {Objectif restant},IF(AND(Campagne = 'Grands Donateurs', {Progrès de la campagne} = 'Somme amassée'),{GD - Montant promis})) 2nd fieldIF(Campagne = 'Sièges', {Sièges - Montant promis},IF(Campagne = 'Sièges - Somme à amasser', Objectifs-{Sièges - Montant promis})) What I thought it would look like :IF(AND(Campagne = 'Grands Donateurs - Somme à amasser', {Progrès de la campagne} = 'Somme à amasser'), {Objectif restant},IF(AND(Campagne = 'Grands Donateurs', {Progrès de la campagne} = 'Somme amassée'),{GD - Montant promis}), IF(Campagne = 'Sièges', {Sièges - Montant promis},IF(Campagne = 'Sièges - Somme

I have one table with item names in the first column, and I want to add a column that displays TRUE if the item name is present in the first column of another table of item names. In Excel I would do this with a VLOOKUP or MATCH wrapped in an IFERROR.

I have a table "Performance" with device performance data of my app. The table has the following columns: user-id, device-name, fps, time-stamp Now I want to extract the devices which have "fps" below a threshold (let's say below 10), because I want to blacklist those devices. I want to check in every week and see if there are any "new devices" with less than 10 fps and add them to the blacklist. say I have a second table "Blacklist", where I manually enter the devices I have so far blacklistednow a new record enters the "Performance" tableI want to check if the "device-name" of that new record already exists in the "Blacklist" table and if not, hightlight the field, or set a flag in another field, e.g. "IsBlacklisted"how to do that?

Morning! I'm trying to figure out a formula but struggling to get it to work and wondered if anyone could help please?Status column is a single select column with status numbers from 0-499 which i want to add information into a new column from a formula showing "1. called off and not yet delivered"Status 500 needs to say "8. Not listed in dropdown - detail in Comments" in the same formula column.This is as far as i have got, can anyone point me in the right direction please? Thank you!  IF(  OR(    {Status} <500, "1. called off and not yet delivered"){Status} = 500, "8. Not listed in dropdown - detail in Comments")

I have a table with a field "Project" by which is grouped.It is filtered by a specific project and by records in which thewhere the field "Project" is empty. Between some records, the emptyproject group and the records of the non-empty project group there isa relationship in another field.The goal is to have the records in the empty project group that have a relationshipto the non-empty project group appear together in one view. Is this representable in Airtable?

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?