Sign in to submit new ideas and vote
Get Started

Change Formatting in Reports

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.

48 votes

On Wishlist · Last Updated

That's a great idea! Formatting Reports independent of sheets is something we think would have a lot of value. While it's not in our current plan we are thinking about all the ways we can make Reports even better. If we think we can make this idea a reality we'll update status here.


  • 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.

    Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. This will make it easier for others to find a solution or help to answer!

  • Harvey E
    Harvey E ✭✭✭

    Even on a more simple level where you'd like different views of the same sheet data, eg a Project Plan which might have conditional formats on it highlighting tasks running late, key milestones etc, but you want a cleaner representation of the same data, eg a high level plan (report)

  • scottreiter
    scottreiter ✭✭✭✭

    I have a report that utilizes the Summary functionality (to give me averages for each column). Due to the lack of formatting, it looks pretty bad. There is no way to control how many decimal places ..or center align the column to match the center aligned content in the columns. This makes the summary data formatting inconsistent and difficult to read. Please add formatting!

  • Michelle Choate 2
    Michelle Choate 2 ✭✭✭✭✭

    Absolutely! Customizable reporting formats are indeed a valuable feature that can enhance the usability and effectiveness of any management tool. Providing the flexibility to tailor reports to the specific needs and preferences of different user roles or stakeholders can greatly improve communication, decision-making, and overall productivity within an organization.

    Having the ability to easily switch between various report views or formats can empower users to extract the most relevant insights for their respective roles, whether they are involved in day-to-day operations, management, or executive-level decision-making. It promotes a more efficient and tailored approach to accessing and presenting information, ensuring that each user can focus on the key metrics and data points most relevant to their responsibilities.

    Integrating this feature into the solution would align well with addressing diverse user requirements and fostering a user-friendly experience, ultimately contributing to enhanced data utilization and better-informed decision-making across the organization.

  • Monicacraven
    Monicacraven ✭✭✭✭

    Couldn't agree more. Combining sheets in a report can make a very ugly an inconsistent user experience especially if you put this in a dashboard.

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

  • 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.