Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

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

Topic Labels: Formulas
Solved
Jump to Solution
202 5
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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}
)

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: