- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 12, 2023 01:51 PM
(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 $"
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 12, 2023 10:47 PM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 12, 2023 04:43 AM
