Help on creating formula field that will add character to a word

[Dreambound_Serv]

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!

[kuovonne]

Welcome to the Airtable community!

IF(
  LEFT( {TP-PP-DollarAmount}, 1) = "$",
  {TP-PP-DollarAmount},
  "$" & {TP-PP-DollarAmount}
)

[Alexey_Gusev · Accepted solution]

Hi,
another way :slightly_smiling_face:

‘$’&SUBSTITUTE({TP-PP-DollarAmount},‘$’,‘’)

[kuovonne]

Alexey_Gusev:

‘$’&SUBSTITUTE({TP-PP-DollarAmount},‘$’,‘’)

Curly quotes strike again!

Thanks for sharing. I like seeing different ways to solve things in code.

[Dreambound_Serv]

kuovonne:

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:

[Dreambound_Serv]

I appreciate your help, thank you so much :grinning_face_with_smiling_eyes: