Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Shading alternate rows

03/31/16 Edited 12/09/19

Is it possible to define a default condition on sheets so alternating rows are shaded? This would improve our readability. Many people add to this sheet, so creating them manually is a major pain.

Comments

  • J. Craig WilliamsJ. Craig Williams Top Contributor

    Do they add at the bottom or in the middle?

     

    Craig

     

  • Take a look at this previous discussion in the community.  This will work if they are adding to the bottom of the sheet.

     

    https://community.smartsheet.com/discussion/alternating-row-colors

     

  • We want to add at the top, but haven't figured out how to do that, so we add to the bottom and then sort after each addition. I searched the discussion threads before posting but didn't use the perfect key words!! Thanks.

     

    If you know how to add to the top of the sheet, let me know!!!

     

  • J. Craig WilliamsJ. Craig Williams Top Contributor

    Cherie,

     

    If you are using Joel's color formula

     

    =IF(Color1 = 0, 1, 0)

     

    instead of pointing to the row ABOVE it (this example is for row 2)

    point to the one BELOW it

     

    =IF(Color3 = 0, 1, 0)

     

    and copy that to the rest of the column.

    When you add a new row at the top, it will auto-fill AFTER you type in something.

    But it will.

     

    Craig

This discussion has been closed.