I'm using reports to do "summaries" using Average and Sum. All underlying sheet columns are formatted in US Currency. The Total is displaying the number with the $ sign but no comma. Is there something I'm doing wrong?
I believe this may be "expected" behavior. I just had a client point the same thing out in one of their reports and have raised a ticket with Support.
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
I have bookmarked your post and will try to remember to revisit and update once I hear back from them. Hopefully it won't take too long.
Thanks for weighing in, Paul. I also had a report that rolls up to an executive dashboard and both their comma separators in USD currency mid-January. That is to say, I'm confirming that the formatting did previously exist and its absence should be considered a bug. Sorry for the potato quality screenshots.
Just this morning I got a response from Support:
At this time, Smartsheet does not yet support showing commas in the grouping summary; however, I have recorded your Support ticket as feedback and on your behalf, I have also submitted an Enhancement Request to our Product team so that this functionality may be added to their lists of future developments. We highly appreciate your input!
@Chris Albig Could I possibly direct them your way since you have screenshots of it obviously being in place?
It appears that the Summaries section from a report does support commas. Just not commas in the currency format. I changed my source sheet back and forth to check this.
"I reviewed the community post and I was able to see the screenshot that you've mentioned. Upon further investigation on the backend, we've determined that the behavior you're experiencing is not intended and we have notified our Development team, who is actively working on a resolution.
Unfortunately, we are not able to provide a time-frame on how long the resolution could take but we are doing our best in order to have this fixed as soon as possible."
Looks like they added the comma to the currency.. thanks for your follow up!
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I have several grid sheets that have SUMIF summary formulas running. I’m working on a new sheet that requires I split the date & time that are included in one column. Summary formulas I would ordinarily run on the Program Start Date no longer work. Am I correct in assuming the summary formula will not operate on a column…
On my Smartsheet, I want to count the number of lots manufactured per year based on the date of manufacture. If the date is between 1/1/2023 and 12/31/2023, give me a value of "2023", and the same moving forward in 2024 and so on. I cannot figure out what the formula will be. Can someone please advise? Thank you in advance.
I'm looking to put together a formula that outputs a status based on a few criteria. This formula should output "Denied" by default. If the [Price] is $500 or less and [ManagerApproval] = "Approved", output "Confirmed". If the [Price] is more than $500 but less than $1000 and [ManagerApproval] = "Approved and…
©2024. All Rights Reserved Smartsheet Inc.