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

edited 12/09/19 in Archived 2016 Posts

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. 





  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭



    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.



This discussion has been closed.