- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 08, 2022 12:20 AM
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!
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 08, 2022 06:48 AM
Hi,
another way :slightly_smiling_face:
‘$’&SUBSTITUTE({TP-PP-DollarAmount},‘$’,‘’)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 08, 2022 12:59 AM
Welcome to the Airtable community!
IF(
LEFT( {TP-PP-DollarAmount}, 1) = "$",
{TP-PP-DollarAmount},
"$" & {TP-PP-DollarAmount}
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 08, 2022 06:48 AM
Hi,
another way :slightly_smiling_face:
‘$’&SUBSTITUTE({TP-PP-DollarAmount},‘$’,‘’)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 08, 2022 07:59 AM
Curly quotes strike again!
Thanks for sharing. I like seeing different ways to solve things in code.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 08, 2022 06:18 PM
This was really helpful. Thank you so much! :grinning_face_with_smiling_eyes:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 08, 2022 06:18 PM
I appreciate your help, thank you so much :grinning_face_with_smiling_eyes: