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

Formulas Activity

Grouping by date performed on first digits instead of as dates

Hi,Somehow Airtable doesn't understand my dates as dates so grouping goes wrong. In an interface I have a list of booked events that I want to be grouped by their date. That way, I can easily see day by day how many events are booked. The grouping co...

  • 20 Views
  • 1 replies
  • 0 kudos

DATEADD & IF

Hi - I use this formula to figure out when to follow up with applicants: DATEADD({Initial Email Sent}, 2, 'week') But I'd like to have it return a different result (1 week vs 2) when my applicants are getting fast-tracked. I tried this: DATEADD(  IF(...

  • 19 Views
  • 1 replies
  • 0 kudos

Converting text to date (M/D) format issues.

Working with birthdays where I only know the client's Month/Day and not their Year of birth.  So text field is 5/12 for example but I'd like to have an actual date of 5/12 so I can set up reminders 5 days before the actual birthday.  I used the follo...

  • 97 Views
  • 3 replies
  • 0 kudos

Resolved! How to convert formula from Excel to Airtable

I have an Excel formula I'd like to replicate in Airtable.This formula converts different currencies into GBP.Excel:=IF(M2+(N2/1.25)+(O2/1.2)+(P2/8.75)=0,"",M2+(N2/1.25)+(O2/1.2)+(P2/8.75))Key:£ GBP$ USD€ EUR¥ CNYM2N2O2P2How would I go about it? 

  • 87 Views
  • 2 replies
  • 0 kudos

Resolved! How to calculate word count into TRT

I am trying to take the word count of a book (ex: 100,000 words)divide that by 9,300 (which is how many words an average narrator can read per hour)to come out with the actual time in HH:MM format. This is the formula I have currently and how it turn...

Screenshot 2024-05-23 at 12.43.29 PM.png Screenshot 2024-05-23 at 12.44.05 PM.png
  • 102 Views
  • 4 replies
  • 0 kudos

AGEING DOGS USING THEIR DATE OF BIRTH

I've found a formula which is partly working for us, originally it was showing the years and months as negative numbers but I've managed to sort out the years aspect but I can't figure out what needs to change to make the months show correctly.curren...

  • 85 Views
  • 2 replies
  • 0 kudos

Resolved! Combine multiple lookup date fields

Hi,I have a series of lookup fields that return multiple dates.  I'd like to combine those fields into one, listing all of the dates returned in M/D/YYYY.  I've messed with datetime_parse and format with a concatenate, but the formatting is either no...

  • 94 Views
  • 3 replies
  • 0 kudos

Resolved! How to force underscores between Lookup Text

Hello! I am trying to format my data in a very specific way and require underscores between the text. I know when using a Lookup and formula there are challenges because the Lookup format is not a string and the commas within the field do not actuall...

  • 140 Views
  • 3 replies
  • 0 kudos

Trying to organize sales data

Hi everyone!I'm trying to organize my sales data in my Airtable base.I add the data through CSV upload. For every day of sales I add I add a new column to my sales data table.Now I want to run automatic calculations on the data. To give an example: i...

  • 87 Views
  • 1 replies
  • 0 kudos
UrbnJ by 5 - Automation Enthusiast