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.
Shade every other row in Grid View
Comments
-
This can be done using a checkbox column with an IF formula. In row 2 of the checkbox column, add this formula:
=IF(CB1 = 1, 0, 1)
This will keep the box unchecked if the box above it is checked and will check the box if the box above it is unchecked. Drag fill this formula down your entire sheet, which will check every other row. Next, set a conditional formatting rule that will grey the entire row if the box is checked. Then hide the checkbox column. With auto-filling formulas, the formula will be added to new rows you add.
-
Hi, sorry to resurect this post; however, I like this solution the only issue I have is that it breaks when you re-sort rows. I have chnged the formula to look to see if the cell below is checked (as there are always blank rows at the bottom of the sheet). what I have found is that when resorting the sheet the checkbox formula is still 'locked' into the original cell that was below the row in question. Hope that makes sense.
Is there somethign I'm missing or is there an alternative way to get the alternate row highlight?
Thanks,
Marc
-
I would also love a soultion to the this when sorting and/or filtering!
-
I'm just trying thus but getting an UNPARSEABLE flag when I paste the formula in (=IF(CB1 = 1, 0, 1)).
Any help?
Many thanks,
Dan Chambers
-
OK, sorted via a different route:
https://community.smartsheet.com/discussion/alternating-row-colors
using: if(column name1 = 0, 1, 0)
No checkbox column, but creates a binary column (0, 1, 0 ...), then conditional formatting for the row colour.
This still gets messed up when sorting, though as the row shading moves with the data....
Thanks
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives