Sign in to submit new ideas and vote
Get Started
We are aware that the yellow status bar is not showing for Ideas, even when logged in.

This has been reported to the website support team and we are looking into it. In the meantime, please add your votes from the list view or by commenting on that idea.

You can see Statuses by filtering the main list.

Change Formatting in Reports

Options
Samuel Mueller
Samuel Mueller Overachievers Alumni

It would be very convenient to be able to format a report different than the sheet. One purpose of a report is to bring multiple sheets of data together, but often those different sheets have different formatting which can make your report look awful. If you could format your report at the report level, it would solve all sorts of formatting issues.

159
159 votes

On Wishlist Β· Last Updated

This capability is something we are actively planning for the future development of Reports. While we don’t have a release date to share yet, we’ll be sure to provide updates as soon as our plans solidify.

Β«13

Comments

  • ro.fei
    ro.fei ✭✭✭✭✭✭
    edited 02/23/23

    Right now we can format sheets & choose to bring over the formatting from there, but that's not enough. Sometimes I want my reports formatted slightly differently than what I have in the sheet(s) it's pulling from. Furthermore, there's currently no way at all to format summary rows in reports, which is infuriating when everything else in the column has no decimals/1 decimal/etc. but the summary row has 5.

  • broctawn
    broctawn ✭✭✭

    This would be a very useful feature where I work. Please bring this idea to life!

  • crodts
    crodts ✭✭✭

    It would be nice to be able to clear sheet formatting when it is pulled into a report.


    It would be even nicer to then be able to create new formatting within the report.

  • Jenann
    Jenann ✭✭✭✭

    This would solve an issue I am having now! I have a lot of data in the Sheet Summary based on formula and want the negative numbers to be RED. Currently no way to do it BUT if I could update on the report it would solve this!!! Love this idea great for many other issues as well. On some sheets I want the data Gray to alert PMs NOT to change. But on reports. Now all gray!

  • swilly
    swilly ✭✭✭

    NEED CONIDITONAL FORMATTING ON REPORTS!!!!

    Having to open each source sheet to have the conditional formatting reload is not efficient.

  • TheSloppyJoe
    TheSloppyJoe ✭✭✭

    Is there a way to strip the formatting so that it doesn't carry over from the source sheet(s)?

  • Samuel Mueller
    Samuel Mueller Overachievers Alumni

    @TheSloppyJoe only if the report is on a dashboard.

  • pweaver
    pweaver ✭✭
    edited 03/04/25

    Currently, the only two options that exist for formatting the content of a Report Widget on a Dashboard are adoption of the existing formatting on the source report (which is also restricted to the formatting found on the underlying sheets feeding the report) or removing the formatting and accepting the default formatting provided by the widget. I'd propose the ability to adjust the formatting within the widget settings, similar to the ability to format the title.