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

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.


  • J. Craig Williams
    J. Craig Williams Top Contributor

    Do they add at the bottom or in the middle?




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




  • 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 Williams
    J. Craig Williams Top Contributor



    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.



This discussion has been closed.