Skip to main content

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!

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},‘$’,‘’)

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.

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:

Terms & ConditionsAccessibility statement