Anyone can help me make a formula to write out the below numbers in a Single Line text field (A) that are styled like below, to full digits in a Formula Field (B)?
Field A
1
10
100
1k
10k
100k
1.1k
10.1k
100.1k
1M
1.1M
Etc.
So far I’ve come up to this formula. But it’s very lacking.
SUBSTITUTE( Views, REGEX_EXTRACT({Views}, "\.\d+k"), "00")
It outputs 100 when its 1.7k and doesn’t work at all for entries like 1 to 999 and 1M upwards.
I rather wish that this formula didn’t work. But you should try it anyway. Please reply with your thoughts after you have tried it.
VALUE( LOWER( {Views} ) )
I rather wish that this formula didn’t work. But you should try it anyway. Please reply with your thoughts after you have tried it.
VALUE( LOWER( {Views} ) )
It works like a charm! Awesome approach that’s way outside my own box.
thanks for all your help in the community.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.