Formulas

Hi - I am trying to build an IF(OR statement that returns a value if any of the fields are blank. The way it's currently written returns COMPLETE even though some fields are blank.Here is what I have so far: IF(OR({Premiere Project File - RBs}=BLANK(),{Delivery instructions}=BLANK(),{Final Viewing Link}=BLANK(),TRT=BLANK(),"INCOMPLETE"),"COMPLETE") 

Hello,I have been looking at the boards for hours now and can't seem to find the formula I am looking for. I have it in Excel however, the formula does not work in airtable. =DATEDIF(0,C2,"Y") &" Years "&DATEDIF(0,C2,"YM")&" Months "&DATEDIF(0,C2,"MD")&" Days "Ideally, I would like to take out the Total Days part and just get the Breakdown from the Start Date. At this point though, either way would work. Can someone please help me out with the formula. 

I hope you're all well. I have a question to ask you, I would like to create a progress bar that summarises all my subtask using checkboxes. Basically, each time I check all the checkboxes in my subtask, the progress bar shows me 100%.Is this possible? Can anyone help me? I'm looking for something like this : 

I'm building a dataset where i'm taking the total amount of something and breaking it down into a per day calculation.  However on the first couple of days these projected calculations aren't always hit.  Is there a way to build a formula that takes into account a ramp up period of some kind for the first couple of days?Here it is in practice:A brand wants to have a certain amount of budget set against a specific website that they're advertising on.  The budget of $100,000 over 10 days, or $10,000 / day. However in reality, hitting $10,000 in the first day or so is nearly impossible because of certain elements that need to be taken into account.  This is the ramp up period.  In reality it starts off with $1000 for day one, $3000 for day 2, $7000 on day 3, and then hitting the per day spend goal of $10,000.  Sometimes to compensate for this the website may over-spend on Day 4 and 5 to bring the average back to $10,000 a day. Is

Hey there! 🙂I have a "Customers" table and a "Projects" table and what I'm trying to achieve is to link them. I wan't to know which customer were in each one of my projects, so a costumer may be in more than one project aswell a project will have more than one costumer. To do so, I created a linked record column and what I'm trying to do is to copy the costumer's name (it'll be roughly 100-200 rows) and past them in just one cell in table Projects (to link those 200 customers to that specific Project in the row). Is it possible? There's any better way to do it?

Thanks in advance for any help, I am new to Airtable and to using formulas at all. Having trouble figuring this one out, but I’m sure it’s a simple solution. Context: I grow mushrooms, 3 different strains (K, B, L). Every day I prepare a new batch (8 bags, same strain). Every week I prepare 5 batches, 1 batch per day, mon–fri. I need to create a unique record for each batch. Currently, I am using a concatenate formula to combine the strain code (K, B, or L) with the week number it was created. i.e. K.40 My Problem: 2 days of the week, I will repeat the same batch (strain type) I did earlier in the week, which leaves me with two instances of the same thing (K.40). I need a formula or combination of formulas that can identify when the same batch code has appeared twice in one week, and then assign only the second instance of that occurrence with a (.2) i.e. K.40.2. See screenshots below for reference:

I’m trying to create a formula field which calculates the number of days in a specific month between two dates. For example, the date range 2020-01-27 to 2020-03-12 has: 5 days in January 29 days in February 12 days in March So in a formula field calculating the “January Days” between the two dates, the value would be “5”. This has me utterly stumped, can anyone help?

Hi! I'm pretty new and having difficulty figuring out the logic of how to write this: (single select) Status = "review 1" or "review 2" (Long text) Feedback must not be blank If the above is true then it should provide an output of - "Ready!"And then preferably the errors can drill down to the exact issue..If the status is neither of those - Error, wrong status! If the feedback box is blank - Error, missing feedback! This seems simple but I can't seem to figure out the correct formatting to return correct results. Help appreciated 😄 

I use Airtable for my business and have my customers fill out a form with their info. For the Address column I currently have it as a single line text and that is causing issues. Customers are filling it out is '10 whalen rd' instead of "10 Whalen Rd Rochester NY 14608". I have the field as required however because it is a single line text I can't force how the address is implemented. How can I fix this?

Can anyone spot any glaring mistakes in this formula? The more expressions I add on, then it 'saves' but then overrides with a simpler version of the formula... so assuming there's an error but I'm not seeing an error message and it's infuriating me (facepalm)There are some fields that need to reference themselves if they are not empty, the rest need to refer to another column if column A contains ***OTHER CHARITIES*** I've been going round in circles for a while now and losing the will 😄 IF({Charity Selection -Series and Challenge Charity Partners 2024}!='', {Charity Selection -Series and Challenge Charity Partners 2024}, IF({Charity Selection - Mixed funding 2024}='***OTHER CHARITIES***', {Other Charity Selection - Mixed funding 2024}, {Charity Selection - Mixed&nbsp

Hi everyone,I was wondering if we would be able to automatically add an URL as an "URL-Attachment". This way I would be able to fetch a QR Code image and have it in my table.I could not find anything online. Unfortunately I can't install extensions that are not directly from Airtable. Thanks for your help,Eren 

@Sho answered my first URL audit Find formula question: My followup question/challenge:I want to clean up (not just identify) the {Link URL} field and join it with {reftag} field:Addmissing https://and/or missing "s" in http://Removeinvalid characters; e.g., ' §the following querystrings:?ref= ?ref_=&ref=&ref_=Then join two fields ({Link URL} & {reftag}) based on logic:If {Link URL} Does NOT contain '?' append {Link URL} with '?ref_=' & {reftag} fieldIf {Link URL} contains '?' append {Link URL} with '&ref_=' & {reftag} fieldHere is the original solution used to callout errors in th

I am attempted to pull 1 item of information from a table to use for a formula in another table. The referenced table has 1 field and 1 row only:I want to use this value in another table with a lot of records for a formula. I have attempted to link the 2 tables together: Then created a field for the value:The column has the value of 0. What am I missing here? TIA!

Hi, Is there a formula that could handle removing urls from a long text field and keeping the rest of the text?I have been playing around and am not able to achieve this so far. I need to omit any string of text that starts with any of the following 4 but keep the rest of the text in the field:%/IF% %F<https httpsThanks! 

Let's say we have a row with a product & prices for that product at four regional stores:Chocolate BarStore A: $1Store B: $3Store C: $2Store 😧 $5I'd like a formula that would look across the store prices, determine the highest price, and then return the name of that field. I want a function that would return "Store D" in the example above.MAX(Store A, Store B, Store C, Store D) will help me identify the highest price, but it returns the $5 value, not the field name Store D. How do I get something like MAX returning the winning field name?Thanks!

I'm building an issue tracker leading up to a one-day event. Issues are reported, and then I need to track how long the issue has been open. Most issues are closed in a few minutes, but others may linger for hours, or even days.I can calculate the number of minutes since the issue was opened, but how do I convert that to a duration-like result that includes days? Sort of like a DD:HH:mm format.This is how I calculate the elapsed minutes:  DATETIME_DIFF({Resolution Time}, {Call Time}, 'minutes') * 60

To group records for planning purposes, I use a unique code for each record, then a custom text field to assign one of those codes to records that need to be grouped. This is for planning vegetable plantings with multiple vegetables in a plot. Here's an example of how that works:Where ID + Field Date is generated, and then I manually assign one of those codes to "planning ID" where those crops need to be considered as a group for certain planning activities. For planning purposes, I have a view that groups crop/records by planning ID. I also have one that sorts by crop in alphabetical order. However, I need a visualisation that does both - e.g. I need to be able to sort by crop AND visualise the other crops that are grouped by the same planning ID. I don't necessarily need an easy link to those other relevant records, bu

Hello,  I'm working on an inventory system.  Paired with AirPower, it connects to our shopify storefront to upload on the base what we have in stock on our website.  Once I get this finalized, it will also work in reverse.  We have individual items and then packages with multiple different items within it.  I have made a separate tab with Compositions for my mixed packages based on this discussion.    Thus, with sticking in the structure of Airpower, I have one tab for ALL products, one tab with variants that holds the inventory, and another tab (Compositions) that connects all the individual items (within variants) to its mixed packages (also within it's variants) and associates individual item quantity in each package.  All this being said, I now am coming to a standstill.  I

I'm trying to calculate return rate (items received/ items delivered),  but aggregate them by day.  However, there are multiple receiving lines for each event, and only one input for items delivered.  I'd normally do a formula based off a pivot table but I'm not sure how to do that in Airtable.Here's an example of the table I have Event NameItems ReceivedItems Delivered Timestamp 1x1040 Timestamp 2x20  Timestamp 3y4050 

Hi,I have a base where we I need to return the lowest value possible value for items that share a unique identifier (this is generated for each record and only some overlap) AND the same quantity. For example, say I had 4 records that generated their identifier to 101A, with quantities of 200, 300, 400, 500. For All of these records, I need a field that returns the minimum quantity (200) for each record with that matching ID ; and will work with possibly thousands of unique identifiers. I thought this would be an easy formula, but cannot seem to make this function whatsoever. 

Good morning!I am trying to determine how much I am making per hour at various markets that I vend.I input my markets with a start date+time field and an end date time field and have that calculate out to a duration field.       I also have my earnings field (which is what I made minus event fees, also calculated

I am trying to use the find formula to identify one or many issues in a URLFor example in the field Link URL I have two urls; one with one issue and one with multiple issueshttps://www.google.com/workin'-late.htmlorhttp://www.google.com/workin'-late.htmlAny help would be appreciated. Here was my first go at it:IF({Link URL},IF(FIND("http://", {Link URL}), 'missing https',IF(FIND("'", {Link URL}), 'remove apostrophe',IF(FIND("http://", {Link URL}),FIND("'", {Link URL}), 'missing https and remove apostrophe'))))

I want to calculate the difference between 2 dates. One is the purchase date of a condo and one is the sale date of that condo. I need the number of years and months to figure out refunded common charges at closing. I have the formula working for years or months. But can it be both? If not, anyone have experience in this scenario and their solution? And in the same formula, the field shows NaN if there is no data in one of the fields. For current owners the buy date will be populated, but the sell date will be blank. How do I tell the formula to leave the field blank if one field is blank? Thanks in advance for any help on this. Best, Scott

I am trying to solve the problem that I have illustrated in the image below. I am trying to create/calculate (see image) {Rate} and {Day Total}. In the below example, the first record for "Old Cypress - Weaned Calves," if the "Weaned Calves" == "Pasture" then pull in the value .70, and then multiply that value with the "Inventory" of 450. This will result in a "Day Rate" of $350. Any help will be appreciated! Thank you! 

I'm trying to get two conditons from two fields that contain certain text that if True produces a duration value.  I can get it to work work one condition but when I add the second it will not work.  Can someone see what I'm doing wrong? This Formula works: IF(FIND("ABC",Origin),3600,0) But when I add the second condition it shows all 0's on the fields that contain "ABC" and the fields the doesn't contain"ABC" gets the 3600: IF(AND(FIND("ABC",Origin)),AND(FIND("New",{L