Is it possible to include Conditional Formatting in a Report?
I see discussion on this topic from a few years back, wondering if there has been an update or an easy work-around to include Conditional Formatting in Reports.
Thanks!
The report will reflect conditional formatting from the sheet. I don't think it is possible to include conditional formatting only in a report.
Hi Melissa,
Brooke is correct. One workaround would be to build a dashboard with the report and then you can choose if you want to show the formatting.
I hope this helps you!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Thank you for the response, but my conditional formatting is not transferring to the Report. My hope is to have it both on the main sheet and the report. Any suggestions on where I've gone wrong?
Ok, I've played with it a bit more. It seems my conditional formatting is working on the report though a change needs to be saved to the main sheet before the conditional formatting will appear on the report. So when I check a Complete box or change the date on the Report, it will not show the conditional formatting until the main sheet saves and the report is refreshed.
A little clunky but at least it works.
Has there been any update to this request: https://community.smartsheet.com/discussion/6769/possible-to-strip-cell-formatting-out-for-reports
I have conditional formatting (ie color coding) in a master sheet. I do not need, nor want, that color coding to be visible in the report I am sharing with a supervisor.
How do I remove the conditional formatting for just the report only?
Hi @Chris Rea
Unfortunately, it's not possible to remove the formatting in a report except in a Dashboard at the moment, 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!
Workflow Consultant / CEO @ WORK BOLD
✅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!
@Andrée Starå this is nearly 2 years old and hasn't been fixed. I'll add it to my que of "feedback requests", which is getting to be nearly a dozen items, but the more I search smartsheet the more it looks like those requests fall on deaf ears.
@Chris Rea
Yes, it can feel like it does go to deaf ears, but I don't think that is the case. I know that Smartsheet gets a high number of Enhancement Requests and that they have to prioritize according to multiple factors, where the popularity is a big one.
That said, please continue sending in the Enhancement Requests.
I'm on the other side of this issue than @Chris Rea. I have formatting I would like to appear in a report but not appear in the day-to-day work on the main sheet... specifically, for management.
Although, I could see it going the other way as well.
Personally, I prefer very specific use of color on my sheets. My managers on the other hand like full on rainbow reports. I would be sick and dizzy if I had to look it all day long.
Would love to see reports with separate conditional formatting options. Seems like that would solve the issue either way.
Cheers!
I have a slightly different requirement.
I would like to conditionally format the summary row if the demand (budget) is greater than the supply (capacity).
Is this possible?
Hi @Smtshtuser
I hope you're well and safe!
Unfortunately, it's not possible now, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment.
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Has this been fixed yet?
Hi, this is a really good request that seems to be growing old. Managing the appearance of a report seems like a reasonable request - soon???
Yes agreed - we run a couple of reports to validate data across multiple sheets. We can use several conditions and filters in these reports. It would be great to be able to use conditional formatting in this instance as it would quickly highlight the specific data anomaly areas that need fixing.
I have a Smartsheet automation setup to reminder the planning to complete their sections. It is setup to remind weekly until completed box is checked. They received 2 reminders and then the reminders stopped. Any idea what could be wrong? I can't tell that anything has changed in the sheet. Thanks Freda
I'm editing formulas in a Sheet Summary. However, I'm prevented from seeing the formula by an annoying "helpful" popup that obscures my view. I can't figure out how to get rid of the popup. Does anyone know?
I am trying to create a workflow and for some reason it gives me an error with the email I entered as the recipient for my Alert. It is an email that I know works, it is shared to the sheet, and the access to the sheet is unrestricted. I am perplexed at what the issue is. Anyone else get this and know what the issue is?
