Formatting the Sheet Name Field within a Report
Hi!
I would like to know if there is a way to format the Sheet Name column within a report. I would like the ability to middle align, and wrap text.
Also, is there a way to remove row colors within a report without removing the colors from the actual Sheet?
Thank You!
Comments
-
I was able to figure out how to middle align, so now just how to text wrap.
-
You were able to align center in the Report or the underlying Sheet(s)?
There is no way to (re)format the rows in the Report, the formatting comes from the Sheet. Mostly. Sometimes, it gets confused and may not accurately represent the formatting in the Sheet.
Word-wrap is one of those that is difficult to see if it is working or not. I typically select the whole column and set the word-wrap as sometimes it reverts to non-wrap. I suspect because of copy-paste but have not reproduced it fully.
Craig
-
Hi - strangely I have a report in which some of the Sheet Names appear bold and filled in another colour. Is this an option? I thought formatting Sheet Names was not possible in Smartsheet.
-
Hi @cyrusmody
Reports take the formatting that's applied to the underlying sheet(s). The Sheet Name column will show formatting that's applied to an entire row.
This means that if you had originally selected the entire row to be Green with Bold, but then selected cells to be white, the formatting will still stay on the "row", showing it in the report!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
@Genevieve P. does that mean if I apply wrap text to all the rows in a sheet that the sheet name column in the report will also show as wrapped? Because Im trying that and it doesnt seem to work :(
-
Hi @cyrusmody
No, you're correct: wrap-text is not able to be applied to the Sheet Name column in a Report at the moment.
Please submit your feature request to the Product team by creating an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community. This will allow other users to vote on your enhancement idea!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
I have one stubborn Sheet Name that is showing up in a centered position in all of my reports, how do I fix this? None of the others are doing this.
-
Hi @Tiffany L
Is it possible that the sheet in question has center-aligned formatting applied to the entire row in the underlying source sheet?
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 33 Webinars
- 7.3K Forum Archives