Formulas

HiI have 8 fields with numerical values and I want to create a "summary" in a new field, which would show per each record which of those 8 are the 3 top ranked fields (name_field&value). Is that possible?Thanks   

Hello Airtable Community,I have 2 tables: Attendance and Performances. People will fill out my ticket request form, submitting their preferred number of tickets for Performance Dates 1,2,3 etc.  This gets recorded in the Attendance table under their school name and quantity goes under "Number of Tickets." I also have a Performances tab that tracks total number of tickets available for the performance. I want to use a rollup or formula to connect the two tables and deduct the total SUM of tickets claimed from a Total Tickets Available number that I set (right now it is 1,000 tickets.)Ideally I am able to make this appear in both tables: Attendance and Performances. Can you help me?   

Hello, I currently have this question needing to solve "If a branch's average monthly gross revenue in the last quarter is higher than $1500, its revenue split rate will be 80%, or else it will be 70%"I want the result to show Percentage 80% and 70% as result because after that I will use them to calculate the net revenue. ASAP. Thank you.

Hello! I am trying to extract text from within Parentheses and can't get the Regex formula quite right. The data comes in like this:Highrise Intro (First Last)I want to extra First Last and eliminate the rest. Thanks

Hi! I have looked pretty extensively in other questions and feel like I just must be missing something. We have a diaper bank and have one field that is a Multiple Select. That field has many selection options; we don’t care about counting most of the individual items in that field but when either Pads, Tampons, or Pregnancy test is selected, I’d like the value of “1” to be entered into the Pads, Tampons, or Preg test field (so we can correctly count how many of each item we are giving out.) Can someone please help me with the formula? Thank you!

I have start dates and end dates for each project in a list of about 50 projects. I want to create a filter that will only show me records that were active between the start date and end date during specific fiscal years (where I set the FY date parameters). Some projects span multiple fiscal years, so "on or after" or "on or before" doesn't cover everything.

This is my data, inclusive of images, and the ensuing results I'm obtaining from Airtable on Make.com are clearly visible.However, there seems to be a slight issue. Instead of receiving the value 1014.40 as expected, I'm getting 1014.4000000000001.Could you guide me on how to rectify this discrepancy?      

Hello!I am trying to create a formula which gives an output of difference between two dates (Premium date & Last month from Today date - as seen in the last 2 columns). The base is primarily used to manage my Insurance payments, so keeping that context in mind if its helpful. The issue is - I have two Premium dates in my table (because some times Premium might be half-yearly frequency payment). So, in order to get the difference in dates for only 1 date (Yearly premium) - I used the following formula:IF({Plan status}="Active", DATETIME_DIFF(DATETIME_FORMAT({Premium pmt date},'DD-MMM'),DATETIME_FORMAT(DATEADD(TODAY(),-1,'month'),'DD-MMM'),'DAYS'),'NA')And this is working fine.But, when I introduce 2 dates into the formula - I also need to use a MIN() function that gives me the lower of the difference val

Hi everyone, I have a base that keeps Anydesk ID's of our staff, and I want to open Anydesk automatically from Airtable, using the saved Anydesk ID. There is a URL Handler from Anydesk, the problem is, that the link doesnt open in Airtable.Thats the link with the Anydesk ID. Entered in a Browser, it opens the Application and the session automatically. But Airtable doesnt recognize it as a link, ass www, https, or https before doesnt help. Any ideas how to solve it? Best Yonatananydesk:123456789https://support.anydesk.com/knowledge/url-handler 

Hi expert guys and gals, I am struggling with what appears to be a straightforward mundane issue, but I have scoured the Community and the internet without any luck. I have workers schedules and sometimes they work Monday to Friday, but sometimes they work, say, every other day and some of their shifts fall during the weekend or during a national holiday. So I have a field with multiple select where it shows which days they (will) work and how many hours - from there multiply the number of days by the hours to get the total payable hours per week and consequently the total pay for the week. How can I go about finding which of their shifts/dates that they have to work will fall during a weekend or a holiday, so I can pay them double on these dates. The question is twofold, and the easy part is, I think I can use an IF formula to ch

Trying to accomplish this simple formula but it results in an error???Using a Single Select Field and a Currency Field.{Toe Kick LI} * {Toe Kick Cost Per LI} Thanks in advanced for your assistance!

Hmm, I feel like this should be easier, but I'm running into a stumbling block.I have a Multiple Select column {Dubbing VO (all languages)} that has a list of VO actors. Each name begins with the two letter code for what language they are working in. i.e. ES for Spanish, HI for Hindi etc. There are multiple actors for each language.Then I have another column that is the VO artist per language. i.e. {ES VO actor}. I'm currently using the formula below to pull in the selected name that begins with that language's code. The problem I'm running into is when there is more than 1 ES actor on a project. It only returns the first name it comes across. The code I'm using as an alternative returns all of the names in the {Dubbing VO (all languages)} field.Code that works for 1 name:IF(FIND('ES', ARRAYJOIN({Dubbing VO (all languages)}

I have a table created like the one on the picture and would like to create a concatenate field with the name of the columns that have stars associated with. Is it possible?For the first record the formula should return (M&A, IPO, Turn Around, Financiamento/Captação), for the third record the formula should return (IPO, Planejamento Estratégico) 

Hi everyone!I have two lookup fields, each one of them with a list of dates, and I need to merge them in the same field, keeping the date format. I've been testing with some formulas like concatenate, arrayjoin, dateformat... but I haven't been able to solve this problem. Do you know how to do this? In case more detail is needed, I have a table with employees, another with Time Off Request and a third one with Holiday Calendars. Each line in the Time Off Request tab is linked to one employee who has requested that day off. Each date in the Holiday tab is assigned to several employees who are going to be off that day. Then, in the employee table, I have a lookup field for the dates from the Holiday Calendar tab, and another lookup field for the dates from the Time Off Request tab. I need to have all those dates in the same field and in a date format to be able to use it in a Timeline view. Is this possible?Thanks for your support!!Best regards,

Hi! I'm new to creating formulas. I can create two IF formulas in independent columns, but am struggling to combine them into a single formula to communicate a task is due in ___ days, but to also make this countdown stop when a task is completed.This formula is dependent on two fields: Due Date and Status (Not Started, In Progress, Done).I need this formula to create 3 potential outcomes:BLANK, if no Due Date was entered. __ DAYS, if a Due Date was entered and the task is not complete.✔️, if a Due Date was entered and the task is complete.I achieved #1 and #2 with this formula: IF({Due Date}, DATETIME_DIFF({Due Date}, TODAY(),

Requesting assistance with the following formula I am unable to get to function properly. IF(AND({Proof of Service (Differential - Proof of Service+(x)Days)}<=20, {Document Received}=BLANK(),"Pending")(IF(AND({Proof of Service (Differential - Proof of Service+(x)Days)}>20, {Proof of Service (Differential - Proof of Service+(x)Days)}<50, {Document Received}=BLANK(),"Delinquent"),(IF(AND({Proof of Service (Differential - Proof of Service+

Hello, if I have a cell with a range of numbers in, as selected via a multi select, is there a formula that can add these numbers up and give me the total, for example i'd like a column that will show the total of the numbers in image of the cell attached, which would be 14. Thanks

Hello, I am looking for a way to do something like this: I do have two values. I want to sum up these tweo numbers and create 3 more results. I.e. the value of field "first field" is 70, the value of field "second field" is 10.The result should be the sum of both values but with 9 more calculated numbers: i.e. 80 / 90 / 100 / 110 / 120 / 130 / 140 etc. (So I need a total of 10 numbers in the result. And all numbers should be separated with a slash and a space before and after the slash). How is this possible with a formula? Thanks for help,Michael

Winged Foot Condominium Assn dBase.Base has 2 Tables named Maint Fees and Winged Foot AssnMAINT FEES TABLEMaint Fees table has 5 fields: Unit Name > [$] 2022 Maint Fees > [$] 2023 Maint Fees > [Linked] Winged Foot Units > [A] NotesMaint Fees table has 6 records (Condos)Maint Fees amounts can change every year for each of the 6 records WINGED FOOT ASSN TABLEWinged Foot Assn table has 29 fields - these 4 fields should be considered for a formula: [Primary Field] [A] Unit & Week > [CkBx] Maint Week > [CkBx] Assn Owned > [Lookup] 2023 Maint Fee > WF UnitIs it possible to change the Lookup field 2023 Maint Fee to a Formula field?If so, the formula needs to Lookup the amount from the Maint Fees table based on the WF Unit field and enter the amount f

Hi all I’m using a table to create a list of rotas showing who is on duty during a given date range. There will be multiple people on duty across different date ranges in different areas of the country. What I need is then to be able to use a search app in which users can enter any given date, and the results will show who is on duty on that date, and only those. I’ve only got as far as OR(IS_SAME(TODAY(), {Start}), IS_SAME(TODAY(), {Finish})) which gives “1” if {Start} is today’s date or if {Finish} is today’s date, and I think I’ll need the IS_SAME function at some point, but I’m stumped when it comes to getting the whole range of dates in one field. My thinking for how to do this is as follows: Make a formula to show all dates individually that fall between the dates in a {Start} and a {Finish} field, i.e. IF {Start} is 27/11/2020 and {Finish} is 30/11/2020, the formula will display, “27/11/2020, 28/11/2020, 29/

I have the following FieldsTemplate Type (options are either TEXT Only or With Weblink)Title LineCopyName of LinkURL When user selects Template Type Text Only, I need a field that will display the full text and contents:{"iconName":"safety","text":"Copy","title":"Title Line"}When a user selects Template Type With Weblink, I need a field that will display the full text and contents:{"title":"Title Line","text":"Copy","externalURLdisplayName":"Name of Link","externalURL":"URL","iconName":"safety"} 

Hello, I am looking for a way to combine five fields (address, second address line, zip code and city) to a new multiline text field when another field "second zip code" has a value. So here is an example of the five fields: Address: 220 Miller AvenueSecond Address line: Apartement 50Zip Code: 22033City: ParisCountry: FranceThis values should be combined to the multiline text field "complete address" (with a line break "\n" after each line, except between the zip code and city): 220 Miller AvenueApartement 5022033 ParisFranceBut the six fields should only be combined if the field "second zip code" has a value (i.e. 22033). Is this possible somehow with a formula field?Thanks for help, Michael

Hello everyone! I'm attempting to construct email and Slack automation to remind my team to update specific projects (records) in a project management interface. When we were in data mode, I merely included a link to the Record URL in the automation message body. Is there a method to refer to a specific project or record in the formatting of the record review? Or in the format of the record summary?I sent the fol

Hi everybody I am new to airtable and trying to put a class scheduling together. I have mostly been using the template and learning through trial and error. Now I have produced a weird error that does not seem to impact the functionality but is very annoying.I am using the formulaCONCATENATE(Course, " | ",{Instructor})and it gives me the correct result (e.g. 100:Contract Essentials | Kevin)but all results are now between "" (e.g. "100:Contract Essentials | Kevin")where previously the resulting line did not display ""So now I have a number of rows without "" and all new data has the ""Any idea what I should do? any help would be appreciated

Hi all,I'm sending out emails via Airtable and some (but not all) recipients are noticing a very weird problem. The URL code shows the markdown text instead of the URL link, ie., it shows [TEXT](url) instead of TEXT.I thought it might just be a problem with the users who use the browser-based version of Outlook, however one of my Gmail users also had a problem with the formatting. Does anyone know how to fix this? Thanks!