Reports: Automatically change crossed-out items?

Leigh Choate

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? 

Tim Meeks

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