Help

Currency formatting based on Country

Topic Labels: Formulas
742 2
cancel
Showing results for 
Search instead for 
Did you mean: 
nicolasmertens
4 - Data Explorer
4 - Data Explorer

(sad to see there is no "formatting" category nor a label for this, so posting this within "Formulas")

I need to base the currency of my field Goals to reflect the currency of the continent the deal is in.
As in "When the deal is in Europe, show the currency as €, however when the deal is in the USA show $"

2 Replies 2

I don't think you can do that within a Currency field I'm afraid

A workaround might be to use a formula field with `SWITCH()` to set which currency symbol to use based on the continent, and then concatenate that with the deal amount

jahidkhan
4 - Data Explorer
4 - Data Explorer

This should do the trick