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

Amye
Amye ✭✭
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. 

 

Thanks!

Tags:
· Share on FacebookShare on Twitter

Comments

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

    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

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories