Row Color For Easier Visuals

BESP10

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 

Andrée Starå

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

Mike L.

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