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

Formulas Activity

View field in form based on previous data

Hi, I' trying to figure out something with the form.I need my salesteam to submit sales info in the form.Lets suppoer we have to submit 2 field:1) sale price2) costI would like that after the user typing the 2 infos above, a field called "profit" wil...

  • 26 Views
  • 1 replies
  • 0 kudos

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

  • 64 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) ...

  • 79 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
  • 106 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
  • 92 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
  • 411 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, ...

  • 513 Views
  • 1 replies
  • 0 kudos