Formulas

Hi all! In one of my bases quotation marks are added to some of my IDs that are generated through a formula (someone explained to me that it because my titles contain a comma, but I need to keep it).I would like to remove those quotation marks. I've read and tried a lot of things, but it is not working. Here is my formula : IF({Nom pour identificateur}, {Nom pour identificateur}, Type) & " " & IF({Début}, {Début pour identificateur}) & " " & Projet I also add a screenshot of my base. Thank you very much for the help!

 I am in search of an AirTable data expert who can help me calculate percentage increases over each month from different records. I have a social media agency and use AirTable to store all our monthly analytics numbers and would like to determine percentage changes. I am in the midst of taking these numbers into my table and using the interface feature to create graphs to see it in a more user-friendly way. Please see here for a shared view of the table - https://airtable.com/appgifDfNJk8ia1a7/shrZ2KkZk6aMWcgGj Any and all help is appreciated. Please comment below if interested in helping out. Thank you! 

Hello All,I'm trying to create a formula that will create a comma-separated list of headers from checked checkboxes.As you can see below when I check one of these boxes I would like it to automatically populate the Achievement Rollup Field with the heading of that field and any others I check. 

What formula would I use to combine these two fields and get this result?Desired result - "3.69% | Increase"I tried this formula and the result is in % STATUS off…CONCATENATE({01% DIFF OFFICE}&' |'&{CHANGE TYPE})

I am trying to create a formula with this information: If a person who booked the reservation was 2 then it should apply the formula if it was anyone other number then the field should be blank or 0.- I have created a field for booked by and put number per person - I have created another field that has : IF({Booked By} =2, "Yes", "No") so this part works ok  - I have created a 3rd field that has:{Points Paid} * 0.04  This works ok So what I am unable to do is say - If booked by is 2 then apply the formula (at the moment the formula inserts for every number not just 2)..... I hope I am making sense. Any help would be great as I am stumped. Maybe there is a shorter amount of steps to get to where I want to be!  

I've spent a fair bit of time looking and IF, AND, OR, SWITCH formulas but can't seem to figure this out for making three different options using two fields with the correct punctuation.I have two fields, {Full Name} and {Organization}.If there is just a name, I want 'Full Name'If there is just an organization, I want 'Organization'If there is both a name and organization, I want 'Full Name (Organization)'  This is the least complicated of all the attempts made which seems to work, but I can't figure out how to get the brackets to behave. IF({Full Name}=TRUE(),{Full Name},(IF({Full Name}=FALSE(),{Organization Name},{Full Name}&" ("&{Organization Name})))&")" And a screenshot of what it looks like. The only one that is correct it the Name (Organization).  Thanks in advance!

Hi everyone,I'm working in a table in which each item has two potential "availability" dates. Each item might have an availability date "A" and an availability date "B", but they will all have an availability date "B". I'm trying to set due dates for each item based on a few variables. What I need is a formula that compares availability dates A and B, and then gives me a due date that is either 60 days out or 5 days out. If availability date A is before date B or 55 days or less after date B, I need the due date to be based on date A and to be 60 days before date A. If date A is more than 55 days after date B or is empty, I need a formula that gives me a due date based on date B and one that is 5 days before date B. In the midst of all of that, I need a formula that won't give me weekends as a due date. Does anyone know if this is possible?

Hi guys,I currently have the below in a grid view.I would like to have a formula in the "Timeframe Status" column which will do the following:1. Check whether text has been added to the "RFI Resolution" field.2. If the "RFI Resolution" field is not empty, then check the hours between the "Date Created" field and the "Due by" field. If this is less than 48 hours, then return the text "Within time". If it is equal to or greater than 48 hours, then return the text "Past due". I would like the hours to be shown decimal 0.003. If the "RFI Resolution" field is empty, then return the text "Ongoing". Again, I would like the hours to be shown decimal 0.00Thanks

Current Formula: DATETIME_DIFF({End Time},{Start Time},'hours') But if I have a "Day-Off", no date + time are listed, so on these line items they return NAN. If start + end date are blank, return 0 (Zero). Searching the community post, I have not been able to locate this formula. I would appreciate your help. 

Hello Airtable Community,I'm new to writing code and am struggling to combine two different formulas into one. I have 4 columns I'm working with - Due Date, Days Until Due, Date Posted, and Priority. I want the Priority Column to output "Due Today", "Due This Week", "Due Next Week", "Upcoming", "Overdue" or "Complete" based on the number of Days Until Due and the Date Posted columns. I have a formula working that will output "Due Today", "Due This Week", "Due Next Week", "Upcoming", and "Overdue":IF({Days Until Due} < 0,'Overdue',IF({Days Until Due} = 0,'Due Today',IF({Days Until Due} <= 7,'Due This Week',IF({Days Until Due} <= 14,'Due Next Week','Upcoming')))) and another that produces "Complete" if the Date Posted field contains data, but I can't seem to combine them in the right way.IF((AND({Days Until Due} < 0, NOT({Date Posted} = BLANK()))),'Complete')

Hey all, Looking for a custom script/formula, happy to pay if required. i have a table full of records that are daily jobs. Each job has a value and I want to be able to show a total of all records that match 2 fields (customer and week number). The result should land in 'Total This Week' and the record 'Total in Matching Week (Expected Answer)' gives the expected answer.Hope it is clear but ping me if not. Have tried using various scenarios of roll ups into other tables but cant get it.https://airtable.com/appqWVJT26DBHjzDO/shrXA4B7gcO7XWTiCAny help would be massively appreciated, really get me out of a pickle.  R   

Hey there.I'm trying to get the duration of an activity by calculating the difference between 2 timestamps.These timestamps are the results of a formula that shows the time as a box is checked at the start of the activity and another, at the end. The formula in Start Time and Finish Time fields are:IF({Start}=1,DATETIME_FORMAT(SET_TIMEZONE((LAST_MODIFIED_TIME({Start})), 'America/Sao_Paulo'),'H:mm'),0)IF(Finish=1,DATETIME_FORMAT(SET_TIMEZONE((LAST_MODIFIED_TIME(Finish)), 'America/Sao_Paulo'),'H:mm'),0)Resulting this:The formula in Duration field is: DATETIME_DIFF({Start Time},{Finish Time},'minutes') And the result is "NaN" as seen above.So the question is: how do I make it show time difference of the activity? 🤔 🤔Any help is greatly appreciated.Best vibes.Ed.

Hello! getting lost in the sauce of nested IF formulas and looking for help.I have a CRM in airtable that I'd like for a formula to return one of two formulas based on a single select status for that deal.If the deal is open (any one of 7/10 statuses in the single select), I'd like for it to show the deals age based on today's date  DATETIME_DIFF( TODAY(),{Deal Created}, 'weeks')  If the deal is closed (any of 3/10 statuses in the single select) I'd like for it to show the age of the deal when it was closed:  DATETIME_DIFF({Date Closed or Lost},{Deal Created}, 'weeks')  Thanks for your help!

I am creating a record sheet with computing the monthly accrual of 1.1667?

Hello, somewhat new to airtable and using the Payroll Timesheet Template available in the template library. However, I’m having a bit of trouble figuring out how to properly calculate the pay periods as they’re not every 15 days (like in the template), but rather the 15th and the last day of the month. It currently takes the Start Date formula DATEADD({Start of Pay Period 1},({Pay Period Number}*14)-14,'days') and the End Date formula* DATEADD({Start Date},13,'days') to calculate the Pay Date DATEADD({Start Date},13,'days') I am wondering how best to calculate the Start and End Dates based on the Pay Dates always being the 15 and the EOM (30th or 31st). I’ve been playing with different formulas all day and have figure out how to calculate EOM at least, but not how to specify the 15th and EOM as the pay dates and at this point it’s all starting to look like hieroglyphics to me. If anyone has come across a solution or similar use case and could shed some light on this, I would be deeply

Hi,I have a base with a lot of records being submitted that have dates attached such as events. I want to be able to show the next 20 records coming up, keeping in mind this will change any time a new record is created with an upcoming date in the next day or two. So that might make record number 5 in the sequence be pushed out to record number 6 since a new once came in. But I still just want to present 20 records at any point in time.Thanks!

HI All! I'm trying to create a formula but am stuck. A $100 product minus 5%.That total minus 25%.That full total minus $25.For an end total of $46.25Here's what I have as a formula, but it's just not working out! I can't tell if it's the parenthesis or the actual 25%.((({Product}-({Product}*.05))-(25%))-{COGS}) Any help is appreciated!  Thanks

Hello I wanted to create a base that will auto populate Week 1, Week 2, Week 3, and so on for a number of date, Date is linked to another base which is synced to that base with a view.The purpose of this is we have a product that has a weekly interactive virtual sessions that isn't yet finished planned out so instead of putting titles of the event I wanted it to link to our content calendar where there'll be a list of week at that rage of dates and we can add records as we have.. if that makes sense. Thanks

I have a Multiple Select field that has several choices, like Camp, Membership, Donation. I want to create a Formula field that says Member or Nonmember. I know how to make an IF question for blank fields, but not for a specific Select from a field. I tried just IF(Field = “Member”), “Member”, “Nonmember”), but that doesn’t work. Thanks.

Hi, where do I find completed record when it disappeared in the table?

IF({Status}='Complete','✅','❌')IF({Status}='Billed','✅','❌') It does not let me, how can I combine them for one formula?The status section has 15 statuses, but only these 2 can go green. Please help!

Hello! I am trying to figure out a formula that grabs a start date when a previous task ends. So in row 2 the Task Dependency is DEC:Project Setup. In row 1 you see the task is DEC: Project Setup with the task due date being 5/13/2022. I want to create a formula that takes this due date and puts it as the Task Start Date in row 2. Thanks in advance for any help anyone can provide!

Hi there,I am trying to attempt to add a formula, that when a certain hotel name is entered in column A, then in column B, depending on that hotel name, it adds the hotel brand automatically. For example:If Hotel Name is Hyatt Centric, then Hotel Brand is Hyatt. I can get this formula to work: SWITCH("Hyatt Centric", "Hyatt")But my question is can I/how do I have multiple Hotel Names in one hotel brand? For example:If hotel name is Hyatt Centric, Hyatt House, Hyatt Place or Hyatt Regency in column A, then Hotel Brand is Hyatt in column B.How do I write the switch formula to have multiple options?Thanks!  

I am struggling here! I thought I was getting better - but I need help. Thank you in advance!My column is "Sourcing Manager" and I am trying to create another column with a formula to add their email automatically.If the Sourcing Manager is "Monique", then it should list Monique@theroomblocksource.comIf the Sourcing Manager is "Karen", then it should list karen@theroomblocksource.comIf the Sourcing Manager any other name, then it should list hello@theroomblocksource.comThis is the formula I am trying:IF({Sourcing Manager}=Monque, monique@theroomblocksource.com, IF({Sourcing Manager} = Karen, karen@theroomblocksource.com, hello@theroomblocksource.com)) 

I currently have a table that has alllll of our data. We want to separate it so it's a bit easier to manage. So, here's what I'm trying to do:Tab 1 - Master Info. This will have a SKU#, a product name, and a materials cost.Tab 2 - Wholesale Vendor #1 - We will type in a SKU, and it will bring in the product name and materials cost from Tab 1. Tab 3 - Wholesale Vendor #2 - We will type in a SKU, and again, it will bring in the info from Tab 1.I don't want the tabs to be busy and have extra columns. I'd like it to be a basic "vlookup" type. However, I can't figure out how to do it without a) having the extra columns and b), going into each and every line to pull out the info.Any tips? Thank you!