Formulas

Hi,To explain a bit : We have workshops that happen on different dates and people can register to those in a form.So I created a formula with the name of the workshop + the date of the workshop. I want that, in the form, people can only chose on date at the time. Now they can register for multiple dates and it creates complicate data for confirmation emails and reminders.So I was thinking that if the formula (Name + date) was a single select, they could only register at one but if there is another way, I take any advices 🙂Can anyone help me? 

I am using a mid formula to extract a string of text. The string appears as expected in the cell, but when Make (Integromat) runs the search it is adding an extra space before the string. " <string>" If the empty space is present, wouldn't I see it in the cell?I have checked over an over again to verify there is no extra space in the formula in Make. I have also changed my formula to +2, +2.Variations of this MID formula works with other use cases, this is the only one inserting an extra space. Is there a better way to do this? MID( {Summary}, FIND( ':', {Summary} )+1, FIND( ',', {Summary}, FIND( ':', {Summary} ) )-(FIND( ':', {Summary} )+1) )  

Requesting some guidance here. I'm new to Airtable and have read some documentation but have not fund any examples similar to my use case. I have a single select data field that I need to convert each selection items to a numeric value that can then be leveraged in a calculated field that will score an item in the table.How can this be done in Airtable?

Trouble with date formula: September 14, 2023 + Coaching=Coaching 2023-09-16T04:00:00.000Z. CONCATENATE({Mtg Type} & ' ' & {date test})The date always comes out wrong in the Concatenation.

Hello, I would like to create an invitation form for a party with 150 people maximum. The first 150 registrants receive an automatic email to confirm their participation and the others an email explaining to them that they are on the waiting list.Each guest can come accompanied by a +1, how do I know when the 150 guests are on the list to create the email automation?Thank you so muchAlex

I have 5 fields (WBS1, WBS2, WBS3, WBS4, WBS5) which are all different levels of WBS and I have a formula that combines it all into 1 number: WBS1& IF(WBS2="","","."&WBS2 & IF(WBS3="","", "."&WBS3 &IF(WBS4="","","."&WBS4 &IF(WBS5="","","."&WBS5)))) The output of this formula is a number, like for example: 3.1.2 but it says the result type is not a number so I can't sort by it like I want to. I tried changing the "" to BLANK() like I saw on other posts but that isn't working. 

Hello, all.I'm new to Airtable and I need to create a form that tracks how many hours my coaching team is meeting with individuals each month. Each entry would be a new meeting, and I meet with individuals only once each month. Ideally, it would all exist on a single table. Each row would need to have the following information: Individual's name, date, duration, coach, Notes. Ideally, I would have another column that sums the month's hours as I go, call it "Hours this month".I assume there should be a formula that can do that for me, but I haven't for the life of me been able to utilize my Excel knowledge to create a working formula for AT.Any recommendations or alternatives to how I can approach this?

Hi folks,I'm have a dataset of events in Airtable with each event as a row, and each row has a different number of sessions that can make up the complete event. This means I have 8 end date & time columns to capture the finish time of each session. I need a column that will dynamically show the end date & time of the whole event, regardless of the number of sessions so that I can use this in various calendar/timeline views in Airtable.I've attempted to pull them all into an IF statement, like this:IF({Session 8 end time},DATETIME_FORMAT({Session 8 end time},'DD/MM/YY h:mm A'),IF({Session 7 end time},DATETIME_FORMAT({Session 7 end time},'DD/MM/YY h:mm A'),IF({Session 6 end time},DATETIME_FORMAT({Session 6 end time},'DD/MM/YY h:mm A'),IF({Session 5 end time},DATETIME_FORMAT({Session 5 end time},'DD/MM/YY h:mm A'),IF({

Hi, I am creating a CO2 emission calculator on airtable and i can't seem to get my formula right.The formula in question is:({Émission véhicule en Kg single} + {Émission véhicule en Kg total} + {Émission repas en Kg}) / 1000 The formula either calculate using one destination ({Émission véhicule en Kg single}) or from multiple destinations ({Émission véhicule en Kg total}) In every case either {Émission véhicule en Kg single} or {Émission véhicule en Kg total} will be empty which result in the formula being:(NaN + {Émission véhicule en Kg total} + {Émission repas en Kg}) / 1000or({Émission véhicule en Kg single} + NaN + {Émission repas en Kg}) / 1000 The formula for {Émission véhicule en Kg&n

Hello everyone.  I am trying to create a formula with the following logic: I have two fields (A and B) and these fields can contain different kind of values. Let's say that field A contains value A and field B contains value B, then I want the formula field to return a specific price. The same goes for an example where field A contains value C and field B still contains value B (then it's a different price). How would a formula like that look like?

Hi there,I want to have a column which displays two bits of data. Those are a cumulative $ amount and below that a cumulative % amount. I have these two lookup fields separately however need to combine them into one field column. Any help would be greatly appreciated,Bart

I'm trying to improve the content calendar we are using. I have a Content Field, which is the full post that we're going to copy and paste into Facebook. I'd like to have a column that will pull just the first line of the post using a formula. Any ideas on how to do this? For example, here is a post that would be in the content field:🌟 Fun-filled Learning at Ditebogo Daycare in Video Informal Settlement! These awesome educators are all about hands-on learning experiences for their kiddos. Recently, they organized a super-fun day filled with science experiments, face painting, and, wait for it... ice cream! 🍦🎨🔬Speaking of science, do you remember playing with Oobleck as a child? It's that magical goo that can be both a liquid and a solid depending on how you touch it. Now, here's the best part - Ditebogo Daycare isn't all about keeping the kids clean and tidy all the time. Nope, they believe in letting kids be kids and learn through experience! &#128

I work where following up with my clients are essential. Right now I have 3 columns in the table that. I'm trying to link together using IF Formula and it's not working so looking for some help here. First column is "Last Contact Date" which is in "Date" format and next one is "Schedule follow up" which is in "multiple selection" format with 1 day, 3 days, 1 week, 2 weeks, 1 month, 2 months, 3 months 6 months, 1 year. Last column is "Next contact day" where I'm trying to use IF formula to calculate the new date for me and they give me the new date for me. So below is what I have and right now, it's keep saying N/A.Not sure where I went wrong or how to fix it. Please advise how I could fix this. Thank you so much in advance. IF({Schedule follow up}="1 Day",{Last contact date}+1,IF({Schedule follow up}="3 Days",{Lat contact date}+3,IF({Schedule follow up}="1 Week",{Lat contact date}+7,IF({Schedule follow up}="2 Weeks",{Lat contact date}+14,IF({Schedule follow up}="1 M

Hello community, I would like to add a record ID to the end of a URL using a formula field. It would look like this:https://www.movementplus.app/course-overview?recordId=Record-Id-Goes-HereCan anyone please help me achieve this?Thanks in advance!

Hi 🙂I have a formula field "TASK" that checks if there is value in fields or not.  It looks like this;IF({Fuel L}=BLANK(),CONCATENATE("• Add fuel tank", '\n')) Now, I want to have another multiple-select "CLEAR" field that clears the TASK value if the corresponding value is included in multiple select fields. For example {Fuel L} is blank, but in the CLEAR field "Fuel L" is selected. This setting should not show   "• Add fuel tank" in TASK field. I tried with FIND(), but I should use something as not FIND()... I would appreciate help to accomplish this. Thank you,Pjero

I have a base for timesheets. I have a column which is set to decimal for hours total called qty eg. 9.50 or 10.00. Then I have a formula that will accept the total hours or put something different depending on leave status abbreviation but it won’t write down the answer as a decimal or let me format it. So my formula is -if({status}=“on”,qty,if(and({status}=“lwop”),“0.00”,if(and({status}=“rdo”),”8.00”)))And for any of those combinations it comes out like eg 9 or 9.5 for “qty”, 0 for lwop and 8 for rdo Can you help me format into same format as my other column and formula examples. 

 I have a series of records that include a Start Date field that I want to incorporate into a larger CONCATENATE formula.  However, some of the records do not yet have a date and the Start Date field is blank so my formula is returning an #ERROR.  I have tried adding an IF=BLANK statement to the formula (see example below) but that doesn't seem to be working either. IF({Start Date}=BLANK(),(DATETIME_FORMAT({Start Date},'ddd, MMM, DD') any suggestions on what to try next?

I need a formula to check if there is exact matching for multiple select field when values can have comma. Here is a sample multiple select I can have:abca,bI need to check if users selection is exactly 'c' and 'a,b'. All solutions I found (like using FIND) are not working with comma.

Hi All,I'm having an issue figuring out how to best format a formula for my situation. This is probably very simple but I need a hand. Here are my fields:"Total" - Currency field with numeric value"Total Copy" - Formula Field "Is Income?" - Single Select fieldBasically, I need Total Copy to take & convert Total's value to a negative or positive number based on Is Income.I have this so far to grab from Total and make it a negative: IF({Is Income?} = BLANK(), {Total} *-1, "") But now I need it to also recognize if Is Income is not empty so it can copy from Total and deliver a positive value instead of staying blank in that case. Any help is appreciated 😊

I know if I use a switch, I can write a formula to return a single value from different fields based on a given input from a single-select field. Like if the select field has options A, B, C, it’d be SWITCH({select field}, A, {Field A}, B, {Field B}, C, {Field C}).What I want to do, though, is have multiple inputs that return multiple outputs combined into a single text string. Is there a way to do that?I’m trying to show who needs to review a project on different rounds of review. Round 1 might need Role A and Role B, Round 2 might need Role C and Role D, and so on - I have that info logged in a definitions table. I also have assignment info for each project, like “On Project X, Role A is Alice, Role B is Ben, while on Project Y, Role A is Albert and Role B is Betty”. So then in the table where I list out the rounds of review that happen for my projects, I want to combine that info and have a “reviewer” field that returns the reviewer names, so like Project X’s Round 1 reviewer field

What is the formula to get the Time in hours and mins from a Date/time field?? My date/time field is called “Start”.

How can I do a word count of a record? I have a table to organize what I write divided by scenes and I want to count the words in every scene. Thanks in advance.

Heyo!I'm stratching my head as to how exactly format a formula down to first .00 numbers for an email automation.Inspite what I've attempted it continues to display all 13 numbers for "M1" calcuation. Screenshots attached.

Hi,I am using airtable base for my job. I visited persons and I have to repeat this visit every 2 to 4 weeks. When I finished my visit to customer,  I wrote in aitable base report and then airtable base recorded the day and time in the last modified field. Now I have my costumers who are not same level and I have a colon with numbers 14, 21 or 30 these numbers are a number of date which I heve to visit customers again. How I can do this in airtbale.example I was in visit of my costumer 1 septembar 2023, he is my important customer and I want to see him again after 14 days. I need formula in the fild where the Airtable will give me notification that I should see him 15 septembar 2023, Exemple 2 I was in visit of my costumer 1 septembar 2023, he is my not important customer and I want to see him again after 30 days. I need formula in the fild where the Airtable will give to me notification that I should see him 1 octobre 2023, Kind regards,Vladimir Tomić

I am importing customer support tickets from another database (Hubspot) in an attempt to calculate the following:1) What is the duration between each ticket date (single field) for the same product serial number? The goal is to understand the average duration (in days) between customer tickets for each product (serial number) sold. For example, if one product (serial number) has three ticket records (imported from Hubspot) - If the first ticket record has a date of 1/1/23, the second has a date of 1/4/23 and the third has a date of 1/8/23, it would return the dates of 3 days and 4 days between each sequential record. How do I get Airtable to calculate the date difference from the same field?