Formulas
cancel
Showing results for
Did you mean:

## Formulas Activity

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

• 72 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?

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

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

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

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

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

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

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

### I would like to find the cumulative balance by referring to the previous record value.

Hello, I am a user who studies airtable. I would like to inquire about the function of using airtable.In Excel, a fomula can be calculated by referring to previous row (previous record) values.So it's easy to implement how to get the following balanc...

• 145 Views
• 4 replies
• 0 kudos

### Calculate Number of Days between two date fields and exclude weekends

We are implementing time tracking fields in multiple bases and need to calculate the total amount of time between two date fields (in days, hours & minutes) but also excluding weekends and possibly holidays. I've tried the following but the calculati...

• 99 Views
• 1 replies
• 0 kudos