Formulas

Hi Community, Appreciate if someone can help comment about this statement as its not working. Thanks. IF( {Event Type} = ‘Partner Tech Talk’, CONCATENATE(“URL/YYYYYYYYYY”,"?prefill_id=",ENCODE_URL_COMPONENT({Feedback Key}), CONCATENATE(“URL/XXXXXXXXXX”,"?prefill_id=",ENCODE_URL_COMPONENT({Feedback Key}) ) NOTE: I concealed actual URLs - assuming URL/YYYYYY works. In other words CONCATENATE statement works by itself. However, when trying to create IF statement picking the right URL based on Event Type field this doesn’t work.

I saw a post with the following formula: IF(IS_BEFORE({Due Date}, TODAY()), “ :boom: ”, " ") This formula puts the emoji in a column if the due date for something is past. I’m not really good with formulas. Is there a way to make it have that emoji if it is ON the due date AND after?

New to Airtable and loving it so far! I am creating a Table for calculating costs and processing invoices for a logistics company. I am looking for a formula that will give me the result below: If the number in column A is greater than the number in Column B, then it should be inserted into column C. BUT if the number in Column A is less than that in Column B, the Column B number should be inserted into Column C. In other words, the greater of the numbers in Columns A and B should be inserted into column C. Any help would be appreciated.

Hi there, I’ve been working on this and cannot seem to figure it out. I’m trying to write a conditional IF statements that essentially says - IF Field A= 1 and Field B=2- output 3 IF Field B=1 and Field A=2- output 4 IF Field C = X- Output X Here is the current syntax I have written- I’ve gotten it to do the first two parts, but cant get the last part running. Any help is wildly appreciated!! IF(AND({Are you in recovery for a mental health disorder?}=‘Yes’,{Are you in recovery from a substance use disorder?}=‘No’),‘MH’,IF(AND({Are you in recovery from a substance use disorder?}=‘Yes’,{Are you in recovery for a mental health disorder?}=‘No’),‘SUD’),IF {Field 60}=’CO’,’Co’,’Z’)

Hello, I have a formula for UTM and its pulling from the other columns in the sheet, but for some reason, it is not hyperlinking the entire URL. I not sure why, But I have doubled checked the formula to make sure there are no spaces. I am new to Airtable formulas so I am not sure what I am doing wrong. Thanks!

Hello, I’m writing a formula to tell me the DMA region of a client based on a list of zip codes. Here’s my formula so far: IF({Zip Code}=‘34471’,‘Tampa’,IF({Zip Code}=‘32703’,‘Orlando’,‘Other’)) I just need to know how to turn ‘34471’ and ‘32703’ into a list of zip codes (I already have the list), where ‘Tampa’ or ‘Orlando’ could be triggered for any match in that list. Thanks!

Hi, Can someone help me find % completed? So in my Airtable, there are various tasks and subtasks. For example, Legal will 5 tasks and the statuses are complete and not started. What I am trying to find out is if 3 of those 5 are complete then how can it display 3/5 in % terms in Legal. Same for Operations under Operations category. And lastly, I want to add total project completion percentage based on LEGAL and OPERATIONS.

I’m converting a table that has multiple text field columns into one multiple-select column. The old form had text input fields so the most of the data is like this: and now that form has condensed those fields into one multiple-select field, like this: . I don’t want to keep the old text columns around, and want to collate those fields into the single existing multiple-select column. I think the way to do this is in a step-wise fashion: create a lookup table that converts the text into the new multiple-select labels use a rollup field on the main table to concatenate or arrayjoin the data into one comma-delineated string, copy that data over into the existing multiple-select column delete the old columns and the reference table

Hi there! I have a Table called Projects and another called Updates (both are connected via Linked Records), both are in the same Base. I’d like to have a flag (a binary 0/1 or true/false so I can put them in a Count Block on a Dashboard) for all Projects (that have a Status of In Progress) if they don’t have an Update for them for the previous week. In the Updates Table I have the name of each record as the number of the week (calculated via a formula, with a little nuance for stragglers who might not update until Monday). Any idea how’d I’d go about doing this? Thanks in advance for your help! James

My goal is to have a formula to populate New Profile from either Legacy Profile or a Concatenate of Company Responsibility, Professional Background, Educational Background. Ideally for the Concatenate portion, I can have the three fields with a paragraph break between them, if that level of formatting can be achieved. (as demonstrated in the sample table below) My records will only have either the legacy field or the new 3-field combo populated with data. New Profile fx Legacy Profile Company Responsbility Professional Background Educational Background Amazing legacy profile Amazing legacy profile CEO responsible for big things.Worked at great companies like…Super smart becau

Can I please get some assistance with a conditional statement. I’ve looked at examples, but have not been able to crack this. Goal: First Name space Middle Initial space Last Name or First Name space Last Name Not all names have a middle initial therefore my current formula is creating a double space when no middle initial present. I know this will require some kind of conditional if statement. There may also be a more graceful way of handling the spaces between field values. Current Formula CONCATENATE({First Name}," ",{Middle Initial}," ",{Last Name}) Data Structure First Name Middle Initial Last Name Todd Roberts Rene M. Johnson

Hi community, I have two tables in my base. I’m in table 1 and I want to create a IF formula and bring info from table 2 (from a specific view) Is there a way to do that? If not, can I do a formula that uses info from a different table on the same base? Thanks

Dear lovely people, I’m stuck with a formula (again). I have a base for coordination of translation work. I’d like to get an alert emoji if in a record: “activity” is “translation” and WC is empty or “activity” is “review, proofreading, upload” and “time task” is empty or “activity” is empty Do you know if this is possible to build in a formula field? Thanks so much in advance! :blush: Belén

Hi, So I am completely new to Airtable and used to Google Spreadsheet functions and scripts which seems a lot easier suddenly. But I am looking to create a unique ID that sums up per channel. So we have a base with 2 tables: Videos Channels Imagine we would have multiple videos per channel, and this video should have an unique ID but per channel. I am looking for a formula to do this, but made a manual table to show how the result should be: Any idea how I would do this? It is probably fairly simple but somehow I need a push into the proper direction it seems. Thank you

Hello… I’m using a rollup with ARRAYJOIN(values,"\n • ") Which is giving me this result Item 1 • Item 2 • Item 3 I want this result • Item 1 • Item 2 • Item 3 How do I create a formula that puts a bullet on first item?

Hello, Here’s my base: I’m using a Roll Up to see if the URL in “Leads” table includes the UTM in “Inputs” table. If it does, I want it to add the corresponding “Source” from the “Inputs” table as the “Referral Source” in the “Leads table” I thought I might be able to achieve this as adding this formula with the Roll Up: IF(SEARCH({UTM},{Input}){Source}) But it tells me that’s an invalid formula. Thanks for any help!

Hello the community ! I have a table with a date field. I have a formula which is : IF(IS_AFTER(TODAY(),{Date}), ‘Published :rocket: ’, ‘To publish :hourglass_flowing_sand: ’) And it’s working fine. Now, I have 3 différent dates for 1 record. So I have a 3 date fields : ‘Date1’, ‘Date2’ and ‘Date3’ What are the formula for “If Date1 or Date2 or Date3 are not empty, then ‘Published :rocket: ’, ‘To publish :hourglass_flowing_sand: ’” ? Sorry for my english… Thank you very much !

Formula to multiply Sale Price column which is formatted as Single Line Text by ONP Net% column which is formatted as percent (1.00) to fill the ONP Commission column which contains the formula and format as currency. Throws and ERROR no matter what I try. Have tried: VALUE({Sale Price})VALUE({ONP Net%}) {Sale Price}{ONP Net%} Changing format of Sale Price to currency (which breaks all the other formulas too) Adding VALUE worked to fix the ERROR on all other columns except the the ONP Commission column. Any suggestions?

Hi, I’m trying to lock in a timestamp when a status changes to one particular status. I would like that timestamp to be locked in and not change once the status changes to the next stage. Here’s a formula that would work except that once the status is changed off of the desired status it wouls go back to blank. IF({Status}=“Shop Floor”,NOW(),"") I could do it the following way, but the circular reference isn’t allowed. =IF({Status}="",(if({Status}=“Shop Floor”,NOW(),{Plan to CNC}))) Anyone have a workaround? Thanks in advance!

I have a column called “Visit” that’s all the client’s visit dates/times and am trying to add a “Last Visit” column that displays the last date/time of their appointment. I did a Rollup of Max(values) on the “Visits” column to display in the “Last Visit” column, but it is only returning the date of the last visit and not the time. How do I modify this Max(values) Rollup so it has the last date AND time of their visit: e.g. 4/10/20 2:00 PM ?

Hello. I have 2 tables in one base. One is called “leads” and one is called “Inputs.” (I’d like to add screenshots of them, but it says images are not allowed in posts) “Inputs” has 2 columns: Column A: “UTM” - 43 rows of different UTM strings Column B: “Source” - 43 referral source names, each corresponding to a UTM string “Leads” has 3 columns: Column A: “Name” - contact name Column B: “URL” - the website URL where the user contacted us Column C: “Source” (The formula will be used for this column) Zapier will enter a customers Name, and URL where they contacted us, in “Leads.” I am using “Inputs” as my lookup table to interpret website URLs in “Leads.” I need a formula that will do this: If “Leads” URL contains any of the UTMs listed in “Inputs”, then fill in the “Leads” source with the corresponding source listed in “Inputs” next to that UTM. If “Leads” UR

Hello Airtable community… I currently have two columns User Name User Fact Item 1, User Fact Item 2, User Detail User Detail Item 1, User Detail Item 2 I need a formula that creates an array with rich text formatting that merges the two columns to create this At the moment I’m using {UserFacts} & “\n” & {Facts Detail} Which is doing this User Fact Item 1, User Fact Item 2, User Detail Item 1, User Detail Item 2 But I want this User Fact Item 1 Item 1 User Fact Item 2 Item 2 Would you be able to help or give me a pointer? Thank you

I’ve created a form that I’ve asked employees to fill out daily to help us track COVID-19 systems in our work force. I have a second table in my base that has the entire employee list with emails. I would like to create a formula/view where I can see who hasn’t filled out the form on a particular day so that I can send an email reminder to ping them. It’s not as simple as a date match, because I don’t want to see previous dates, only a particular date to see who is missing if that makes sense. New to doing this and any help is greatly appreciated!

Hello everyone, Due to Covid 19, my company decided to find an inexpensive way to create a Lead Management system for our Telemarketing and Telefund campaigns. Airtable seems to work great so far with the actual calling (even though it is a bit more hands on) but I am running into a small issue with our calling calendar. To give you some details, the calendar needs to work as a working document, showing (by month) which segments are called by Telemarketing and which by Telefund. The way I have set is by: a) Creating 3 tables in order to create groups for the segments (e.g Series A, Series B etc = Renewals, Tickets to X performance = 2021 Fall tickets etc.) One for Telemarketing, and one for Telefund as well as one table to group our suppressions. b) Under the original table, starting with the months as the initial column I added a date for when each extraction needs to be completed, a completed/not completed indicator, expected revenue (sep

I can’t find the way to format properly to date a rollup field. The formatting tab return that it’s not a date field. I have that : 2020-10-05T00:00:00.000Z and I want just that : 2020-10-05 Yet, the field rolled up is a date and the aggragation formula is ARRAYUNIQUE(values) Thanks in advance