Formulas

If you look at my attached images below, I'm struggling with the CONCATENATE function. I want to add the COMPANY as a  prefix to each of the multiple items listed in the PRODUCTS column, but concatenate only adds it as prefix to the first item.I am doing this so that it will reference a price list. We offer the same products to each company, but each company has a different set of prices. I was going to figure out how to automate the copy/paste from PRICE CODE to PRICE, but I couldn't even figure out how to get the price code in the correct format. Thanks in advance for any help! 

Hi all,Some context: I have multiple bases with a list of tags that can be associated with records in other tables through a linked record field. If the users cannot find the tag they need, they can enter it as a new tag, but due to view permissions, any new tags created by these users will be given the status "requested" from a single select field. The single-select field can only be changed by an admin through a script triggered by a button, effectively "approving" the request. Since these admins will be handling requests from many various bases, I wish to create a common location for all of the requests, so they don't have to switch between bases to approve/deny requests. I first tried to accomplish this with an interface, but since the scripts don't work in the interfaces, this won't work. I then thought to go for a simpler solution: creating a synced table in a "master-base" with multiple source tables, listing the "requests". However:I need to indicate which source

Sorry if this is a basic question— I am just starting out learning how to use formulas with little/no prior excel experience.I have a formula that calculates the difference between today's date and the date a video was released. I have it returning the # of days: DATETIME_DIFF({Today}, {Video Date},'days') Is it possible that instead of returning the number of days, it could return # of years, #of months, #of days? So, instead of 952 days ago, it returns: 2 years 7 months 10 days? Thanks for any help.

I am trying to build a module in Make (Integromat) that will find a single Airtable record that matches an AND + OR condition:My formula is:AND( {NMI}="XXXXXXXXX", OR( {Subscription status}="Active", {Subscription status}="Pending", {Subscription status}="Extend"))If I create a dummy formula field in my Airtable  base and use this formula, it displays the value '1' (for 'True') in for the record I'm looking for, and all other records have the value '0' for False.When I use this exact same formula in my Search Airtable module in Make, it does not return any matches Any ideas on what could be happening here? I'm scratching my head...

Doing some work for an ATM Placement Company.When a client signs on, we have a set # of ATMs that we promise to place for them after they set up their bank account.Currently we are looking for a way to update a dropdown status based on a few factors (possibly a formula).We are currently tracking # of days since "Bank Account Opened" and are looking to automate a Green, Yellow, Red Status based on these factors....If we have not placed an atm within Days 60-90, they are a red statusif we have not placed an atm within Days 30-60, they are a yellow statusIf we have placed at least 1 atm between Days 0-90, they are a green statusIn one of the columns we have a formula to see if an ATM is placed or not. 1 means not placed, 0 means at least 1 atm has been placed. (Photo Below)We also have a column with a formula tracking # of Days since bank account was openedAnd we are looking to auto populate statuses in this columnLooking for any support possible, and please let me know if there is more i

Hi there,I got trouble with using IF functions across Date field, currently I want my result is:IF({Date field 1} is filled, then "Completed"), IF({Date field 2} is filled, then "Extended"), IF ({Date filed 3} is filled, then "Waiting")How do I make this work? Thanks!

Hey everyone! I need help making a formula that gives me the date of the next coming Wednesday based on another date in a date field. So for example if the date field shows 3/4/23, I want the formula to return 5/4/23. Thanks in advance!

Why is array unique formula considering a single data twice? I have typed multiple topics and when I use the formula I can see topics repeated. Is there anyways to avoid repetitions?

Hello all, i'm fairly new to formulas and what not and need a bit of help.I'm trying to make a single select status field's Result show either "done" or "not done" based on a symbol in a separate formula i was thinking of trying use the IF functionThis is a rough rendition of it butIF(    {PM Time Left} contains this symbol⏳ THEN{PM Service Status} is "done" or "not done" based on the symbol) {PM Time Left}<---- this is my formulated field from other date inputs{PM Service Status} is "done" <---- This is the field i want to have formulated based on {PM Time Left} containing the ⏳ symbol  

Hello everyone,  Quick question, I am using the formula DATETIME_FORMAT(Date, 'dddd d MMMM') to add the day of the week in may table (easier to fill in for the team if they know which day i.e., Monday, Tuesday, ... it is).The issus is that the formula does not show the same value as the column date and loops between march 1st and March 6th.Any of you had the problem ?THANKS A LOT

I want to measure workload in a week. TABLE 1A) i use google calendarB) In airtable DATETIME dif give me the duration: 02:00C) The weeknumber is a formula week(Start) =  So i get Week 2022_5TABLE 2 This contains only weeknumbers: 2022_552 problems:a: When i link records, I can't link with the weeknumber 2022_5 because this is a calculated field (with a formula). If fill this manually in, the link is workingb: The duration is also calculated field DateTimeDif(end-start) but I cannot use this field in a rollup field. If i add manually activities duration, then this work...So, I come from filemaker and it feels a lack because i can't link records using Calculated Formulafields to link. Or is it wrong?  

Hello,I am looking for a custom formula to help me solve the following.Basically: If text in column A is true then add numbers in column B + 50 otherwise null.If {inspection} contains "oil change" then add {engine hours} + 50.0 The problem I have is finding the correct way to prevent all engine hours having 50 added to it so I can determine when the next oil change is due.Would this be possible?

Hi everyone, Thank you in advance for any suggestions you may have 🙂 I'm working on creating an always up-to-date Airtable that consists of records being updated in Podio. So within Podio, I have an app with a sheet consisting of people; my colleagues have access to Podio, so when someone new needs to be added to the database, they can go on Podio and add to the table. However, in Airtable, I want to be able to update the new records that are created as well as any changes being made. That way, I can ensure that any new data being added to Podio is also being reflected correctly in Airtable.At the moment, I have the simple scenario to 'watch items' in Podio and to 'create records' in Airtable. The thing that this does not take into account is the new data that has been added to Podio. Could someone suggest a scenario that will allow me to continuously update Airtable with the right records so that I can always have the most up-to-date information, even when my colleagues a

Hi everyone!I'm new to Airtable so I need a bit of help.I have two bases with one main table named the same. "Students" and "Mentors"The "Mentors" base is published as a sync table in the "Students" base, and vice-versa.In the "Students" base, I have a list of students, and each row has an associated "Mentor" from the Mentors base.Now, on the "Mentors" base, I'm trying to count how many students each mentor is assigned to.I imagine I might need to use a formula, but that's beyond what I know how to do.Help? 😄 

Hello all, I'm hoping for some help with formulas that will allow me to achieve below. I have scoured all the brilliant responses to similar questions, but none quite meet with this. The format will always be the same but character lengths with vary. Also, the final .pdf that I am excluding may sometimes be a different file format. 

I've got records of song names.  I have a field with the dates we've played the song.  I want another field to extract the most recent date the song was played, but don't know how to get there.  How do I extract the highest number from an array?  Seems like it should be a simple MAX() command, but that doesn't work. 

I am trying to have a formula that says the following: 1) If the value in this $ field is greater than 0, 'Do this'2) also, the value in this $ field is 0, 'Do this instead'3) also, if the value in this $ field is a negative number, 'Definitely do this'. I have no problem writing formula to address 1 and 2, but I can't figure out how to incorporate condition 3.  Currently, my formula goes as follows (and is missing #3):IF({Current due after credits}=0, "NO CURRENT DUE",IF({Current due after credits}>0,"CREATE REMIT"))  

Hi everybody!I'm trying to move our Excel spreadsheet to Airtable to simplify things ans automate something.The spreadsheets is just a list of activity that we need to do (we rent stuff), have a look at the screenshot.Question: is there a way to transform this spreadsheet into a Airtable app? I need to be able to edit every field in the table, without using a form for each row, it would be too long.If this is possible, my idea would be to have a single "technician" and "Van" column each with a multi option selection, but since we can have multiple installation per day, is there a way to get an alert if I select the same technician for 2 row in the same day?Is there a way to highlight/separate/color all the row that have the same day?Sorry if these are silly question, but I'm just starting with Airtable and so far...I like it!!!Thanks!

I am using the LEN(string) function but I want it to exclude commas, is there a way to do that? I have a list of items with commas in between, I would like a character count of the letters but not the commas.

I organize a Run group that uses Airtable to login runners each week, via a form entry from a "Check-Ins" table. This form pulls data (names) from a larger "Runner List" that keeps track of all registered runners that have ever logged in. The "Check-Ins" table tracks the weekly login for each run and then syncs back to the "Runner List" master sheet that tallies their cumulative runs they've attended. I'm looking to create a new table that tells us how many new runners show up each week.Logic would be that the new table looks to the "Runner List" Table and searches any values that have the "Total Runs" column (which is a formula that sums all of their weekly run logins) equal to "1" and also where the check-in is the current date.Any help would be appreciated, Thanks!

I am trying to compare dates across 4 different columns. Here is the formula I need help with  - IF(DATETIME_DIFF(({Start (from Roadmap)}, {M's Start Date}) /This is trying to compare dates in two columns OR / This is to ensure the second set of date comparisons are also accounted for.  ((DATETIME_DIFF({End (from Roadmap)}, {M's End Date copy})))) /This is trying to compare the second set of dates in two columns If the first or second condition is true i.e the dates don't match I need it to return a value of say 1. Can someone help correct this for me ?

Hi there,Using the formulaDATETIME_FORMAT(SET_LOCALE({Clinic Date}, 'es'), 'dddd D MMMM YYYY')to translate dates into Spanish, however, the translations are missing "de" between date, month, year. I'm having trouble adjusting the formula so that date read. For example, the translation is working well and producing "jueves 30 marzo 2023" however, I need it to translate to say "jueves 30 de marzo de 2023" I've tried problem solving with formulas I found in AT trainings, but it's not working for me. How can I update the formula to include the word "de"?

I try the formula that IF({Date due}!=0,CREATED_TIME({Date due}),BLANK()), but the result is the created time of the row, not the date the {Date due} cell changes. What should I do?

Hello,I'm really new to Airtable and completely inexperienced with formula options.I'm looking to set up a formula so I can easily create a list of dates for the calendar year. Right now I used # option but I think a formula is more in line with what I need...Here is an example 

Hi there! I've been trying to replace  "," by "&" in a lookup field using Substitute and IF statements but I still receive an error or the result is not giving me what I want. So the result I want is IF First name contains  "," then replace by &..