Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Currency Prefix within a cell
Hi guys and Girls,
A quick one I hope. Can I add a 'prefix' to a cell that shows currency? We use SS with AUD and NZD, thing is they are both a $ symbol. Is there any way to make them look more like their own and show $AUD5000 and similarly $NZD5000?
We have 2 seperate sheets so if there is a workaround that I can apply to an entire sheet that would be great, and if that workaround still lets me link a cell in teh AUD sheet but SHOW NZD in the column that is great too.
Thanks!
Comments
-
Amye,
You may need to have a value column and a display column.
="$AUD" + [ValueColumn]23
Do all your calcs, sums, counts, on the value column but use the display column for Reports and Sights. Unless you edit from your Reports.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- 10.6K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives