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: 

Formulas Activity

Fetching info from within a linked record

Hello, I am pretty new to airtable and have a slight issue with fetching info from a record within a record. With an automation i create a number of records within a record to be able to choose multiple products for the same order number. (Not a lot ...

  • 8 Views
  • 0 replies
  • 0 kudos

Date Span Crossover Formula/Script?

HiIf anyone has any ideas about this I would be very grateful - I can't quite see a way through this one!One of the elements of the system I'm building schedules the use of specific tools. I would like to be automatically notified if a tool is double...

  • 11 Views
  • 0 replies
  • 0 kudos
Jon by 5 - Automation Enthusiast

Conditional formula

Hi, I am trying to create a formula to work out meal allocations for works at a festival site.Currently I have date fields for 'ARRIVAL DATE' & 'DEPARTURE DATE' and a field for 'DAYS ON SITE' which uses the formula DATETIME_DIFF({DEPARTURE DATE},{ARR...

  • 11 Views
  • 0 replies
  • 0 kudos

Resolved! Date Counting

Hello!I have a list of records that all have a start date and end date column for a number of employees.  I am wondering if there is a way to calculate the number of employees on a given day.  All the employees have different start and end dates.  So...

  • 50 Views
  • 2 replies
  • 1 kudos

How many times a linked record has occured

I'd like to count how many linked records have occurred with another linked record. I have a table where each record is a contract between a company and a governmental entity. The company's column is a linked record and the entity's name is also a li...

Motlaq_AlMutair_1-1674915234669.png
  • 32 Views
  • 2 replies
  • 0 kudos

Resolved! Costum ID

Hi there. I'm trying to make a custom auto number. The constant is kasse 00 and then want the autonember to be kasse 001, kasse 002, kasse 003 and so on. Can anybody send me in the right direction?And off cause will there be a problem when I reach ka...

  • 46 Views
  • 3 replies
  • 0 kudos

Resolved! Split Formula

Hello,I have a rollup field with the following output:FirstName1  Last Name1- XXXX Title Company , First Name2 Last Name2 - XX Title CompanyWithout going back to the original table to pull the "XXX Title Company"  I need a formula to help split and d...

  • 52 Views
  • 2 replies
  • 0 kudos

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

  • 54 Views
  • 4 replies
  • 0 kudos

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
  • 47 Views
  • 0 replies
  • 0 kudos

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

  • 37 Views
  • 1 replies
  • 0 kudos

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

  • 59 Views
  • 4 replies
  • 0 kudos

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

  • 41 Views
  • 1 replies
  • 0 kudos

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
  • 84 Views
  • 3 replies
  • 0 kudos