Report summaries formatting options

Corentin Dal Farra

Hello everyone,

Do you know if we can change formatting options for a summary row in the new report feature ?

Here I would like the column "2020 planifié" to show no decimals.

On my source sheet I already I have the good formatting options.

Thank you for your help,

Have a nice day,

Corentin

S_Karkhoff

https://community.smartsheet.com/discussion/73996/report-summaries-formatting-options

Check out this conversation regarding formatting of summary columns, there is currently a known bug.

https://community.smartsheet.com/discussion/73942/introducing-a-new-report-builder-plus-grouping-and-summary-for-reports#latest

Corentin Dal Farra

Hello @S_Karkhoff

Thank you for your reply,

I will wait for the bug fix in that case, but I am happy to see it is a well known bug and it happens with other users as well.

Have a nice day,

Corentin

Tim Starkey

Any update on this? I read through the other posts, and it looked like it was supposed to be fixed, but I am still having this problem. I can confirm that the underlying sheets are correctly formatted as currency. (I checked the column formatting on the sheets, and the columns total to a currency value in the sheets correctly)

EDIT: It looks like a bug. I filtered my report down to see if I could find the offending underlying sheet. See next 4 screen shots. With all three projects, the summary is not formatted correctly. But by filtering them down one at a time, it formats correctly.

Also, sorry for the giant screenshots...

#1

#2

#3

Tim Starkey

https://community.smartsheet.com/discussion/comment/314007#Comment_314007

OK... more problems... one more thing. The grouping is not working correctly. See below. Same manager (I have confirmed the spelling in the sheets, an no extra spaces. They are the same contact)

Christy Burnett

I am having this same issue. Group summary not formatting correctly. It should match the field it is summing. This just seemed to recently happen.

Megan Finn

Having this issue now. No progress on this in years?

Tim Starkey

I have run into this issue intermittently. Usually if I reload it fixes. But one thing that has never fixed itself… apparently it has trouble alphabetizing? Last time I checked, L came before S. Yet we have been using this report for a couple years and Justin always comes before Julie.