Formulas
cancel
Showing results 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...

• 31 Views
• 2 replies
• 0 kudos

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

• 23 Views
• 1 replies
• 0 kudos

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

• 107 Views
• 4 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?

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

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

• 95 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

Why does this AND function not work and a simplified version do?

Hi there,I dont understand the difference between 2 formulas : IF( AND( {Startdatum Leverancier (rol repowered)} != BLANK(), {Einddatum leverancier (rol repowered)} = BLANK() ), "OT", IF( AND( {Star...

• 216 Views
• 2 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...

• 88 Views
• 1 replies
• 0 kudos
by 5 - Automation Enthusiast