Formulas

I’m making an analytics dashboard for a client. They want to be able to see the top X records by viewcount, which we track. When I make a graph for this, there’s simply too many records and the bar chart looks a mess.I want to create a formula field that has a rank and I can include the top 5 records in a bar chart. What’s the right approach for this? I am not a developer and hoping to avoid an automation w script.

Fairly new to AirTable, so this is probably really simple, but I can’t find anything helpful.When I have a Rollup field, I cannot expand the Formula field DOWN using the bottom corner handle - only to the right. This means I can only see about 1.75 lines of the formula. I’m copy-pasting in and out of Notepad to try to create/edit formulas because I can’t see the formula in AT.I can expand the Formula field down as far as 10 lines if the field type is Formula instead of Rollup. What on earth is going on here? 

I could really use some help!I want my formula to return the correct Ship Deadline taking into consideration the time the order was submitted. If it came in before 4:00 pm on a weekday, it needs to ship the next day. If it came in after 4:00 pm on a weekday, it needs to ship in 2 weekdays.This screenshot shows that order 5014021 came in at 5:15 pm correctly shows it needs to ship 2 weekdays later. But for some reason, order 5014020 that came in at 7:15 pm on the same date is showing it needs to ship in 3 days instead.I can’t for the life of me figure out what I am doing wrong. Formulas are not my strong suit so I use AI to help write them. Any advice here would be very much appreciated. It will be so awesome if I can get this to work with anyone’s help!My formula:IF({Store Name} = "Retail",IF(

HelloI’m currently working on a Production Planning base, which is essentially a way for us to communicate with factories on the projected production they can expect from us for the forthcoming months. Currently there are two sets of data:Projected Units  Quantity attached to a “Launch” or a “Deal”.  Confirmed Units. Quantity of confirmed units which have Purchase Orders attached As an example, we have a deal across “P6 & P7” (period/phase) with a customer and projected around 500k units. The problem is that the factory is not going to produce all 500k units at the same time and this deal stretches over a period of time - which based on the customers sales calendar is Feb-Mar-Apr. That is their sales window, so we need to work backwards around 10 weeks for shipping and then an additional 30 days for production.I’m currently trying to figure out the best way to disperse the 500k

Today I noticed an issue with Lookup values—Airtable formulas are not recognizing them in conditions. Is anyone else experiencing the same problem?

Hi,We’re automating invoice creation, and need therefore to create payment reference numbers. I’d prefer to create these programmatically within Airtable.As a basis I wanted to use a autonumbering field we already have for creating unique IDs for the orders. Basically the base number will get an added checksum number, so that electronic banking systems can validate that the payer has entered the correct reference number.I found an Excel formula that creates the reference numbers according to our (Finland) banking standards (have tested, it works in Excel). I have been trying to convert it to Airtable, but I can’t get it to work.ORIGINAL:=IF(ISNUMBER(A2);(10*A2+RIGHT(10-RIGHT(7*MID(10000000000+A2;2;1)+1*MID(10000000000+A2;3;1)+3*MID(10000000000+A2;4;1)+(7*MID(10000000000+A2;5;1))+(1*MID(10000000000+A2;6;1))+(3*MID(10000000000+A2;7;1))+(7*MID(10000000000+A2;8;1))+(1*MID(10000000000+A2;9;1))+(3*MID(10000000000+A2;10;1))+(7*MID(100

Hi Airtable community! 👋I’m working on a base where I need status updates in one table to automatically reflect in another table — and I’d love advice on the best way to build this.BackgroundI have two tables:📌 Projects Project Name Status (e.g., “Planning”, “In Progress”, “Completed”) 📌 Tasks Task Name Linked Project Task Status I want to automatically update the Project’s Status based on the status of its linked Tasks. For example: If all Tasks are “Completed”, set Project Status to Completed If any Task is “In Progress”, set Project Status to In Progress Otherwise, Project Status should remain Planning Right now I’m using rollups and

I’m having an issue with a formula that rounds up incorrectly, i’ve browsed the forums and can’t seem to find a solution.I have a simple math equation x * y = zI suspect that the issues is stemming from a formula that contains four decimal points:I’m not able to round up this number, however, it needs to remain as is.  I’m not sure how to get a correct calculation using airtable. 

can someone help with this formula, when there are no dates in the fields it returns 12/31/1969, i’d like it to return a blank or “none”  DATETIME_PARSE(  MAX(    IF({Last Entered Patrol Start Date (from Patrol Reports Section 1)}, VALUE(DATETIME_FORMAT({Last Entered Patrol Start Date (from Patrol Reports Section 1)}, 'x')), 0),    IF({Last Entered Patrol Start Date (from Patrol Reports Section 2)}, VALUE(DATETIME_FORMAT({Last Entered Patrol Start Date (from Patrol Reports Section 2)}, 'x')), 0),    IF({Last Entered Patrol Start Date (from Patrol Reports Section 3)}, VALUE(DATETIME_FORMAT({Last Entered Patrol Start Date (from Patrol Reports Section 3)}, 'x')), 0),    IF({Last Entered Patrol Start Date (from Patrol Reports Section 4)}, VALUE(DATETIME_FORMAT({Last Entered Patrol Start Date (from Patrol Reports Section 4)}, 'x')), 0),    IF({Last Entered Patrol Start Date (from Patrol Reports Section 5)}, VALUE(DATETIME_FORMAT({La

Have a form that a record picker is used to select a client and am trying to get a encoded URL into a button that can be selected from within an Interface page and have the client pre-selected.Have made plenty of Forms pre-filled encoded URLs (Button linked to formula building the URL), but cannot get this one to work - only seems to be for the Record Picker elementHave other URLs for this exact form that work fine, eg:https://airtable.com/appgAgIX5zNGRiox4/pagqzLgwghd7xBloc/form?prefill_Action+Type=Maturing+Term+Deposit&prefill_Task+Name=Maturing+Term+Deposit+-+(Bank)(Amount)(Date)

Disregard...no way to delete

// change these names to pick a view:let table = base.getTable('Invoices');let view = table.getView('Grid view'); let result = await view.selectRecordsAsync({fields: ['Amount']});let runningTotal = 0;for (let record of result.records) {    // change the field names here to adapt this script to your base    runningTotal += record.getCellValue('Amount');    await table.updateRecordAsync(record, {        'Running total': runningTotal,    });}

A couple months back, I asked for help deleting lines of text beginning with the word ‘Highlight’ and was given this great formula: REGEX_REPLACE({Hook},".*Highlight.*\\n\n?","") It has been a huge time-saver but something I forgot to ask with my original question is if there is a way to add a blank line/line break where those lines were. I input data into the records that looks like:Highlight(blue) - Page 34 · Location 290“Look at that. That thing’s almost a book.”Highlight(yellow) - Page 34 · Location 292“You think… she’s going to print it? When it’s done?”Highlight(pink) - Page 34 · Location 294“I hope so,” I say as brightly as I can manage.  And when using the current formula, it comes out like:“Look at that. That thing’s almost a book.”“You think… she’s

I'm creating an athlete database. I want to create a column that shows where an athlete ranks, for various metrics, relative to everyone else. For example, let's say someone is 6'9" tall and that puts the athlete in the top 2% of all the athletes in the database. How can I calculate that for that athlete (and every other athlete)? Is that possible?

Hello - We are creating a way to track social media posts for our clients. Clients will ask us to make a certain number of social media posts on their behalf, we then want to keep track of how many social media posts have been made and how many are still required for each client contract. Here are the two tables we have created Social Media Posts Created - Airtable - Content overview Social Media Contracts (requests) - Airtable - All content and requests I’m new to Airtable, so this may be a simple formula, but any help would be appreciated.

After extensive searching, I’ve confirmed that rollup functions do not support finding the mode of the values in the rollup field. I can’t be the only person who has come across this need, so I’d love to know what methods are available without using a 3rd party app. I’m not opposed to an automation, but would rather it be as simple and without the need for scripting if possible.

Hi Dear Communauty, Facing a small challenge with my apps actually i need to create a recipe directly but i have to do it into 2 steps as I have diffrents tables and really dont know how to solve itif somebody can help to fix it i will more than happy Thanks 

Hi! I’m creating a base of videos from youtube. I have an attachment column in my base and I want to put there video thumbnail. All thumbnails have the same link but with different ID. For example: Link: https://www.youtube.com/watch?v=pAl9SayLzTE ID: pAl9SayLzTE Thumbnail link: https://i.ytimg.com/vi/pAl9SayLzTE/maxresdefault.jpg Questions: Is there a formula that will create a link to thumbnail with a known ID from another cell? So I need some formula that will insert ID in a template https://i.ytimg.com/vi/XXXXXXX/maxresdefault.jpg instead of XXXXXXX

how can we get data from API in Airtable? below is the sample API curl -X GET "https://apiv2.shiprocket.in/v1/external/courier/track/shipment/1559017361980" -H "accept: application/json" is it possible ?

I have a table (Invoices: House) that uses a sequential Invoice # entered in a field type: Number. I am currently entering each one manually as I create a new invoice record in the table. I would like to automate the process of assigning the next sequential number as I create a new invoice record.I am trying to figure out if I can do this with a formula or if I need to use an Automation or a Script.Does anyone have a way to do this?Thanks, Scott

Hello everyone,I am trying to make a nested IF/AND formula to do the following:IF the ‘Date First Contacted’ = blank, status = ‘Not Contacted.” IF the ‘Date First Contacted ‘= not blank and ‘Follow-Up Date’ = not blank, status = “Followed up.”Is it possible to write this into a formula given that ‘Date First Contacted’ and ‘Follow-Up Date’ are separate fields?  Thank you! 

I click the + below.The form opens.I click "Save" but nothing is saved.

I want to create a formula to select the SECOND-LARGEST value among five different categories. I’ve already created one to select the LARGEST value (called “Category 1), and then my thought was to exclude that category and return the max of the remaining four fields. With the help of Airtable’s AI, I got this formula:IF( {Category 1} = "Connections", SWITCH( MAX({Events}, {Programs}, {Support}, {Marketing}), {Events}, "Events", {Programs}, "Programs", {Support}, "Support", {Marketing}, "Marketing" ), IF( {Category 1} = "Events", SWITCH( MAX({Connections}, {Programs}, {Support}, {Marketing}), {Connections}, "Connections", {Programs}, "Programs", {Support}, "Support", {Marketing}, "Marketing" ), IF( {Category 1} = "Programs", SWITCH( MAX({Connections}

Hi all, I import CSV files with salary ranges.There are two fields from CSV: “Salary Min” & “Salary Max”. Their format is $75,000.00. I want to have them in one field ($75,000 - $100,000), so created a third field with the formula IF(  AND({Salary Min}, {Salary Max}),    "$" & {Salary Min} & " - $" &a

Hello, I want to create a food menu, such that customers can view the food items and other details in the gallery view and can order multiple food items at once by submitting. This will streamline process and give a better customer experience. I will provide a tablet or a link to them to make an order; At present, I have the option to give them a form which is not graphical and they have to make any submissions from their table. The data goes into the grid view and is accessed in the kitchen for processing. Thanks