RVB - profile

RVB · Mar 29, 2024

Hey guys,I'm having trouble using a valuta like € 1.333,61 in a formula. It's being recalled from another table using a Lookup field. I've tried adding a new formula column/field and reformatting it first, before using it in a formula, but without an...

RVB · Dec 06, 2021

Hi! I’m new to regular expressions and I want to create a formula in Airtable which switches the text left from the ‘-’ to the right and visa versa. So U27Y11/12-U13Y07/08 needs to become U13Y07/08-U27Y11/12 Basically swapping the right and left side...

RVB · Mar 30, 2024

Hi @TheTimeSavingCo Adam, thanks for looking into this!Sharing is a bit difficult, because there are confidential names in there  But here is a formula causing NaN errors. (I blurred out a name in the screenshot)2 fields with valuta and the 3rd one...

RVB · Dec 06, 2021

It works like a charm Scott! Thank you! Going to experiment with this powerful functionality as well, it inspired me to do some more things.

RVB · Dec 06, 2021

Thanks for your help Scott! In 99% of the cases the amount of characters will be exactly the same as in my example. U27Y11/12-U13Y07/08 needs to become U13Y07/08-U27Y11/12 I can even make a separate column for the remaining 1% which will have only 1 ...

User Statistics

User Activity

Using a decimal/valuta from a Lookup field in a formula

Replace text using a regular expression

Re: Using a decimal/valuta from a Lookup field in a formula

Re: Replace text using a regular expression

Re: Replace text using a regular expression