What would cause my summary report, when summarized, not show the total for revenue in dollars?
Thanks for the reply Genevieve P !
Unfortunately that wasn't the case. Both my sheets were formatted for dollars.
However, when I woke up this morning, the totals were showing correctly. So all is good now.
I see that you're Grouping the Report by Sheet. Is it possible that one of the sheets selected doesn't have currency formatting applied to its "Revenue of Accounts Initiated" column?
This would then have the SUM numbers for that specific sheet displayed as numerical, which means that the top summary would also appear as numerical without the $ sign:
To check this, scroll down in your Report to see if one specific Summary row is also missing the $ sign. Then go to the underlying sheet and adjust the column formatting to ensure currency formatting is applied to the entire column. This should then update that Summary row and therefore the Summary up at the very top!
Let me know if this was the issue or not.
No problem, I'm glad it's working for you now!
I would like to have my note column auto size so that the note when longer then the cell it in, can be read in its full txt and not disappear under the next column
Good day Smartsheet Support How do I Riana this account user change my account credentials to another username and password. I am not using this account, but my college is using this account with my credentials. Can you please assist me in how to go forward by changing my account credentials to another users' credentials.…
Is it possible to have a Chart Widget that is currently populated, maintain the same attributes (specifically the chart type and even series/colors) whenever the data source is updated? Example - I have a sheet that lists in one column different Business Purposes. In the next column, is a formula that counts how many times…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.