Formulas

In Google Sheets, I do this in a cell:=1+1...and the answer is output in the cell.Can I do that in AirTable? To be clear, I want to have different formulas in each cell, not one formula for the whole column.

Hey guys, I don’t know if this is a strange request but I hope you can help me with it. I dived into Airtable for the past months. I really love it and I’m working almost on a daily base on my Airtable base. Now I have set up a quite complex base for my company but I’m lacking of a deeper understanding of formulas. I did a quite complete course and read through everything I could find on the Airtable web itself, but I still feel as lost with formulas as with math at school :grinning_face_with_sweat: I really want to understand how to build formulas and solve the problems and hurdles I have in my base. Therefore I’m looking for a teacher that goes through my Airtable with me and explains me with the given examples how to create different formulas. Of course I will pay for it. If somebody is interested, please let me know, Thanks in advance. Best, Mad

I have a Lookup field called 'Call Result' in my Contact table for my Touchpoints table's 'Call Result' column - which is a drop down. I have a view called 'Hit Lister' and I would like to filter records where I have encountered - for example - 8 voicemails in a row. Here is an example of the contents of one such 'Call Result' lookup row record:Call Me Back, Voicemail, Voicemail, Voicemail, Voicemail, Voicemail, Voicemail, Voicemail, Voicemail, Voicemail, VoicemailThe challenge I have is when I add the condition:Call Result does not containVoicemail, Voicemail, Voicemail, VoicemailThe record is not filtered as it should be.Please provide ideas or troubleshooting steps on how I can fix my problem. For reference I have supplied a link to a video below of my cahllenge which should clarify any lasting confusion:https://share.getcloudapp.com/z8ulmjwd

Hello- Any help with if CAMPAIGN THEME is blank, the “-” will not show in the formula? IF( {CAMPAIGN NAME}, CONCATENATE( IF( {CAMPAIGN BRAND}, {CAMPAIGN BRAND} & IF(OR({CAMPAIGN NAME}, {CAMPAIGN TYPE}, {CAMPAIGN THEME}, {EVENT NAME}), " - ", “”) ), IF( {CAMPAIGN NAME}, {CAMPAIGN NAME} & IF(OR({CAMPAIGN TYPE}, {CAMPAIGN THEME}, {EVENT NAME}), ": ", “”) ), IF( {CAMPAIGN TYPE}, {CAMPAIGN TYPE} & IF(OR({CAMPAIGN THEME}, {EVENT NAME}), " - ", “”) ), IF( {CAMPAIGN THEME}, {CAMPAIGN THEME}& IF(OR({CAMPAIGN TYPE}, {CAMPAIGN THEME}, {EVENT NAME}), " - ", “”) ), IF({EVENT NAME}, {EVENT NAME}) ), ‘EVENT’ & ’ - ’ & {EVENT NAME} ) A - B: HOLIDAY PROMOTION - HALLOWEEN - The theme is Halloween. Thanks!

I'm new to Airtable and as expected I need help with a formula, please! This is what I need: IF( {Days to Deliver} is equal to 0 then it   'Expires Today',IF({Days to Deliver}  is equal or bigger than 1 but less or equal than 7 then it is  'About to Expire',IF(  {Days to Deliver} greater than 8 then it is 'On Time'IF(  {Days to Deliver} is <0 then it is'Completed')))) Any

I would like to be able to have a different formula in each record, rather than one formula applied to every record.My table is a task list. The Due Date of each task (record) is relative to the Due Date (date field) of the Final Task. Task A is due 1 day before the Final Task is due, Task B is due 5 days before the Final Task is due, etc. Is there a way to input a formula into each record's field that would calculate from a field in another record within the same table? Like if I put "-1 day" into the field (I don't know what type of field could do this) of Task A, it would display October 30, 2023 if Final Task's Due Date was October 31, 2023.The best I've come up with so far is a short text field where I write "1 day before" "5 days before" etc and then plug in the dates in the date field once I've decided Final Task's Due Date. However, this means if I change Final Task's Due Date, I have to manually change all records' Due Dates.I can't find any

HiI'm looking to create a new field or to modify an existent one.As of 2022, this formula was okay but in 2023, the value for H sould now be 45.94 instead of 39.27 .Because we don't want it to have an impact on our reports and on our Page Designer, we need to add a condition that if the event took place in 2022, H = 39.27 and if the event took place after december 31th 2022, H= 45.94. Could someone help me? I've been trying different things but it seems that I always forget something. Thanks a lot ! 

Visually it displays the exact same as if I use a lookup field, but trying to sum it just returns 0 :confused:

I'm trying to compare data from 2 columns to result in a rating. I'm trying to break it down first before going crazy with multiple IF AND statements. Below is the first working example:IF(AND(A=100, B=100), 5, BLANK())Below are the conditionsIF A=100 AND B=100, rate 5IF A<100, A>=97 AND B<100, B>=97, rate 4IF A<97, A>=94 AND B<97, B>=94, rate 3I have tried the following and it's not workingIF(AND(A=100, B=100), 5, IF(OR(AND(A<=100, A>=97), AND(B<=100,B>=78))), 4, BLANK()))

Hi there, I have some recipes here that appear in one column like: Salmon (F) 280g / 560gLemon 0.5 / 1Potatoes 2 / 4Tomato 2 / 4Capers 20g / 40g Etc. I would like to have another column get the qty on the left of the / and another to get the qty on the right of the /so column 1 = 280g0.52220getc.  I am struggling to figure this one out x  

Hi,I have a big data base, it reaches over 10K records in one table, therefore I had to split the table into two. BUT now I want to combine these two tables into one in order to build the interface I wish based on just one table.I decided to lookup the records based on dates. I want the combined table to be built on the 365 days of the yearHow do i build that list? The date format in the two tables is: European 12/1/2023Thanks 

I have a "rate" field that comes in in different formats so airtable (and excel) treat it as long text.In excel I convert it to a number with this formula:  =IFERROR(VALUE(IF(ISNUMBER([@Rate]),[@Rate],LEFT([@Rate],FIND("$",[@Rate])+4))),"")Because the field can be:1) A normal number = keep as is2) Or something like this:  "$ 0.00Setup Fee $ 995.00" - where I am trying to strip out the spaces and "Set-Up Fee..." language.Need help with a formula to do this in Airtable if possible.  ISNUMBER doesn't exist because the field type is set as text, etc.  I'm wondering if I need to use scripting...but that would be a first for me.Thanks.

Hey Everyone,  Needing help with another if statement.  It is not behaving in the manner I am expecting. I have 3 fields Odo calculated (Formula Field), Odo miles (Number field) and Final Odometer (If statement).  I am trying to have the Final odometer field populate with the odometer calculated field if the odometer overwrite field is empty.  If the Odometer Overwrite field is not empty I want that number to populate in the Final Odometer field.I currently have IF({ODO Miles} = " ",{ODO Miles}, {Odo Calculated})

Hi,I'm trying to write a formula that creates links for all the records of a particular table. CONCATENATE("https://airtable.com/apppHrkLvUlS6WHMn/tbluWhdAjZM8xU9DD/viwCnMkKvccWgTatL", RECORD_ID()) This is creating a broken link. Am I missing something? Thanks!  

hi! trying to get a nested if formula to work based on market and the only country that is pulling is the first (US) but not FS. if i switch "US" to "FS" for example, it will pull into the FS market and US. it seems to be an issue with the conditional statement finding a match and then stopping. any idea how would i fix this? IF(Market="US",IF(Channel="Natural Search",0.59,IF(AND(Channel="SEM Brand text",Quarter="Q1"),0.1,IF(AND(Channel="SEM Brand text",Quarte

Hai, I need track sales team for visit customer, for this I created form on AirTable Which problem when Sales team go to customer and submit report visit, there is no Geo Tagging ( Longitude and Latitude). I need to know information when Sales person is on customer location Can this possible ? if Yes, how to do? Thank you

Hello everyone Please I need help with a formula I have a field of start date, a duration field and an end date field. I need an airtable formula that once I put a start date and the duration of the project (2days) the end date automatically populates. That is I have a project starting 2/1/2023 and my duration is 3 I.e 3days..I want the end date to automatically populate as 5/1/2023

Hello, I need to create an aging formula with an If statement to track when a record is open with a count of days until it gets closed and ultimately stops counting.  I then want to be left with the difference of days between the date opened and the date completed,  in the days-old column.   Currently, the Days old column counts days open from the date the record was created.  DATETIME_DIFF(TODAY(), DATETIME_PARSE({Opened date}, 'MM-DD-YY'), 'days') and just keeps counting.  Any help is appreciated!   

Hi everybodyI am having trouble with an IF formula.As background – I have a table that includes three multiselect fields. I am trying to count the number of instances of a particular keyword (could be a single word, or multiple) in each field. Below is the formula I am trying to use:  IF({KW Taxonomy L1}=Natural Sciences,"Yes","No")Which isn’t working.The fields are not linked to another table. Should they be? Am I barking up the wrong tree and should be using another formula entirely?Many thanks

Hi everyone,I'm having trouble with this formula. Can you tell me what I'm missing?It comes up blank.Thank you!SWITCH({Recurring Frequency},"daily", DATEADD({Date to work on it}, 1,'days'),"weekly", DATEADD({Date to work on it}, 1,'weeks'),"monthly", DATEADD({Date to work on it}, 1,'months'),"quarterly",

Hey guys,New to AT, and needed some guidance on what I'm trying to accomplish, and if AT can do this via the forms. I'm designing a form and was curious if I was able to select an entry (via drop down), and then it'll auto populate another field with whatever said user selected in the first field (drop down).I tried this with conditional statements, but maybe I'm lost.Ex #1: John Doe selects "Timecard" as an entry in the drop down field > The next field is populated with whatever is associated with "Timecard".Ex #2: Jane Doe selects "Building 1" as an entry in the drop down field > The next field is populated with whatever is associated with "Building 1".I wanted to make this form pretty simple for whoever's entering information. I can prefill those entries out in AT and possibly have it hidden - upon selection. So if John selects "Timecard" the next field will bring up

This seems like something I should have been able to figure out, but I've been struggling to come up with a solution. Duration fields are handy for inputting data, displaying data, and manipulating it in Airtable. But the underlying data is the number of seconds in a text string. For example, one hour, seven minutes, and seven seconds will show as 1:07:07 but the underlying data is "4027". When I use the output via automation, the field output is 4027. I want to use 1:07:07. Does anyone know a formula or automation that I can set up to convert seconds into a HH:mm:ss text output?

Hello everyonePlease I need help with a formulaI have a field of start date, a duration field and an end date field.I need an airtable formula that once I put a start date and the duration of the project (2days) the end date automatically populates.That is I have a project starting 2/1/2023 and my duration is 3 I.e 3days..I want the end date to automatically populate as 5/1/2023

In my CRM, I am trying to compare two date values in a formula, in order to figure out which "Next step" value is the most recent. In my Interactions table, {Last contact lookup} looks up a value in my Clients table which is the output of a rollup that outputs the MAX date value from interactions for a given Client record. {Actual interaction date} is the result of a formula that compares the Interaction record's creation timestamp to an optional user-entered value, and outputs the user-entered value if it's non-zero.My formula is simple: IF({Last contact lookup}={Actual interaction date},{Next step}). Unfortunately, that formula fails to produce results. The fourth row should have "Find information" in the Last next step column. Any ideas why this doesn't work?Just looking at the screenshot above, it looks like a problem with formatting, given how the timezone ap

Hi Airtable Community,I am creating a form to be filled out by a team of developers. I would like to share a form that team can fill out with their full name - select a sprint (2 week date range) - leave feedback on working hours day to day (which days they are free to work) - prefered time to work (daytime, midday, latenight).I am having trouble creating the sprint 2 week date range as a question in the form and the feedback for working hours. Would like to create something similar to this link: linkWould love and appreciate any help here.Thank you team!