Formulas

Hi!Right now I get an #ERROR in Column A when the date is blank. However, I'd like it to return "N/A" instead.The formula below still results in an error.  What do you suggest?IF({Formatted Date},CONCATENATE({Formatted Date}," - ",{Event/Release}), "N/A")

I would like to do what was accomplished on this thread except to add the additional steps of updating another row in another column once the loop reaches a specified number. Please see the picture for reference on what I would like to accomplish:

Hi,How should I write the IF function to calculate commission based on A or B ? See below:If Take Rate is filled: Commission = GMV x Take Rate %Otherwise: Commission = GMV - Achat DistributeurThank you    

Hi,In one column I want to get shown a trend more obvious with colours.So I want the difference to the week before and in this case a green or a red broken heart.But somehow I am not allowed to put the heart at the front and the difference at the end ...(se result: NaN) 🤔 🤔Any idea, what I cannot see right now?Best regards,Martin

Have you integrated your Airtable bases with a backend data service/database/or used Integromat to draw information for other bases? Can you help with the below? We’re a GAAS platform that use Airtable to execute various company wide and customer requirements. One of these specifically is how we execute growth projects for customers. We have a central project template with predesigned workflows that we rollout for each customer project. One problem here is that version control gets hard to manage given that Airtable doesn’t allow you to create parent/child templates, ie so you can deploy changes to a template to all active projects that utilise that specific template. As a means to deal with part of this problem we’d like to build out a backend data service that would enable us to pull in generic information into a base and keep that part at least centralised. An example use case: A user on the project team creates a new experiment within the relevant tab on a project base. They will

Hello,Thank you in advance for your help. I explain you my project 😃I am in charge of a product sourcing agency.I need to make a catalog of my products, but I need to be able to change the price of the product depending on the country of delivery.Example:Product 1 : USA : Price 10 DollarsProduct 1 : FR : Price 15 DollarsProduct 1 : CA : Price 20 Dollars.If you can help me with this it would be great 😃I don't know how to do it, with a select single maybe?

What is the excel index match equivalent in a table?

Hi there! I'm new to Airtable and trying to figure out how everything works. Let's say I have a cell that as the following information I inserted below: Beef Onion Burgers with PicklesIngredients:2 hamburger patties1 onion, diced2 tablespoons ketchup4 slices pickles2 hamburger bunsHow can I separate all of the text to the left of the word  "ingredients" into one cell? I basically am trying to extract the name of the recipe into its own cell.

Hi all, does anyone have a formula to calculate Stamp Duty Land Tax (UK) in Airtable? I attach the Excel formula that I previously used. =SUMPRODUCT(--(A1>{125000;250000;925000;1500000}), (A1-{125000;250000;925000;1500000}), {0.02;0.03;0.05;0.02})+(A1*0.03)Thanks in advance!

I have a table called 'accounts' and another one called 'users' linked to accounts in a one account to many users relationship. I want to create a field in the table users that shows an array with all the other users in that account except themselves. I wonder if airtable would allow me to do that?I have tried with a rollup but I don't know what to enter in the aggregation formula to exclude the user in the record, so I get a list with all the other users in their account.

Would anyone be able to help me adapt the following formula to Airtable?N = –[ln(1 – [(PV * i) / PMT_] ) / ln(1 + _i)]N = Number of months remainingPV = Present ValuePMT = Payment AmountI'm struggling with an otherwise simple operation because I'm not sure how to account for the natural logarithm in Airtable. I'm ok with something that gets close enough, because the idea is I just want to arrive at an estimated payoff date. Doesn't have to be 100% accurate, just a decent estimate.Thanks for any insight.

I currently use the following formula to produce a unique identifier in my my primary field: "PHDEV-" & {Fx_Year} & "-" & REPT(0,3-LEN(CONCATENATE({Fx_Autonum}))) & Fx_Autonum This works as intended, but I'm at a loss understanding how I might expand this formula to do the following:  1) use a different autonumbering value for records based on a field value (e.g., if location is "PA", add suffix "-PA" AND autonumber, and if location is "MA", add suffix "-MA" AND a different series autonumber. Because I'm currently relying on the field formatted to autonumber to add the number, it will issues numbers like 001-PA, 002-PA, 003-MA, 004-PA, 005-MA whereas i want it to number those records as 001-PA, 002-PA, 001-MA, 002-MA, 003-PA 2) reset the numbering count when a new calendar year is present. Is this possible? or will i need to create a new tab for each location/year? Thanks in advance!

Dear Airtable community,I have read all the posts on the Arrayunique function, and I still have not succeeded in presenting Member Names with no duplicates.Table 1 : Tasks with a multi-select field to describe who is in charge of that task. Tasks are linked to Projects. My Table 1 looks like this :TaskID | Multi-select Field Members      |  Link to Project  |  Lookupfield from Project : Members |Task1      Member1, Member2, Member3                 Project 1                   Member1, Member2, Member3, Member2Task2     Member2                                                 Project1                    Member1, Member2, Memb

Hey there,I need some help with my airtable. I know it's possible but I'm relatively new and eager to get into database work. I'm now working on a database for my record label and want to create reports for my artists regarding their streams that they can get via a monthly e-mail that I will later automate. I'll break down the workflow to better explain it. And here is the Airtable for you to look over: https://airtable.com/shrQtfIpRU8JlMScQ1) At the end of every month. I got to the Music Distributor's dashboard (MDD), which only I have access to, and go look at the stream count for the selected period (every month). The table that is presented is each individual track NOTE: I cannot filter the table in my (MDD) meaning the order in which the tracks are presented is only based on stream count. So the order is ever-shifting.2) With a plugin, I scrape the HTML of the MDD's table and convert it into csv and import it into airtable as a new table, "Month YYYY." Meaning each month has

I have a cell containing values that are semi column separated and have a value after the :How can I split this info into multiple cells?IDLocations1location A:1,Location B:3, Location C:92location A:4,Location B:10, Location C:44I know all Locations, so I can pre-create all needed columns if this would be necessary (beter if it can be done automated of course). How can I automatically copy the info to the right columns?So needed outputIDLocation ALocation BLocation C1139241044Any idea how to achieve this? 

I'm pretty sure I've seen this covered before, so forgive the reposting. I want to create a field that generates a flag icon/emoji if a checkbox field is checked.I'll use this to add the icon to my field title (using Concatenate) so it draws attention. I've done the same thing using the SWITCH formula, but I can't figure out how to do it with a checkbox field.TIA! 

Hello! I have 4 date fields, and for a given record, any of the 4 could be filled in (or several of them, or all of them). I've written a formula to return 'Y' if any of the 4 dates fall within the current week. Here's what I've got:IF(OR({Date 1}, {Date 2}, {Date 3}, {Date 4},IF(OR(((DATETIME_FORMAT({Date 1}, 'YYYY')&DATETIME_FORMAT({Date 1}, 'WW'))) = (DATETIME_FORMAT(TODAY(), 'YYYY')&DATETIME_FORMAT(TODAY(), 'WW')),((DATETIME_FORMAT({Date 2}, 'YYYY')&DATETIME_FORMAT({Date 2}, 'WW')) = (DATETIME_FORMAT(TODAY(), 'YYYY')&DATETIME_FORMAT(TODAY(), 'WW'))),((DATETIME_FORMAT({Date 3}, 'YYYY')&DATETIME_FORMAT({Date 3}, 'WW')) = (DATETIME_FORMAT(TODAY(), 'YYYY')&DATETIME_FORMAT(TODAY(), 'WW'))),((DATETIME_FORMAT({Date 4}, 'YYYY')&DATETIME_FORMAT({Date 4}, 'WW')) = (DATETIME_FORMAT(TODAY(), 'YYYY')&DATETIME_FORMAT(TODAY(), 'WW')))),'Y', 'N')))I added the first IF(OR( argument to allow the second IF(OR( to run, no matter how many of the date fields have data in

How would I go about setting up a formula that only activates IF a checkbox is checked?If I have selected a checkbox, I want the total to be divided in half, otherwise, I want to keep the whole total as/is

Hi, please help to understand whether it is possible to implement the following:On the screenshot, there is a table in which data about the status change and its time are entered via a webhook. I calculate the duration between events. Now I need to make a report for the previous day, in which I indicate how many hours the status was online and how many hours the status was offline.@kuovonne can you help?

Here’s an examnple of what i’m trying to do One cell has a single select item to choose from… In this example i will say i can choose from “A” and “B”. if i choose “A” then the cell to the right of that would change the single select items in that cell, and allow me to choose either “blue” or “green”. if I choose “B” then the single select item dropdown changes and allows me to choose the colors “red” or “orange”. Is doing something like this possible?

The field entries are £20.49 and £13.66 (both fields set to 2 decimal places) but in a third field when I use CONCATENATE this is what I get:Summary: Headline £15000 pa Actual £9975 pa £20.491666666666667 £13.661111111111111How do I get £20.49 and £13.66 ?tiaps - I daresay this (sort of) question has been asked before but I have no idea what to search for. 

Hey,I want to do a simple if statement to show TODAY for the date today. It works for a date field but not for a rollup date field. IF({Date Rollup (from Stock)}=TODAY(),"TODAY","")

Not sure if this is a air-table or zaiper question hopefully someone can explain to me. This is what im trying to do:Uploaded video To frame.io where the name of the video is the same as a Unique ID in airtable ( called Asset ID ) in Airtable search for a field ( Video Edit ) Input text or link  to inform that video has been uploaded I have tried to find the record using a search function and my zap looks ok but when i run it it does not update to the correct field.when i test the last part of my zap ( input text ) it will only place it in the first record and not the one attaching the unique ID i have tried the following SEARCH functions also FIND SEARCH(({Asset ID}))!={Edit}SEARCH(({Asset ID})) = {Edit}not sure if it is that or when i go to set up my action in the RECORD section i am picking the wrong dropdown.i thought it may be “custom” “zap search was found” but didn't work , and i have also tried multiple other options  any input would

Hi guys and fellow airtable experts. I am creating an inventory system in airtable with a stock receipt table that will record any changes to my main table's item stocks.  It can be additions if I receive goods and subtractions if I sell away the goods.Main table has a list of items.Main table fields:item namestock quantityStock Receipt table has a list of stock receiptsStock Receipt fields:stock receipt name (text)date (date)item name (linked to main table's item name)quantity adjusted (number, can be pos+ or neg-)  How do I make it so that when a stock receipt is created, airtable automatically compares the stock receipt entry and updates the main table's quantity for that item? E.g. Stock of item was 10. A stock receipt was created with quantity of" -1".  new updated stock of item is now 9.

Hello, I've looked everywhere and can't find a simple solution that works for me. I have a table where I link records and I want to take the linked records field and split it by comma and input those items into it's own field. Can someone please give me a formula to input into the columns?