Sign in to submit new ideas and vote
Get Started

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. πŸ˜‰

76
76 votes

On Radar Β· Last Updated

While this change is not part of our current plan, we appreciate you sharing this idea. We hope that some of the alternatives proposed in this post help you in the short term. Please keep commenting on this and other ideation posts that interest you – your feedback plays a big role in shaping our decisions for the future.

Comments

  • Genevieve P.
    Genevieve P. Employee
    edited 10/20/22

    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)

    Screenshot 2022-10-20 at 14.13.33.png

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

    Screenshot 2022-10-20 at 14.12.00.png

    Cheers,

    Genevieve

    Need more information? πŸ‘€ | Help and Learning Center

    こんにけは (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!πŸ‘‹ | Global Discussions

  • Cindy Zobrist
    Cindy Zobrist ✭✭

    @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. πŸ™‚

    Need more information? πŸ‘€ | Help and Learning Center

    こんにけは (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!πŸ‘‹ | Global Discussions

  • Cindy Zobrist
    Cindy Zobrist ✭✭

    Thanks for your time and help! :)

  • Rick Olsen
    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
    David3_DigitalFlows ✭✭✭

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

    Davide Musmeci, PhD

    Project Management Professional

    www.digitalflows.eu

  • Rick Olsen
    Rick Olsen ✭✭✭✭

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