Conversion of currencies
Help please!! I have a sheet that has a column with currency code and conversion rate. On another sheet I want it so that local currency value can be used, the appropriate currency code selected and then next column should auto convert to GBP for reporting purposes.
Can you help me to create this please?
Answers
-
Hi @Mark Tserkezie
Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Thanks in advance
-
Hi @Mark Tserkezie
Hope you are fine, please use the following formula
=IFERROR((INDEX({FY21 Rate}, MATCH(Currency@row, {Currency type}), 2)) * [Total Annual Premium (Local Currency)]@row, "")
the following screenshot shows the result
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!