Formulas

If i have 2 tables one has rent of different location and in other if some one booked from to some location when from and to matches in both tables, in booking table give rent amount from rent table. Is it possible or any way to do this action and get result.

Hello everyone, for an automation with Zapier I would like to count in a formula field in Airtable how often the respective mail address already appears in this grid view. For example, if xxx@gmail.com is already two times in this view, then it should display 2 next to the mail address in the formula field. The email field is the primary field. Unfortunately I didn’t find a solution here in the community, I hope you can help me! Thanks a lot!

My linked table has 17,000 records. I want to look up the record I need but I only can look up one of these options: Keyword A Phrase (“keyword A keyword B keyword C”) What I want is I want to be able to look up “Keyword A Keyword Z” where keywords are not part of a phrase. In the picture below - I want to be able to find the entry for Baby Carriages & Buggies by searching keywords Home Buggies. Right now I have to either search Buggies or search Hearth or search the expression “Home & Hearth” or search expression “Baby Carriages & Buggies”. Are there some operators or wildcards I can use?

if ( {revenus ou dépense}=‘revenu’, LEFT({catégorie}, 5), {revenus ou dépense} ) i want my key field to display different things according to what is written in another field thanks girls and guys in advance

Creating a table that will be split into different views for different online marketplaces, as they each require different fields. The Status field at Abebooks corresponds to the Update Delete field at Amazon, though, so I’m making the Update Delete a formula field that converts the language like this: ‘’'SWITCH( {STATUS}, “For Sale”, " ", “On Hold”, “Delete”, “Sold”, “Delete” ) My question is how can I add a statement that will look at the last modified time field I’ve named Updated and return the value “Update” only if that Updated field has today’s date? So that I can get only the updated today records into their own view to be downloaded as a CSV files I can use for the online marketplaces? I feel like this is a thorny one, but this community has surprised me on multiple occasions so maybe I’m just too much of a newb to recognize real Airtable thorniness.

Hi, I have managed to fetch latest modified date to AirTable, to see when a task was completed - now i want to add a field displaying WHO finished the task - is that possible?

Hi All, I’d like to create a unique number for a record based on the year and week. So for example, I have a date field which I use as YEAR(Date)&" - "&WEEKNUM(Date). So if the date was today this would give me an output of 2020 - 43. Now, I want to add a counting number for each record with a date in that week in order of when the record was created. So the first record created with a date in that week would be “2020 - 43 - 1” and the second record created would be “2020 - 43 - 2” and so on and so forth. But when the week changes to the next week I want the counting number to start again, so it would then go “2020 - 44 - 1”, “2020 - 44 - 2” and so on. I just don’t know how to do this and would appreciate any help thanks.

Thanks for being here! I’m trying to calculate weekly sales as a percentage of monthly sales goals. I’ve made a conditional formula to populate sales goals according to month, and my formula is accepted but only returns errors. I’m also wondering if I can bypass the separate sales goals field and embed the formula into a calculation, i.e., can I say that IF {Month} is MM/YYY, {Current Month Sales}/‘XXXXXX’ If not, I’d like to just be able to calculate simple division, but that doesn’t seem to be working either. Heather

Hi, I need some help, I am counting the total hours worked of my employees, But I need a formula that won’t count the lunch time or that some how if table (lunch in) or (lunch out) is empty it won’t say NaN. some people take lunches, some don’t this is what I have it like this. I have it to count hours worked before lunch and after lunch and add that all up. Screen Shot 2020-10-19 at 1.25.01 PM|700x99

Hey there, I need to show the most current step in progress in my “Is Current Step?” formula as “1”. I’m running into an issue with my current formula because some of the Upcoming Due Date Lookup dates are the same. (Example below for the Content Quality Objective, where it looks like there are two current steps). Ideally the formula would say “Is Current Step?” = 1 when Actual Completion Date (per Objective) is empty. It’ll then look at the next upcoming date based on the Revised Completion Date. If those dates are the same, it’ll look at the Step # and it should be the next one, chronologically. FYI I need it to be “1” because my Objectives tab will show the current step based on the condition (below). Thank you in advance!

does anyone know a way to convert hexadecimal values to actual color names (or the nearest neighbour). Examples: #ffffff = white #eeeeee = light grey #45c1f6 = light blue

Hi, I am looking for help as i am struggling to work out why a nested formula will built isn’t working for one login but not the other within our tea, despite it being the same and all the tags, fields etc being mirrored. We are trying to categorise our database into - Gold, Silver, Bronze and have used the formula below which works for my analyst, but not for me. Can anyone help me understand why it isn’t working on mine IF(Category = “Gold”, IF(DATETIME_DIFF(TODAY(),{Last Catchup},‘days’)>60,“Overdue”), IF(Category = “Silver”, IF(DATETIME_DIFF(TODAY(),{Last Catchup},‘days’)>90,“Overdue”), IF(Category = “Platinum”, IF(DATETIME_DIFF(TODAY(),{Last Catchup},‘days’)>30,“Overdue”)))) Note: We copied and past the forumla across, so not sure if that has had an impact

I would like a formula for this: When the status of a record is Project Complete for 3 workdays, change the status to Archive.

Bonjour, je cherche à indiquer un rang (de 1 à 10) dans un champs selon une notation d’un autre champs. Un peu type formule rang sur excel. Merci d’avance.

Very new to this so apologise if its a simple question. I have a field that is “cost”, a field that is “cost over-ride” and then a feild that is “actual cost”. What i want to do is to use the cost over-ride field but if blank use “cost”. Any tips will be much appreciated.

Can you pls tell me how to write a formular when I have a retail price in a colum and I need to have a colum that is 40% of the retail price.

Hi guys, I’m struggling to get this formula validated, which is odd as it’s been validated by an Excel master…? IF( {User status}=“New sign-up no story”, “Send new sign-up email”, IF( {User status}="New sign-up story in new”, “Send new story email”, IF( {User status}=“Sign-up no story”, “Send sign-up no story email”, IF( {User status}="Sign-up Story in new”, “Send new story email”, IF( {User status}=“Sign-up Story in draft”, “Send story in draft email”, IF( {User status}="Sign-up story in published”, “Send post-publication email”, “Nothing” ) ) ) ) ) )

Hi everyone, first day on Airtable. I am currently transitioning my spreadsheets from Excel. Basically, I have two records with the same field (Trip #) with unique data in each record. The unique data that i am trying to compare are the odometer readings and determine the exact miles that were driven from the pickup of record one to the delivery record for record two. I changed the Trip # to a date format in attempts to use the “is_same” function but it keeps returning the individual mileage for the each row and not an aggregated total of the odometer readings into the loaded miles field. Thank you in advance for any help or insight that you might have.

I understand that to have sum of column A and column B, I can use formula SUM(column A + column B). But If I want to add up 50 different columns into 51st column, I will have to use formula SUM( Column 1+ Column 2 + … + column 50). Is there a simpler way to do this?

hi, i’m trying to do a simple multiplication formula, Qty * Unit Price , but it come out #error , anyone can help me to solve this problem , thanks!!

I have a base providing the back-end of a ReactJS app. It has worked really well in production for multiple years. Now I have some tweaks to make to the base formulae BUT I’m scared of breaking them… “if it ain’t broke, don’t fix it”! So I’d like a version history on specific formulae, in case I need to roll back the changes I’ll be making. Base backups won’t suffice, since a roll-back means potentially losing data that users may have entered since that last version of the base. I need something more granular, allowing me to roll back single columns. So I’m curious: beyond manually copy-pasting the formulae out from Airtable UI into a code repository, is there any recommended version-control for Airtable formulae? Has anybody else already asked this and ended up going with the manual option? The affected columns number 15-20 but there’s only likely to be this onece-off edit, so the manual approach could serve well enough. But I suspect it will become a more relevant qu

Airtable

Happy Friday, Airtable community! I’ve got a formula that works, but only sometimes. Its purpose is to cut news sources down to just their names, no taglines, no section headings. While it’s a long formula, the sources within it are in alphabetical order so it shouldn’t be too hard to find the ones that are giving me trouble, namely: Al Jazeera, Literary Hub, Mother Jones, Open Culture, Rolling Stone, Slate, Teen Vogue, The A.V. Club, The Guardian, The Intercept, The New York Review of Books, The Progressive, VegNews, and Washington Post. Hoping someone can see a pattern. Here’s the formula: IF({Source}= “action’s Email Updates - Tracked Events from GovTrack.us”, “GovTrack”, IF({Source}= “Al Jazeera - Breaking News, World News and Video from Al Jazeera”, “Al Jazeera”, IF({Source}= “Animal welfare | The Guardian”, “The Guardian”, IF({Source}= “AP News - AP Top News”,

Hi All, New user (doing pro-bono work for a small edu business) so not too familiar with this but have read all the ‘form’, ‘pre-fill’ and ‘button’ articles here and around 60+ community topics to try to work this out. Teachers giving feedback/assessments on the students in their course. Students table, Courses table and the Assessments table linking them with all the questions etc Because of Airtable pricing, I need the teachers to use a Form to enter the assessments and I’m looking to automate the ‘listing of the students in their course’. So, ideally a picklist from the student names in the record cell. I have a form where they add the Course-ID and then enter the Student Name. With 10 students in a course they have to do this same step 10 times so I’d like to prefill. I can do the course ID ok but not do the Student name (because it’s multiple names). Q: I’m now trying to use a button to open the form pre

Can anyone help provide a solution to this formula? I’ve tried it with ABS and IF. (2*{width}) + (2*{height})