Formulas

Hi all,The problem I'm seeing is when I use the formula below, the recurring date shows up properly in the current year, but one day to early.DATETIME_PARSE(DATETIME_FORMAT({Recurring date},'MM/DD')&"/"&YEAR(NOW()))This 3 minute video I made shows the problem:https://www.loom.com/share/913091fb457b424b9836b6369c75bb10 I realize the problem is likely caused by the Kamillionaire calendar block not considering that 12am (midnight) is really the current day vs. the day before. So my work around I'm hoping for is to modify the formula to show a time after 12am, like for example 6am. Kamillionaire site:https://kamillionaireapps.com/ Thanks in advance for any suggestions,Kelly  

Hi all, I’m building a client portal, where tasks would be executed according to their priority.The client will assign priorities to their tasks to designate the execution queue.The task priority should be unique and shouldn’t overlap (doubling).Example:Priority values are: “1st in queue”, “2nd in queue”, “3rd in queue”, and “4th in queue”Three tasks in the pipeline:Task_X has priority “1st in queue”Task_Y has priority “2nd in queue”Task_Z has priority “3rd in queue”A client created Task_AAA and prioritized it to “2nd in queue”The new tasks order would look following:Task_X has priority “1st in queue”Task_AAA has priority “2nd in queue”Task_Y has priority “3rd in queue”Task_Z has priority “4th in queue”Any thoughts on how I can achieve this?

I want to have a unique ID for single and multi-select fields so that I can use it with formulas and automation, without scripts.

Hey friendsI have 2 tables that are divided into 2:1. A table of all the leads.2. A table of people who paid.I want to create a column that will check in table 1 whether a certain email of a record appears in table 2 and if so - to add a V in this column.How can this be done?I tried the option of linking but it only connects the leads for me and doesn't do a check on all of them.Thank you. Attach photos.

Hello,I'm new to logic formulas and need some guidance. I have an AT to track company orientations. I have three columns- {Start Date}, {Orientation Complete Date}, and {Orientation Status}. I would like to create a formula for {Orientation Status} to show "Complete" when {Orientation Complete Date} is filled in, "Almost Due" when {Start Date} is within 14 days of todays date and {Orientation Complete Date} is empty, and "Overdue" when {Start Date} is after 15 days from todays date and {Orientation Complete Date} is empty.Any help or a link in the right direction would be appreciated!

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?