Formulas

One of my fields has a copy of a record that should not be there. Is there an operator or formula that will find the two records which are NOT unique?I did a simple search for 'copy' - that did not work. Any other suggestions are welcome.Thx.

I have 2 tables: “Home Staging Projects” and “Inventory Items”. In the “Home Staging Projects” table, I want to vlookup on the “Project ID” and return the sum total of “Rental Price” for each inventory item selected for that project listed on the “Inventory Items” table. I hope that makes sense.I’m not sure if this makes a difference, but the “Inventory Items” table is linked to the “Home Staging Projects” table by (formula) “Project ID”.Is there a way to use a formula for this?

Hello, I've looked around for an answer to this but haven't found one yet, apologies if I've been looking in the wrong place or the answer is obvious.My airtable has a list of filename prefixes in one field and a corresponding number of files in another. The prefixes are formatted something like this: item-01, and then there would be a file count that can range up into the dozens. What I am hoping to do is use those two fields to create a file name list. So if the file count was 2, I would want a list that would go something likeitem-01-001.tifitem-01-002.tifThis data would then be output to a "filenames" tab in the airtable. Is this doable? I am not good with formulas so I've been trying various solutions using linked records and automations but I haven't had any luck. Thank you for reading! 

Hello - I could use some help with a formula or automation to get what I'm trying to achieve to happen.We have job numbers that are coded as follows:23 = year1 or 2 = office identifier0001 = job number for the yearExample: 2310023 What I need to happen is the next sequential 4-digit job number to be added to the year and office identifier each time a form is submitted to create a new record, and it needs to reset each year so that on the first '24 job, it starts over at 0001. Does this make sense?

I’m looking for a way to take a duration field (eg 1:32) and show it as “1 hours, 32 minutes” like with text. I’m imagining there might be a formula I could use, but I’m not sure the best way to go about it. Any thoughts would be great!

Hello, I want to extract from the rollup field "noms des participants" only one of these data for which appear in the fields "Nom Prenon 1" "....2" "....3" "....4" ..... VUE https://airtable.com/shroD4pRoA52pXcg6Thank you for your helpFranck from FRANCE 

If I make multiple selections from a dropdown list is there a way to associate each of those selections with a specific selection from a different multiple selection field? Using the existing Product Catalog template as an example it is easy to understand what my issue is..... If I choose two+ items from the multiple select "Materials" field (ex. "Light Wood" & "Metal"), then choose one or more colors from the multiple select "Color" field (ex. "white" "brown" "black") I have no way of knowing which color is associated with which material. Is there a way to differentiate between having a "Light Wood" in "white" "brown" and "Metal" in "brown" "black" "white"?

I'm trying to format Canadian postal codes. Often the person enters them as k0e1b0. I need them to look like K0E 1B0. UPPER({PostCode}) will make them upper caseREPLACE({PostCode},4,0," ") will put the space in the middleHow can I do both of these steps in one formula field?

Hello, I'm frustrated! For nearly two hours I've been looking at Airtable documents trying to achieve what I could do in five minutes with a spreadsheet using the filter or query functions. There are a few recent posts on the same subject but each case is slightly different and I'm too frustrated to focus for long. Soon I need to go off to my paid work having spent the entire afternoon on this.I've got one table with a list of unique place names in the primary field along with related data, I want a second table in the same "base" (I think that's the word) to display all places with specific matching data. For example, list all places in a specific region where the region is specified in another column of the first table.Maybe linked records or lookup or both are what I need, or neither. Nothing is clear. I follow the advice in videos and articles then in practice half the time the option to lookup for link a record isn't even shown.If it's possible with Airtabl

Hi Everyone,I'm new to Airtable and formulas and have a pretty simple formula that is displaying a hyphen as a result of a calculation of zero, instead of the number 0. I admit I borrowed the formula originally from one I found on here, but not sure why the number I've designated isn't being displayed.It's not a true numeric calculation, but a replacement I'm using to give a numeric value to a field that also has text for ratings, i.e. 3 - Exemplary, etc., so that I can total up all the ratings from different categories and assign a value.Here's the formula:    IF( {Field1} = '0 - Deficient' , 0, IF( {Field2} = '3 - Exemplary', 3, IF( {Field3} = '2 - Accomplished', 2, IF( {Field4} = '1 - Developing', '1', 'Out of range' ) ) ) )    I personally have no idea why the formula shared was nested and if that has something to do with it, bu

Hello All,I need to migrate all of my records from an old base in to a new base.  The records in the old base have been assigned a number (through Auto ID plus a formula).  We are leaving the old base behind, importing all of the records in to the new one base, and resuming work in the new base.  I am trying to figure out how I can have Airtable resume number sequencing from where we left off in the old base and continue in the new base.  The new number sequence does not have to start exactly where the old one left off, and i cannot have the Auto Number feature assign a new number to existing records that I have imported.For example, we use Airtable to create and track projects.  Whenever a project is created, we have a summary field formula that takes the Auto Number (in this example 50011) and joins with with the prefix PR- (making it PR-49998) and also joins it with the project name (again in this example it is Organic Social Retainer - TEST

I have multiple values in two separate cells located within the same row. My objective is to subtract the first value from the "Stock" column from the first value in the "Quantity for Production without Units" column, and continue this process accordingly. Finally, I would like to place the result in a third column.So it would be something likeEstoque          Quantidade para produção sem unidades          Estoque-Consumo46200                              6000                             

Hello Community, please help to solve in an elegant way!I have record, and in a field called "FOOD" I have text separated by comma, let's say in the text I have"FOOD" = Apple, Carrot, sausageI then have another table caleld "FOOD CATEGORIES" with all the food separated by categories like (Can be a table for each category, same situation):Apple - FRUIT Banana- FRUIT Mango- FRUIT Carrot - VEGETABLEZucchini - VEGETABLEPotato - VEGETABLESausage- MEATBeef- MEATChicken- MEATIceCream - DESSERTCheescake - DESSERTCandy - DESSERTSo now I want that in the field next to the field "FOOD" will be a field called "FOOD CATEGORIES" where it will appear the food categories according to the table classification, the previous example, I want to see CATEGORIES FRUIT, VEGETABLE, MEATAt first I tough I could do with a super concatenation of IF, but seems not very elegant app

Hi Airtable community, first time posting here. Thanks for your help in advance.So, I'm trying to create something like YC Startup School weekly update forms: every new record will be named as "[Monday of the week of {created time}] - [Sunday of the week of {created time}]". Just like this:I'm very new to using formulas, but would really love to learn how that works.Tried "Weekday", "Dateadd"Got stuck right here. Thanks a lot! 

Hi !I'd like to substitute the "€" symbol only when it's alone in a field. (alone but with a space in front)For example, I've sometine a field with :1.00 €2.00 €€€€and it's very ugly in our contract.  ><I thought at the "LEN" and "FIND" formulas but I struggle to not replace the € when it is accompanied with a number... It would require a formula that only searches and replaces € symbols when it is alone with a leading space.Any ideas will be greatly appreciated :-)))) Thanks !

Hi .. Hi. How can I show 'next week day' . I know.  DATETIME_FORMAT(Date, 'dddd'). but anyway I can how 'next Monday' ?

I could not find a solution for this in the forums: From a list of dates, I need to find that date that is the last date on that list before the launch date of a given project. The idea is to find the date best suited for an event to happen before a project is launched.Full description:Records in table "Status" are each linked to one specific "Project" and one specific "Outlet". "Status" looks-up the launch date of that project. In "Outlets", multiple dates are rolled-up from a table called "Release dates".I am looking for a formula that returns the one "Release date" that is closest, but not after the Launch date of the Project. The returned date must be in the "Status" table.I cannot use conditional look-up, as the date I need to compare with is not relative to today, but referenced elsewhere. So no way to use a relative condition like "before today" or so.I have transformed the dates in to Unix timestamps already. Mathematically, the date

I need to get the price from another table and bring it to my booking table. The conditions must be based on the company and the route to bring the correct sale price registered in the Routes Price table,My airtable system is already working and I use the Company field as a lookup for the Customers table and the Routes field is just a single select.However, today, to form the sales price, I use the supplier's cost price, but this needs to be changed and the sales price needs to be added manually in another table to later appear. If customer is A and route is A show this price If the customer is B and the route is A show this price.

I have no idea how to make the title succinct and easy to understand, but here's what I want to do. I run a market garden. I am building a crop planning tool inside airtable. Throughout the year, the typical timings of events for different crops will change.For this example, we'll use my Weeks to Harvest calculation. In peak summer, lettuce will be ready to harvest 4 weeks after transplant. In the darkest part of winter, it'll take 8 weeks.Now, there is not a cut off date where suddenly it goes from taking 4 weeks to 8 weeks. So I want to be able to store the following data against a crop1) Fastest weeks to harvest (peak summer) - e.g. 42) Slowest weeks to harvest (dark winter) - e.g 83) Fastest date of the year (based on transplant date) e.g. Jan 14) Slowest

I run a table that keeps track of content my team creates for a digital billboard. When we hear about new content, our project manager builds out a production schedule based on the date the content is supposed to go live on screen.To help my PM with scheduling, I used formulas to populate some milestone columns (initial concepts due, kickoff to production, multiple creative reviews, etc...) with some estimated days for each step in the process. For example: Project Kickoff should occur about a month from the start date and uses "WORKDAY({Start Date}, -33)" while the File Handoff date is only a week before launch and uses "WORKDAY({Start Date}, -5)" So far, this has worked great for providing some rough dates during the initial project planni

Hello,I would like to create an RSVP form that can limit the number of participants. Is it possible?

Hi,I'm trying to determine how to display the difference between two dates as years, months then days.I have a start date and an end date, (the moment a worker started in the company and the moment he ended his contract with us), and I need to know how to have the result like "1y,3months,15days" or something like that, I found a formula that gives me the result in weeks and days, but a week always have 7 days, but a month can vary the days (28 days, 30 days, 31 days), so I am kind of confused

I'm using the WORKDAY function and it's skipping the weekend as it should, but it always returns the previous Friday. Is there a way to have it return Friday if the date falls on a Saturday, and return Monday if it falls on Sunday?

"I am conducting research to monitor the depression status of patients. It's crucial that I track their status on a weekly basis. Consequently, I am looking to set up a reminder calendar to facilitate this. I've utilized the provided formula to determine follow-up dates, but Airtable suggests that the outcome isn't recognized as a date format. This has hindered my efforts to create a calendar using the results. I would greatly appreciate any advice on this matter. Thank you!"   IF(    {First visit},    DATETIME_FORMAT(        DATEADD({First visit},1, 'weeks'),

Hi, I'm working on a way to consolidate a base used for a diaper program. We're a nonprofit and need to track for many different reasons, but our current process is long and requires toggling from table to form to table. Here's what we're doing (all are in separate tables):Entering donation inventory via form (an individual count of diapers, wipes and formula)Receiving requests via formReviewing the requests and inventorying out the items via form (linked to step 1)Here's what I'd like to do:Inventory donations via form (needed because amount spent is required for tax purposes)Link the request and inventory out form to subtract from inventoried donationsIs it possible to deduct (2) items at once or do we have to inventory out each item to properly subtract?Essentially, all three tables would be linked together with the inventory out and request forms "combined" to avoid exiting the table w