Skip to main content

Currency formatting based on Country

  • April 12, 2023
  • 2 replies
  • 26 views

Forum|alt.badge.img+1

(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

TheTimeSavingCo
Forum|alt.badge.img+31

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


Forum|alt.badge.img
  • New Participant
  • May 12, 2023

This should do the trick