Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

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

Forum Posts

Formula field to split text into 3 ways

Hey, I am looking for a formula field to extract city, state and zip code from a full address fieldThis is how a full address looks like "New York, NY, 10031". I want to split them 3 ways using formula, how can I do thatI used this formula to get the...

Fahad_Sheji_1-1674835300739.png
Fahad_Sheji by 6 - Interface Innovator
  • 14 Views
  • 1 replies
  • 0 kudos

Resolved! Delete first matching characters in a column

Hi allIs there a way to delete the certain matching characters that might appear in a column? For example I have a column of data (800+ cells) of company names, and 90% of them are prefixed with a 'number' (that run between 1 and 9), followed by a 'p...

Stephen by 6 - Interface Innovator
Solved
  • 28 Views
  • 4 replies
  • 3 kudos

Replace multiple strings in a field with different strings

I'm trying replace the following text with different values within [] with values from single select columns[art medium], [main objects], [attribute], [expression], [key light], [detailing], [camera shot], [media], [engine], [artist]I thought this wo...

Multiple date roll-up to long text bullet format

Hello-I am trying to roll up 10 date fields that are all deadline dates to a long text field in a bullet format.Ideally I would want the field name to be visible as well as the date like this (Field name/Date):- Designer due date: 1-2-23- Submittal d...

Scott_Gardner1_0-1674803850944.jpeg

Remove TM from front of recipe

Hi there, I know how to get things off the end of a string but not the start!!! I have recipes that look like this  Easy veggie, lentil and quinoa dahl with pita toasts (KIDS)Greek salad with crispy chickpeas and potatoesMiso eggplant with broccolini...

jm22 by 4 - Data Explorer
  • 22 Views
  • 1 replies
  • 1 kudos

Issues with inaccuracies in my math

Howdy yall, I am trying to do a simple math setup for a client. calls per hour, demos per hour, calls per demo... The issue I am running into is the math seems to be coming back wrong. I have tried a few different ways and still having issues. Here y...

Screen Shot 2023-01-25 at 12.42.42 PM.png

Formula calculating to -$0.00

I can't for the life of me figure out what's happening with this one transaction in the personal finances base I've been building.  Would you guys take a look?These are two of the same type of transaction for comparison.  The top transaction calculat...

Screen Shot 2023-01-25 at 5.11.41 PM.png

Extracting Text - Close, but not close enough!

Hi All,I need some help with extracting specific text. I've looked through the community and tried to apply the examples offered...but I am not getting it quite right.I need to extract the suburb, state and post code from a (text) address field. Some...

grammy by 4 - Data Explorer
  • 31 Views
  • 1 replies
  • 0 kudos

Date Calculation Formula

I am trying to create a formal that adds a specific amount of days to a date field. The amount of days varies and is pulled using a lookup field. Initially, I was trying to use the DATEADD function but it doesn't seem to work when the added value is ...

KevinT by 4 - Data Explorer
  • 59 Views
  • 5 replies
  • 1 kudos

Progress Bar Formula

I looked at the posts about progress bar formulas and I have used them but my result is not looking correct. In the post, they said you need to use chrome and not safari I am using the latest version of chrome and its sill not working. Can some one ...

How to show most recent entry in group of numbers

Ok, I have been trying to do this for a while on my own with no luck.I have a list of serial numbers. These serial numbers have more than one entry. I group the view by serial number so I can see all entries for any particular serial number. What I w...

Rich_Nuzzi_0-1674682858384.png
Rich_Nuzzi by 5 - Automation Enthusiast
  • 31 Views
  • 3 replies
  • 1 kudos

How to calculate the mode for crowdsourced data?

Hi everyone, I’m trying to figure out how to calculate the Mode (ie. the most frequently occurring number in a series). I need this for the purposes of turning crowdsourced data into something useful. For example, if I ask 10 employees of one company...

Alice_T1 by 4 - Data Explorer
  • 183 Views
  • 1 replies
  • 2 kudos

Regex expression for matching previous capture group

I'm trying to clean up my text with Regex. Some ranges are listed as 3.0 - 3.0 which I want simplified to just 3.0 whenever the two numbers match. I tried using regex101 and MDN references, but Airtable seems to use some different syntax than either ...

Comparing two multiple value columns

Hi everybody !I would like to know how to add in column that features only the similar values found in columns A and B ?(In my case the A and B columns are Lookup from two différents tables but I guess it works the same).Thanks a lot for your help !

Capture d’écran 2023-01-24 à 20.48.28.png

Formula to calculate debits and credits for personal finance

Hey guys, I've got a new challenge in my quest to create a base for tracking personal finances.  A quick review:TablesCategories (I call them buckets)TransactionsDesignationsTransactions are either entered manually or bulk imported via csv from my ba...

Screen Shot 2023-01-24 at 8.07.18 PM.png

Problem with this formula

Hi there, I have a single select field name "Département" and I want to concatene the 2 first letters (later for automation).I have a problem with this formula :IF(  OR(    {Département} = "75",     {Département} = "78",     {Département} = "77",    ...