Skip to main content

(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 $"

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

This should do the trick

Reply


Terms & Conditions