Having two currencies in one sheet
I currently manage vendors in Japan but need to also have currency in dollar for our finance/accounting in the US.
I think the only current option is to change the whole account setting to change the currency, but that will prevent me from having two currencies, and will also change the entire setting to Japanese.
Is there a way to fix this? Have US as the country setting and have other currencies in the sheet?
Help Article Resources
Check out the Formula Handbook template!