It makes sense that this function should be used to format the very cell where you type the phone number, but the function reference seems to describe formating a number coming from another cell.
If in the trigger formula I replace the ‘value’ with a reference to the cell itself with the formula, I get a circular error.
To avoid getting stuck in a circular reference loop, you can use the special
value variable in your formula, which contains the value stored within the cell itself.
Using only that, it says I am missing the region.
If I use the trigger formula PHONE_FORMAT(value, “GB”), nothing happens after I insert a phone number.
What format are you using for the phone numbers you’re entering into the cells?
Using GB as the region, entering either
1234 567890 produces
01234 567890 for me.
Right now I am ONLY inserting numbers and seeing if anything happens. And nothing happens.
If I insert 1234567890, the cell remains 1234567890
In your trigger formula settings in the right panel, do you have
Apply on changes to checked, with
Current field checked as one of the fields?
Sorry, actually, when I inserted more numbers, I got that UK format separation
However, I need a format either like this: 55 51 99909 9090, or 55 51 99909.9090, or with the 51 between parenthesis 55 (51) 99909.9090
btw: I am ControlProcessPav. That’s my account at the office. And I am posting from my personal google account (which is a user, for testing purposes, on the ControlProcessPav apps)
duh… obviously just changing the country code to BR did the trick. Let me find a hole in the ground to jump in and disappear.