Hi everyone. Is there a way to format a report I built. I would like to change fonts and background colors?
The report shows the formatting from the sheet(s), so you have to change the fonts and colors there.
I hope this helps you!
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Thanks Andree, so there is no way to manipulate format in the report itself. That is what I understand correct? do you know if smartsheet is planning to include that as a future update. I think we all can get benefited of that.
Happy to help!
Yes, unfortunately, there isn't today, and I don't know of any changes coming. We will know more after Engage 2018.
Either way. Please submit an Enhancement Request when you have a moment.
Thanks Andree, I will be there in October.
if you would like a better looking and more interactive form of Reporting,then you could look at using Graphs in the Smartsheet dashboard or even use Power BI to provide slicing and dicing choices to your graphical views.
All that is available now. Power BI is quite inexpensive and Smartsheet dashboards are Free providing you are on a Business License. We do understand the value of adding colours to reports, the human eye enjoys consuming data far better with colour.
Hope that helps
Thanks Richard really appreciated your feedback. I start using dashboards and facilitates that, but still brings the reports into the dashboard as it is. Unless I am missing something. How can I get the Power BI tool? Do you know how much cost?
Here's some info on Power BI and some other options as well.
Please see the attached link/screenshot for more information.
I was thinking that you could gather the stats you want to see in your reports in one of more summary sheets, rather than in Smartsheet Reports, then you can use the Bar Charts and other graphs to represent what you want to see in Dashboards which you can easily share with Colleagues.
To benefit form Power Bi dashboards you still need a data source in Smartsheet so gathering your data/ KPIs together is still needed, but the beauty of Power BI over Smartsheet dashboards is the data displayed can come from a mix of Smartsheet AND Excel if you want it to, plus you can slice and dice the Graphs as you view them, so great for presenting at a Board Meeting.
The cost of Power Bi is circa $7 per month standalone or as an add on to your 365 account. You may well benefit from someone setting this all up for you to start with, then show you how to maintain it. Otherwise you may get frustrated.
The results are impressive whichever dashboard you use. if you do need some help setting this up, my team can do that but there would be a cost, or have a play yourself? We do offer a free initial consultation where I can demonstrate all the above so YOU can decide what you want?
PS Andre thanks for sharing the links to Gabe!
Does anyone know if there is a way to format a report when it is a sheet summary report? I know in order to typically format a report, you need to format the grid itself that the report is pulling from, but that does not seem to work on sheet summary reports.
Hi @Ross Novotny
Unfortunately, it's not possible to format the Sheet Summary report at all, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment.
I hope that helps!
Be safe and have a fantastic week!
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
Not being able to format reports is a major drawback - not sure how they haven't fixed this yet. You should be able to adjust font, font size, etc., by report, based on level of report required, audience, presence on dashboards.
I'm working on a compensation request form that follows these steps: An HR Business Partner completes the Compensation Request Smartsheet Form that then triggers an alert to our Compensation Manager. Our Compensation Manager will insert the requested information. The HR Business Partner will be alerted when the…
I have many many sheets where column names are the same but data types are different (ex: some "Assigned to" columns are text/numbers and some are contact list, some "Project Name" columns are text/numbers, and some are dropdown list.) The choices in value type are driven by the many teams specific needs. This creates…
Is it possible to format a singular cell in a sheet to total the above numbers add in each cell of the column.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.