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