Formulas

I have an excel spreadsheet with many calculations.  Given my current understanding of formulas, it is very much like excel so my question is below.Formula in Excel=IF(SUM(N22:Q23)<>0,SUM(N22:Q23),"")Field names in AirtableN22= シャトル台数(Shuttle Qty)Q23= 予備シャトル台数（Sp. Shuttle Qty）So my airtable formula should be as followsIF(SUM({シャトル台数(Shuttle Qty)}:{予備シャトル台数（Sp. Shuttle Qty)}<>0,SUM({シャトル台数(Shuttle Qty)}:{予備シャトル台数（Sp. Shuttle Qty)}),"")But I keep getting an error. Where are my assumptions wrong?  It is simple addition problemOrder Qty - ShuttleShuttle Qty28Spare Shuttle Qty2Total Shuttle Qty30

Hi everyone!I use Airtable to track event time logs (like a clock in/out system).  I attached the base structure to this message.How can I make the "totalMins" linked field (linked to "mins" in the "timelogs" table) automatically select all of the results instead of clicking them manually one by one?Thanks! 

Hi,I was trying to extend the below formula to give me records due 2 weeks from now so I modified this:IF(WEEKNUM({Flight Start},"Monday")=WEEKNUM(TODAY(),"Monday"),"Current Week",IF(WEEKNUM({Flight Start},"Monday")=WEEKNUM(TODAY(),"Monday")+1,"Next Week"))To this:IF(WEEKNUM({Flight Start},"Monday")=WEEKNUM(TODAY

Hello all!I need help with a formula field. I believe I will need to use the IF function. Each week, I have to do math based on data input in 2 different fields and then multiply that number by a static field to get my total. I have to do this for 50+ records each week, so I'd love to save myself the time and energy and have my TOTAL field know which of my two fields it should compute against my static field. A screenshot is provided so you can see, and below is a little more explanation.Thank you for any help!Each week, some of the shows I am tracking are in preview performances and some are in actual performances, but never both at the same time. This number can change each week for either, and each show will start in previews then move to performances. I input the number of performances into the appropriate column, then multiple this by the {Production Seats} field to get my {Capacity}. Basically IF {Previews} has a number in it, multiply tha

Hi, I am hoping that someone might be able to help with a nested IF Statement I have a field that determines the size of an advert. I want another field to list the price for the advert based on the selection in the first column.This is the If Statement I created, but something is not quite right because it always shows the value £0.00IF(  {Advert Size}='Full Size','£100.00','£0.00',  IF({Advert ID}='Half Size','£50.00',  IF({Advert Size}='Quater Size','£25.00','£0.00'

Hi,I have a field that has my clients' phone numbers. I also have a RingCentral account that I make phone calls from. I would like to be able to click on the phone number and make a phone call automatically from the RingCentral app. Does anyone know of a link I can use directly in Airtable to accomplish this?

Hey all, first post in here. Has anyone else noticed that when creating a view and setting the filters (particularly on conditions relating to a date field that includes a time) there is no way to set the filter to read hours rather than days? My use case:- I want to set up a view to trigger an external automation (zapier) exactly 48hrs before a specific date-time- I set the filter to DATE = number_of_days_from_now = 2 However, that doesn't work as it doesn't include time in the calculation. e.g. DATE = 2023-09-19 16:00:00So then I want the filter to register a new row at: 2023-09-17 16:00:00But instead, it ignores time, adding a new row at: 2023-09-17 00:00:00 (as soon as it reaches the correct day basically) despite this being 16 hours early (but technically correct by 'days' alone).I've tried using DATETIME_FORMAT to extract just the time - but there isn't a way to

Sorry in advance if this has already been asked and answered a million times. Basic Situation - I am a bookseller, and my POS is a POS when it comes to order integrations. So, I have to create a bulk upload in a spreadsheet of hundreds of books per week. This is fine, it’s doable, whatever. But it does require a lot of tedious data manipulation which I am hoping Airtable can reduce. The Issue - I need to compare one CSV file (the Purchase Order) to a different CSV file (our item database) in order to see which books are new and need to be added to our system. If they are new, then I need to format the data to match our POS’s upload template. If they are reorders, I need to check if there has been a cost or price change. I can easily do this in Google Sheets with vlookup formulas, but, again, having to copy and paste and move things around between different worksheets has gotten old very quickly. The Question - Can I use Airtable to create a template

What is wrong with my formula that it is producing "#ERROR!" instead of an empty cell when {Most Recent Completed Event Date} is blank? DATETIME_FORMAT(IF({Most Recent Completed Event Date}, DATEADD({Most Recent Completed Event Date}, 9, 'month'), ""), 'M/D/YYYY') It is working perfectly for the ones that have a date in that field (e.g., if "Most Recent Completed Event Date" is 5/13/2023, it gives me 2/13/2024). If "Most Recent Completed Event" is empty, I want the formula to leave the cell empty, hence why I put the empty quotes as the alternative option. But instead, it gives me "#ERROR!" I tried looking up similar questions but I'm stumped. Thank you!  

Hey! I have 3 checkbox fields that indicate the completion of a task. I want to show completion of the tasks using the newly released progress bar on the Percent tab, but without having to manually type in the thirds (1/3, 2/3, 3/3). If I use a formula to sum up the checks as a third, then use another formula to make it into a percent, I still won't be able to get the bar since the formula field does not come with that feature. How do I get that % into the percent field without having to create an automation? Is that the only way, or is there an easier/simpler way to go about this?Thanks in advance 🙂   

Hi,I'm trying to figure out if there is a script or formula to allow for when cells are updated in a column of a Google Sheet to update a corresponding column in Airtable. Here's the scenario I have:I have a Google Sheet that is organized by client project and it tracks the number of project hours used. I'd love for when the corresponding client project's client hours are updated in that Google Sheet that it is updated in the corresponding client record field in Airtable. I see a lot of stuff for updating a Sheet based upon an Airtable trigger, but not the other way. And I know that there is a Google Sheets API to add a row, but that's not what I need either as no new rows are created, it's just a field being updated.Hopefully this makes sense. Would really love any guidance on this that someone may have.Thank you!Julie 

Does anyone know if it’s possible to generate a url in Airtable that would both prefill fields AND autosubmit the form. I would like to be able to send a client a link (generated from an Airtable formula) via e-mail, that once clicked, would submit an Airtable form automatically with prefilled information. In other words, clicking the link would take them directly to the form submission confirmation page. All they have to do is click the link (or button in the e-mail) and their form is automatically submitted. I know that this is now possible using Stacker.app, but I was hoping for a similar solution simply using e-mail. In Stacker.app they add "&autosave=1 at the end of the url, but this doesn’t seem to work for me outside of that app. I’m guessing that this can probably be done using a e-mail button or link with a Zapier webhook, but I was hoping to avoid that if possible. If there is something similar to the “&autosave=1” feature, that would be ideal.

I'm tracking book publications and each of the titles in my database will have several dates for different formats - Hardback, paperback, ebook and Audio...I'm trying to create a formula that will automatically select the earliest of these dates so that I can use that to trigger something else.I've searched other questions and found this:MIN(VALUE(DATETIME_FORMAT({Date Field #1},'YYYYMMDD')),VALUE(DATETIME_FORMAT({Date Field #2},'YYYYMMDD')),VALUE(DATETIME_FORMAT({Date Field #3},'YYYYMMDD')),VALUE(DATETIME_FORMAT({Date Field #4},'YYYYMMDD')) )I feel like this is partway there but because some books don’t have all formats some of these fields will be blank for some titles and where that’s the case I just get an error message. Is there a way to tell it to ignore any blank fields?Thanks 

I have an airtable that has the following data: [ { "id": 46, "createdTime": "2024-11-22T06:48:11.000Z", "Campaign": [ "rec1OnuA36COKk2rC" ], "Status": "Posted", "Account": [ "recFO8uEMB7wZaSYw" ], "External ID": "3914", "Created": "2024-11-22T06:48:11.000Z", "Last Modified": "2024-11-22T19:42:20.000Z" }, { "id": 47, "createdTime": "2024-11-22T06:48:35.000Z", "Campaign": [ "rec1OnuA36COKk2rC" ], "Status": "Posted", "Account": [ "rec6lTjVaKUR6gSuQ" ], "External ID": "urn:li:share:7265617134745976832", "Created": "2024-11-22T06:48:35.000Z", "Last Modified": "2024-11-22T06:48:35.000Z" }, { "id": 49, "createdTime": "2024-11-22T06:49:14.000Z", "Campaign": [ "rec1OnuA36COKk2rC" ], "Status": "Posted", "Account": [ "rech7SZ12yAqOSdmS" ], "External ID": "18114831709420263", "Created": "2024-11-22T06:49:14.000Z"

Is there a way to see which link was used to create a specific record? We use AirTable forms for surveys and have lots of different survey links. I’m looking for a way to see the specific form link that was used to submit that specific survey. Is this possible with a formula?

We're a publishing company and we keep track of content that we publish over the course of the year with these different columns showing publish dates. I'd like to do 2 things:Create 1 column that combines the dates (combining them so that they remain separate would be ideal, but otherwise, it could just be text formatted like this "MM/DD/YYYY, MM/DD/YYYY").Then I'd like to have another column that shows the oldest date and a column that shows the most recent date.Another column that just adds the number of times the content has been published, so counts the number of fields with a date in them.The error you see currently in the far right field had the formula that I tried on my own which was:DATETIME_FORMAT({Publish Date 1}, 'MM/DD/YYYY') & "," & DA

Hello. I'm trying to create an IF formula that returns some text if the date field is a specific date. Each date would need its own specific text.e.g. If my date field was 05/01/2025, then the IF formula field would return specfic text (e.g Day 1).The bit I'm struggling with is doing this with lots of IF formulas in the same formula field. (I need about 47 different dates each returning their own specific text. Is this the easiest way to do this or am I missing a trick somewhere? Thanks in advance. 

I know there has to be a solution for this, but I just haven't found it - trying myself.Pretty Simple I'm trying to make a simple purchase/expense tracking table for the different program team since we're an NPO and have to account for what is spent in the programs as part of the audits, especially with grants.  Each program has a specific budget amount.In excel this is a piece of cake.Fields are that I need to be able Deposit  (Field type Number: Currency)Expense (Field type Number: Currency)Row Charge (Formula)  [Deposit - {Expense Charge}]I now have two fields  that are formulas that I just can't figure out how to make workEnd Balance [{Current Balance} + {Row charge}]Row 1 has End Balance and I want to bring that information into a field called Current Balance which starting Row 2 would auto popu

I have automated the responses of our NPS survey into my Airtable Base.I have one row showing me what the people have clicked on, on the scale of 0-10. And I have one row showing me what this means as "NPS" value, here is an example:NPS Scale Vote | NPS 10                        | 1009                          | 1004                          | - 1007                           | 08                           | 0Now I would like to add another row that shows me, whether someone is a Promoter, Detractor or P

Hi all, Hoping someone can help with a solution! My company has numerous assets that are “active” for long periods of time. I have a formula to calculate the “Active Status” based on the Asset Launch Date & Asset End Date (see below for reference). I would like to make an additional field that lists ALL dates an asset is going to be active based on the start and end dates (placeholder included in the image above). For example, if Asset Launch Date = 9/1/22 & Asset End Date = 9/5/22, I’d like the ALL ACTIVE DATES field to read: “9/1/22, 9/2/22, 9/3/22, 9/4/22, 9/5/22” Note: This field would be hidden 99.9% of the time and ONLY used in an Interface Filter element to allow users to type in specific dates (i.e. 9/3/22) and see the assets that will be “A

Hello everyone,Newbie here! I'm trying to create a base that can track all the annual membership payments and also send them an automatic email 2 weeks before the renewal date (based on the MEMBERSHIP JOINING DATE) is due, plus two more reminder emails with intervals of 2 weeks. I only have 1 table to work as I can't figure out how to implement it if I create another table within the base. So the VIEW that I have is Annual membership fees. In that view, I have theMEMBER'S NAMEMEMBERSHIP JOINING DATE20232024I really want to have a current year renewal date based on the Member's membership joining date (column) but I don't know the formula.Then use that as the basis trigger for my renewal notice email for the members. Plus two more follow-up emails.Until they have the PAID mark on the current year. I hope I make sense. Thanks in advance for your help.  

Dear communityI need a formula to sum number rows. This seems a bit difficult, but maybe I'm just dumb...I just need to summarize #Beløb F and #Beløb S into #Beløb. I am doing it manually right now.Basically: #Beløb F + #Beløb S = f BeløbCan anybody help?Uffe, Klassiske Dage, Holstebro International Music Festival

Using the NOW() function in a formula no longer updates the time reliably, even after refreshing the base. It only returns the original time that the formula was created, but then it doesn’t update reliably beyond that. I’m specifically referring to a formula that just has this as its formula: NOW() I’ve noticed that within the last few days, this brand new disclaimer was added to the formula reference page for both the NOW() function and the TODAY() function: ***The results of this functions changes only when the formula is recalculated or a base is loaded. They are not updated continuously. Forget that this sentence has several grammatical errors in it. :stuck_out_tongue_winking_eye: The real problem is that the described behavior is incorrect. (And the behavior has changed on us.) I created this formula: NOW(), and it starts off with the current time. But then, I refreshed my web browser ove

Hi,I want to have in one column the data from the remaining selected text, lookup and line items, fields which will be formatted in html. I managed to partially achieve the desired effect, by using the formula type But unfortunately data is not presented correctly. This is my formula. <li-code lang="markup"> "<table><thead><tr><td>Składnik</td><td>Zalecana dzienna porcja do spożycia: " & zdd_pl &"</td><td>*%ZDS</td></tr></thead><tbody>" & "</tbody><tfoot><tr><td colspan="&"3"&">*%ZDS - Zalecane dzienne spożycie. | † - Nie ustalono zalecanego dziennego spożycia.</td></tr></tfoot></table><h3>Składniki:</h3><p> " & wszystkie_skladniki_pl &"</p><h3>Alergeny:</h3><p><b><u>" & alergeny_pl & "</u></b></p><h3>Stosowanie:</h

I have a formula field containing NOW() and nothing else. The field is showing the wrong time. Right now it's 3:02 a.m. in the desired time zone (Eastern Daylight Time), but the field shows 2:59 a.m. I've attached a screenshot showing the difference between the displayed time and my computer clock.Weirdly, when I first set it up but hadn't yet changed the time zone from GMT, it was 2:59 a.m. but the field showed 6:03 a.m.Is this a known bug? I need this field to calculate the difference between when an item is due and the current time (that is, how many days/hours until it's due), and the time does need to be accurate to the minute.