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.
Comments
-
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!!!
-
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
