Help

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

Topic Labels: Formulas
Solved
Jump to Solution
809 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Dreambound_Serv
5 - Automation Enthusiast
5 - Automation Enthusiast

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!
dollar

1 Solution

Accepted Solutions
Alexey_Gusev
12 - Earth
12 - Earth

Hi,
another way :slightly_smiling_face:

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

See Solution in Thread

5 Replies 5

Welcome to the Airtable community!

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

Hi,
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.

This was really helpful. Thank you so much! :grinning_face_with_smiling_eyes:

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