Line Shading - every other row

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 vote!

Find more posts tagged with

On Radar

Comments

Genevieve P.

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.

1st step: add in an auto-number system column. I called mine "Row".
2nd step: add in a text/number column with a formula to return a 1 or 0 for every other row.

=IF(ISEVEN(VALUE(MATCH(Row@row, Row:Row, 0))), 1, 0)

3rd step: set up Conditional Formatting based on that helper column

Cheers,

Genevieve

Cindy Zobrist

@Genevieve P. Thank you - thank you - thank you!!!!! You are amazing! Thanks so much for your quick response and resolution! 😊

Genevieve P.

No problem! Glad I could help. 🙂

Marc Shecter

Enable sheet admin or owners to apply alternating row colors.

Requirements:

With a minimum of clicks (Google Sheets does it in two).
Enable a selection of styles
Colors continue to alternate after sorting or filtering, adding or removing rows.
Choose to include header and footer in the styles
Enable the creation of custom styles

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.

Cindy Zobrist

Thanks for your time and help! :)

Kylie

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.

Rick Olsen

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.

David3_DigitalFlows

Hi @Rick Olsen can you please elaborate your comment about the dynamic row number? Thanks

Rick Olsen

It's been over a year, I don't remember… and not making headway in my thought process… :-)

ttfraz

The idea of dynamic row banding would be incredible. Alternate row shading that is continually maintained based on hierarchy collapse/expand and filtered views.

Quick Links

Trending ideas

Distinguish Access Acceptors from Admins
Our sheets & workspaces require many people to have Admin level capabilities, which means that when someone requests access to a sheet or workspace, that email is sent to every Admin. This causes confusion and higher risk of no access granted (because people have learned to ignore the emails) or the wrong level of access…
Allow system owners and system admins to view all assets
As one of the system admins, it is absurd to me that I cannot view or have access to all of the items created in my organization. We have over 11,000 reports, sheets, and dashboards and I can't see them. I have no visibility to if people are using our plan for their own personal use, or what kind of work is going on unless…
Keyboard Shortcut - Conversation
I noticed this the other day and tested Ctrl + M – it does not work. I submit ticket to Smartsheet support – they told me that’s expected behavior because it’s not currently available even though it still shows as keyboard shortcut in the menu🙄 and told me to submit new product idea. Please add this keyboard shortcut to…