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.
Tags:
0
This discussion has been closed.
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