Shade every other line on a sheet to identify easier which line you are working on, especially when your sheets are wide. 😉
Sign in to see the current vote count, add your own vote, or leave a comment.
Hi @Cindy Zobrist
Thanks for posting your idea!
If you want to set this up today, I currently use two helper columns to do something similar on my sheets.
=IF(ISEVEN(VALUE(MATCH(Row@row, Row:Row, 0))), 1, 0)
3rd step: set up Conditional Formatting based on that helper column
Cheers,
Genevieve
@Genevieve P. Thank you - thank you - thank you!!!!! You are amazing! Thanks so much for your quick response and resolution! 😊
No problem! Glad I could help. 🙂
Enable sheet admin or owners to apply alternating row colors.
Requirements:
See Google Sheets for the example I'm used to.
Alternating row colors makes grids of data easier to read. In Smartsheet formulaic solutions with helper columns are the only options available. And these options are not easy for novices to implement are complex to setup, and do not hold up to sorting or filtering.
Thanks for your time and help! :)
Color banding every other row in a sheet helps tremendously with readability and accessibility. While it's possible to use helper columns to apply this type of color banding to an entire sheet, the banded formatting loses its functionality when filters are engaged or rows are re-sorted. It would be great to have the option to apply dynamic row banding to Smartsheet grids, similar to those in Excel, where the color banding maintains an every-other-row format even when grid hierarchy changes via filters, addition of new rows, application of different sorting rules, etc.
One way to possibly do this on Smartsheet's side is to surface the dynamic row number, like we do with the Latest Comment. Then no matter if you delete a line, sort, etc., that column would be available. Then we could use the method Genevieve described above using the odd/even Conditional Formatting with it breaking.
Hi @Rick Olsen can you please elaborate your comment about the dynamic row number? Thanks
It's been over a year, I don't remember… and not making headway in my thought process… :-)
The idea of dynamic row banding would be incredible. Alternate row shading that is continually maintained based on hierarchy collapse/expand and filtered views.
We need the ability to duplicate (copy) an existing dynamic view to other sheets. We use templates and Smartsheet Control center, but when creating a new sheet (using SCC or Save As New) the dynamic view(s) are not also copied/duplicated. This creates a LOT of manual re-work. It'd be great if, from the Dynamic View…
Good afternoon, Recently there was a change that made searching a dropdown by typing inside of it switch from an exact match method where typing S would only show entries that begin with S to a search within method where typing S would show all results with the letter S in them. I can see how this would be beneficial in…
Custom branding works on Alert type automations, but it would be great if that same branding was applied to Update Request automations as well.
