Hi, I am attempting to concatenate text in a formula column to create a dynamic google maps link. When I attempt to convert a decimal (latitude or longitude values) to text, I'm not able to use a decimal in the formatting. Any workarounds here? It is requiring a formatting argument when using Text().
I attempted the solution ronaldwalcott recommended and it was so close to working. Unfortunately, if there are any leading zeroes in the decimal, it does not convert accurately (they get dropped).
There is probably a way around this I haven't considered, but I will be using power automate to achieve this for now.
From Learn: The Text and Value functions only work
with whole numbers, where no decimal separator is involved. The decimal
separator varies across locales. Since formula columns are evaluated
without locale knowledge, there's no way to properly interpret or
generate the decimal separator.
I'd use Power Automate to do the conversion.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
4
Share
Report
All responses (
Answers (
