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 🙂


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

Hi,

another way 🙂


‘$’&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 🙂


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


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

Reply


Terms & Conditions