Hi, I want to create a formula field that will add a “$” to those number that doesn’t have that. I tried using different codes but I still haven’t achieved it, can you help me? Thank you!
Solved
Help on creating formula field that will add character to a word
Best answer by Alexey_Gusev
Hi,
another way :slightly_smiling_face:
‘$’&SUBSTITUTE({TP-PP-DollarAmount},‘$’,‘’)
+29Welcome to the Airtable community!
IF(
LEFT( {TP-PP-DollarAmount}, 1) = "$",
{TP-PP-DollarAmount},
"$" & {TP-PP-DollarAmount}
)
+25Hi,
another way :slightly_smiling_face:
‘$’&SUBSTITUTE({TP-PP-DollarAmount},‘$’,‘’)
+29Hi,
another way :slightly_smiling_face:
‘$’&SUBSTITUTE({TP-PP-DollarAmount},‘$’,‘’)
Curly quotes strike again!
Thanks for sharing. I like seeing different ways to solve things in code.
Welcome to the Airtable community!
IF(
LEFT( {TP-PP-DollarAmount}, 1) = "$",
{TP-PP-DollarAmount},
"$" & {TP-PP-DollarAmount}
)
This was really helpful. Thank you so much! :grinning_face_with_smiling_eyes:
Hi,
another way :slightly_smiling_face:
‘$’&SUBSTITUTE({TP-PP-DollarAmount},‘$’,‘’)
I appreciate your help, thank you so much :grinning_face_with_smiling_eyes:
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.