Help
Formulas
cancel
Showing results for 
Search instead for 
Did you mean: 

Formulas Activity

What formula to use

I need to get the month to date total number of appointments per client, I am still not getting the result that I need I kept getting the total number since they started. Help please

  • 48 Views
  • 2 replies
  • 0 kudos

Last OR argument is ignored

I am trying to fix a formula for hours, but I can't find the error. For some reason, the last argument in an OR Formula is ignored.The base has 2 tables (Table 1 and Table 2)Table 1 has one record with the following values:Field 1 (single line text) ...

  • 50 Views
  • 3 replies
  • 0 kudos

Resolved! Extraire un mois d'une date non formatée

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...

Sam44_0-1730801967857.png
  • 93 Views
  • 3 replies
  • 0 kudos

Creating Total count field from Multiple Select Fields

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'...

Snag_1f48e20c.png Snag_1f493d5b.png Snag_1f4a6aa0.png
  • 87 Views
  • 1 replies
  • 0 kudos

Resolved! ArrayUnique & ArrayFlatten not working

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...

NoreG_0-1730726054979.png
  • 390 Views
  • 17 replies
  • 0 kudos

Really struggling with unique count of a rollup field.

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, ...

  • 512 Views
  • 1 replies
  • 0 kudos

Resolved! Combining cells for repeated content/values

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...

combined.png
  • 192 Views
  • 3 replies
  • 0 kudos