Row Color For Easier Visuals
![BESP10](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Good afternoon,
Is there a setting that we can set up so that every other row is a different so that it is easier to follow data across all columns when looking at the sheet?
Would like every other row to be gray to tell difference from the white rows.
Thank you
Comments
-
Hi,
Unfortunately, it's not possible at the moment, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
As a workaround, you could set up a solution with conditional formatting. One easy way would be to create a helper checkbox column and check the first row and then fill down from the second row. Then you would set up a rule in the conditional formatting to only color the rows where the box is checked.
Edit: I might have a way to keep it correct even if rows change places. I'll test it out and get back to you.
Would that work?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
This post provides a formula for the helper column with formula =IF(INT([Row ID]1 / 2) = [Row ID]1 / 2, 0, 1) and also discusses the limitations of this work around.
https://community.smartsheet.com/discussion/conditional-formatting-filter-oddeven-numbers