Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Reports: Automatically change crossed-out items?
I've created a report that collects all our ad assets in one place, from multiple sheets.
However, all of these ads are marked complete in their respective projects, so they are marked out/crossed out. They're showing up this way on my report and it's not optimal.
Can I change the font style in my report so it doesnt reflect this detail from the project sheets?
Comments
-
Leigh,
Not that I'm aware.
"The formatting (cell font color, background color, bold text, etc) that appears in a report is based on the formatting in the source sheet."
Source: http://help.smartsheet.com/customer/portal/articles/522214-creating-reports
Could you use something else to indicate that a project is complete instead of marking out the project?
The other option would be to export into Excel and format as you need.
Would be a great feature to request to allow report formatting to override the sheet.
Tim
