Multiple Substitute in Airtable, I have one field that contains jebirish information but it contains one of the information. like ’ Field updated UNDO Your Account Name: Reillence Lester DiocsonYour Account Number: 9189160337Your Pin Number: 860503I ...
Hello, I am trying to use an IF formula to equal a date but can’t find how to do it. I want to create IF({WEEK} = “Wk 1”, “15/01/22” example. wk 1 = 15/01/22 wk 2 = 23/02/22 Wk 3 = 30/02/22 Does anyone know how to do this? Thanks
Hi, i’m using Airtable to help my customers for refund. so the form on my website is working fine but i need to improve it. Customers enter their bank details. I would like to make sure that the key is correct. i have a huge formula in Excel and i wa...
I am using the switch formula to have Airtable populate a numerical value into a cell based upon the input chosen from a multiple select option. Prior to this I was typing the amounts in and it was working properly. Now I have set up the switch to po...
Now I have got 2 tabs, the first one has a list of events, including the company name, event date and event notes (Each company could correspond to several events). In the second tab, I created a field called the most recent event, which filters all ...
Hey folks, I’m trying to calculate the number of days someone has worked in a job. I’m familiar with the DATETIME_DIFF() function, which works great when you have a Start Date and an End Date, but what if you don’t have an end date? In other words, i...
Hi all - need help! I have a Multiselection of “profiles” linked to a store. I then have items which may relate to one of those profiles. I need a formula to look at the “item profile” and see if it exists within the “store profile” multiselection - ...
Hi there! I’m trying to do a fairly simple formula but it has quite a lot of conditions. I’m a beginner and not sure where I’m going wrong, could someone help? The board is a basic project overview. I’m trying to set a column to display “on track” or...
So I’ve gathered that I can’t use both AND and OR filters, but the workaround is to use formulas. Problem is, I can’t find a formula to solve my problem. I currently have two columns that I want to be able to filter, a “status” column and a “release ...
Hi there! There are a few formulas out here for similar-ish issues but I can’t find on that matches exactly what I need. I’m trying to create a formula that shows “Done” if the date is in the past, “Upcoming” if in the future or “In progress” if it’s...
