This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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 ...
