The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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...
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...
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.
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:...
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 ...
Superb this does exactly what I need :partying_face:
Would you be able to explain what the "^\\D*" part does?
I looked at the Airtable formula page but it doesn’t give much explanation.
Thanks @Justin_Barrett
Thanks @ScottWorld / @Justin_Barrett.
The record list is probably the closest to what I’m looking for.
I ended up looking at what the sales value is at row 20, and set a filter where sales value > than just below this number to give me the top 20.