BonjourJe reçois un fichier importé automatiquement avec une colonne "Date début" au format "texte sur une seule ligne" de type01/10/2024, c'est à dire jour/mois/annéeJe voudrais dans la colonne suivante extraire le mois et le passer au format "octob...
Hello! I am new to creating formulas in Airtable, and therefore need help creating a total count field based on multiple selections. What I want to have is the top items ordered (maybe top 15 items) and show which employees have ordered that item. I'...
Hi everyone, I am trying to get unique values from a lookup field. I have tried the solution suggested in: Solved: Exclude Duplicate/Repeating Values via Lookup or R... - Airtable Community. by @kuovonne. Which stated: Create a rollup field that rol...
For context, monitoring product listings on Amazon.I have 4 tables:Brands, with a lookup field to ASINs, from CatalogCatalog (containing ASINs), with a lookup field to OffersOffers, showing every offer on each ASIN, where each offer has a Seller ID, ...
I am trying to write a formula field that will summarize the responses of three separate single select fields (Prototype 1 Cost Status, Prototype 2 Cost Status, and Prototype 3 Costing Status) so my costing team can have an idea of what proportion of...
Hello,I'm looking for a way or formula to set the records vertical within a cell as I show you in the attached image. Bests,L
Hello community,I'm building some kind of table where it has repeated content in the rows that I would love to have them combined, similar to a merge cell in Excel or Google Spreadsheets.Is it there a formula or a scripting that can help me have some...
Hi,I have a formula that currently works 90% of the time which finds the number of days between a date range for a given month. The issue is, when the end date, ends in the month I am looking for, example below Oct the formula is correct (row 1, 3 an...
I am using ArrayUnique(values) as in a rollup field and then referencing this in a make.com scenario to output to a Word document. This works, but the output is a bit unfriendly.Products Acer_Vero B7_B227Q,Acer_Vero B7_B277,Acer_Vero B7_B247Y I have...
Hello,I need your help with comments. Users of my interface can easily enter comments on a records. The problem is that I have other tools linked to Airtable, and I would like to find a way to put the date of the last comment or just the comment coun...
| User | Count |
|---|---|
| 900 | |
| 834 | |
| 609 | |
| 542 | |
| 354 |
