6 - Interface Innovator
since ‎Jun 04, 2020
‎Nov 29, 2022

## User Statistics

• 21 Posts
• 0 Solutions
• 5 Kudos given

## Nested IF, AND/OR

Hi, I’m struggling with some nested IF, AND and OR formulas. I’m trying to find if a value is within a range of numbers, and is a multiple of 5. For the range, I have the formula: IF(Value A >= 90,"Good", IF(Value A <= 150, "Bad")) <<This works To c...

## Find initial letters of UK Post Code

Hi, I am looking to find the initial letters of a UK post code before the first number. UK Post codes start with 1 or 2 letters and are always numbers and then letters. E.g. ‘WA1 1AB’ or ‘SK2 3LP’ or ‘L1 1AA’ or ‘M2 3NK’ I am looking for a formula to...

## Limit rows to a certain number e.g. top 20

Is it possible to limit the amount of rows in a table view for use in a chart? E.g. I want to see my top 20 accounts based on sales value. However when I create a chart, based on sales value, I cannot limit the results to only the top 20.

## RIGHT() - Last 2 digits of Created time (year)

Is it possible to get the last 2 digits of the creation date (year) e.g. 20 for 2020 19 for 2019. This is to use in a unique reference field (first 2 letters of name + “-” + last two letters of creation year + “-” + Auto ref number) I currently have:...

## Creating a company hierarchy (Parent/Child)

Is it possible in Airtable to create some kind of company hierarchy such as: Company 1 (parent) Company A (child)Company B (child)Company C (child) Company 2 (parent) Company A (child)Company B (child)Company C (child) To try and help you understand ...
Kudos from
Kudos given to