Formulas

I think this formula IF({Last Deployment} = 'MM/DD/YY', 'MM/DD/YY', "*") says: IF (the value of the field Last Deployment is a date, show the date, otherwise pop in an asterisk (instead of #ERROR!)) But what I’m getting now is either an  * or #ERROR! - pretty much the opposite of what I am trying to accomplish. 

I have a base to manage my vendor payments, and a table that warehouses the vendors’ contracts and payment terms. In that contract table, I’d like to make a formula field that returns the next date when I should expect an invoice, depending on the payment terms (in this table, that is a single-select field titled “Invoice Schedule”). One of the “Invoice Schedule” options is “monthly,” meaning the formula field I am trying to make should just return the last day of the month (preferably month-over-month, as several contracts are long term). Here’s how I’ve set up that part of the formula - AT accepts the formula, but returns only blank values. I think that I’m misusing or misunderstanding SWITCH() - wondering if anybody can advise on what I’m doing incorrectly here? Also definitely feels like I’ve overcomplicated this solution but was the best I could figure out, so super open to more elegant solves if you’ve got them! IF( {Inv

Hi, I’m trying to roundup the following formula: ({GROUP PRICE}+({EXTRAS}*3))/3Where GROUP PRICE is the pricing for a group to which I add extras * by number of guests and then divide by 3 to obtain a price per person. The formula is working and in this case I obtain a pricing of 101.667€. I’m trying to roundup this number to 102€.Thanks

Hello, I have an airtable app that supports our HR and Finance teams.  As part of the build, I am looking to reference the employee ‘start date’ and ‘end date’ to determine how many days, or workdays that employee worked in a specified month (assume each month starts on the 1st and ends on the last day 30/31) Example fields:Start date: 01-10-25End date: 01-25-25Month Start: 01-01-25Month End: 01-31-25 The month start and ends fields could be done without referencing the fields if needed and handled within the calc using datetime parse/datetimeformat or the like. In many examples the end date of the employee will be after the month end but have kept the duration short for this example.In theory, a simple formula like the below should work, but I’ve tried so many different options of doing this and the formulas keep returning a 0 or error. The fields above are all calculated as date fields.WORKDAY_DIFF(

I’m trying to use the SUBSTITUTE function to get rid of emojis so I can have a “clean” version of some fields my client want to have as downloadable in .CSV I need to have a formula with a bunch of substiutions, but I started from the very first and I get nothing but errors, formula atm looks like this:SUBSTITUTE({Respuesta Pregunta 1},'✅','')I realised the error has something to do with the type of field of {Respuesta Pregunta 1} as it is a lookup field, just for testing I created a single text field next to it, copy the data of the lookups to the new text field, applied the formula to the text field, and it works. So I’m suspecting SUBSTITUTE doesn’t work with lookups? Any ideas to work this out?

Hello All,In one of the columns in my Airtable, I would like add my Amazon affiliate link to the Amazon Product URLs so when the product is integrated to my website, selection of this product will have my Amazon tag in the URL. I am having trouble with a formula to create the new URL. Any suggestions? Thank you!

I’m attempting to set up air table to distribute parents possessions between 10 siblings Scenario:  If there are 100 items and 10 lots of 10 items each.  Each sibling wishes to receive a certain decoy, a certain lamp, and a certain painting. Sibling one rates, only three items, the decoy, the lamp and the painting. Sibling 2 enters a rating for virtually every item on the lists Sibling three enters a rating for 30 different items on various lists that she desires, leaving the rest blank.  Under this scenario, my understanding of the program is that sibling one is almost certain to receive at least one of the three items she covets.  Sibling 2 is highly unlikely to receive any of the three items. Sibling 3 has a middling chance of receiving one of those three items. Am I correct?   

Sometimes we have URLs that include "?" for example www.mytravelsite.com/deals?destination=florida. Its best practise when adding UTMs that if a url already includes a "?" then the UTM should start with "&" instead. The below is the expected outcome of this.www.mytravelsite.com/deals?destination=florida&utm_source=Offsite_P195&utm_medium=Patnerships_Video&utm_campaign=VisitFlorida_Sep-Oct2023_YouTubeThis is the formula i have attempted to use.IF(FIND

Hi guys, I’m trying to find a way to insert a formula that calculates the expiration date of leases based on the commencement date and the number of months that the contract is for. So far, I have this: DATEADD({Commencement}, {Term (mos)}, ‘months’) This calculates the expiration date almost perfectly, but I need to find a way to take one day off of the formula. A 12 month lease starting on 03/01/21 would return 03/01/22, but the expiration would actually be the last day of February, not the first day of March, if that makes sense. How can I get the formula to subtract one day from the result? Thank you!

Hi,   I’m used to work with spreadsheets where you can refer to a cell in a previous row.And I know spreadsheets (data in rows) and database (data in records) can’t be compared.But I would like to build a project where I can see the evolution of a certain value.Here you have a simple table where the first column (datum = Dutch for date) is chronologically ordered and each value is unique.In the third column, I entered the difference between the current status and the status of the “previous month”  manually to show what I want.  Is there any possibility to get this done in Airtable?  With formulas in another extra table?

I need a column to calculate the total days- formula being ENDDATE minus STARTDATE plus 1.  Any suggestions?  I can get the datetime_diff, but that is days between not total days.Thank you!! 

[URGENT HELP] Error 422 in Make.com + Airtable – “Invalid Formula” in Search Records even with correct fields📌 The problemI'm constantly getting this error: pgsqlCopiarEditarRuntimeError [422] The formula for filtering records is invalid: Invalid formula. Please check your formula text. Even though all the Airtable field names are correct, Make.com keeps rejecting the formula.🧩 Airtable Table Details: Table Name: Table 1 Fields: Nome do Cliente (Single line text) Produto Qtd Valor do produto Valor Total Data da Entrega ✅ Confirmed: Date with time format ❌ Formulas tested (all returned

HelpI have a formula adding 17 days from a date in another column. It is adding the time. How do I eliminate the time?ALSO, is there possible logic to add to move the date forward if it falls on a weekend?Thank you for any help provided! 

J’aimerais créer un champ dans une table qui permettrait de calculer le nombre de rdv réalisés pour chaque personne à partir des rdv portés sur un calendrier

I have a multiple select field called “Weaknesses” in which a client can select different areas they’re struggling in with the language they’re learning. I’d love a formula that takes their responses and transform it to 1 word weaknesses and puts them together in a grammatically correct sentence. So... If they say “I can't stick to goals”, then I want the return to be “Goals” in the formula field. If they say "I can't stick to goals" and "I'm not great at speaking" it should return "Goals and Speaking." If they say "I can't stick to goals", "My habits and routines could be better", and "I'm not great at speaking" it should return "Goals, Habits and Speaking."What I can get it to return is a response of “Goals, Habits, Speaking,”I’m starting to think that’s not possible, and just want to see if maybe I’m wrong. Here’s what I have for a formula currently. REGEX_REPLACE( REGEX_REPLACE(

Hi guys!I'm trying to convert a string into a slug, and I need to replace polish diacritics with standard Latin characters. Should I use the regex_replace() formula? If yes, which expression should I pick in this case?

Hi All,I’m relatively new to Airtable and I’m struggling to figure out how to structure the formula to do what I want. I know roughly how to do it in Excel, but really struggling to translate how it’d work in Excel to Airtable. There are multiple things I need the one formula to do, any help on how to structure one or more parts of the formula would be appreciated.Formula is in my “Modules” tab, but looking up data in my “Tasks” tab “Module name” field in both tabs is linked with a “Link records” type of field in the Tasks tab Each Module has multiple tasks (they’re sequential, with no more than 1 “In Progress” at a time) and I’m wanting the Modules tab to have a field that displays what Task is currently “In Progress” I also want it to state “Not started” if all the Tasks associated with that Module are “Not Started” or “Complete” if they’re all set to “Complete”The structures I’ve tried that are similar to Excel keep sayin

I have a date, some weeks, and some holidays. I need to add the weeks to my date and exclude all holidays and weekends. I’ve used the WORKDAY function. However, I’m a little uncertain how to treat my weeks. Should I multiply them by 5 (since there are 5 working days in a week) or by 7 (since there are 7 days in a week, and the function will filter out all the weekends)?    

Hi, I have a Table "Main" that is Linked to table "Agenda".Being in Main, on a record, lets say “33” I want a button to view agenda filtered by ID (Both table have the ID field, in this case “33”).Any idea to turn aroud this?Im new to Airtable. Thank you-----------------------------------------------Example:Table Main:-------------------ID Name 33 Marta34 Martin35 JohnTable Agenda:-------------------------ID  Done33 Mailed45 Called46 Mailed33 Zoom87 VisitedResult Expected------------------------------33 Mailed33 Zoom  

I want to sort 9 fields of numbers on a single row and order them into 9 new fields on the same row that show the numbers from lowest to highest. If the old fields are labeled #1-#9 and the new fields are labeled A,B,C,D,E,F,G,H,I, then I want to search #1-9, find the lowest, and put it in A, then search #1-9 for the next lowest and put it in B and so on.I’m not sure if I need to write an automation with code, a script, or what, but the base features of Airtable do not seem to be able to handle this.

I have two multiple select fields that I am joining into one field. The items are showing in reverse order. is there a way to show them in the order in which they are entered in the multiple select field?

Hi everyone,I'm encountering a data integrity issue when transferring a large set of records from Google Sheets into Airtable, and I’d really appreciate any advice. **Scenario:**  I maintain an a list in Google Sheets. The "Source URL" column contains rich-text hyperlinks — for example, display text like `Narrative Enneagram Resources` linking to `https://www.narrativeenneagram.org/resources/`.**Issue:**  When I click the link, it shows an error because the URL has become http://narrative%20enneagram%20resources/ instead of the correct URL When I try to bring this data into Airtable, the URLs get misconverted. No matter the method I use:- **Copy-pasting** a multi-row range directly into a URL field,  - **Importing** via _Add base ▸ Import da

I am using Documint to generate PDF from data stored in Airtable (via link). It was working without problems for more that a year but I recently have trobles to build PDF on first try. Still some data are missing. I checked with documint and all is fine on their site. While the situation is getting worse, I am adding one more field to generated document to dump all data received from Airtable - so I see, that lot of data is missing so Documint has not enough inputs to generate PDF. It usually take several tries to get what I need, but tonight even 50 is not enought. I asked Airtable support on 15Jun but no reply  - still (OK 3 emails that they are busy, but no solution). Is there any way to make Airtable properly prepare all data and send it to Documint? What is the problem after one year?

In order to compute a change in a value between a prior record and a newly inserted record, is there a way to get the most recent prior value for a field in a table?Assume table is sorted (e.g., by DateTime).Ideally with a formula something like the pseudocode below where the “Prior_Value” and “Current_Value” are a number, such as: an amount, a quantity, a weight, a height, a length, et cetera.Delta_Value = [Prior_Value_from_Prior_Record - Current_Value_from_Current_Record]Thank you for any and all suggestions!Rick

HI guys, I’m trying to use the Concatenate function to help with my primary field names, but the date I’m pulling in from a ‘date’ field is a little messy. Here’s my formula... CONCATENATE(Client," ",'|'," ",{Month Date}," ",'|'," ",{Record Type}) And this is what comes back…Crystal Maze | 2025-09-01T00:00:00.000Z | Income - Forecast Is there a way of amending the date format within the concatenation formula?  Ideally it would look something like this…Crystal Maze | Jul-25 | Income - Forecast Many thanks in advance!