Managing Currencies in Smartsheet
Hi,
I have a sheet that shows annual spends for certain vendors. I want to display all those spends with the $ currency sign and then use an =sum formula to add together all the spends to show the total spend in the blue bar of my screenshot.
Two questions:
- How do I add a $ currency sign and commas to my blue annual spend cell that has the =sum formula in it?
- How do I remove the .00 cents from the annual spend numbers?
Thanks,
thanks,
Best Answer
-
Hi @Max329
You can use the ‘Currency formatting” option to to add the $ currency sign and the “ “Decrease Decimal” option to remove the extra decimals (if you click on it twice this removes the .00). See the screenshot below:
Buttons for formatting numbers are grouped together in the top navigation bar under your sheet's name. If you don't see these buttons on the toolbar, you may need to click More.
Select Currency Format (next to percentage sign) to automatically format numeric values with the appropriate currency symbol and decimal position.
For more information on formatting your data see the help article here.
Cheers,
Hamza
Answers
-
Hi @Max329
You can use the ‘Currency formatting” option to to add the $ currency sign and the “ “Decrease Decimal” option to remove the extra decimals (if you click on it twice this removes the .00). See the screenshot below:
Buttons for formatting numbers are grouped together in the top navigation bar under your sheet's name. If you don't see these buttons on the toolbar, you may need to click More.
Select Currency Format (next to percentage sign) to automatically format numeric values with the appropriate currency symbol and decimal position.
For more information on formatting your data see the help article here.
Cheers,
Hamza
-
Very helpful, thanks Hamza!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives