Is it possible to use conditional formatting on every other row?
You know, like in excel, it is helpful to highlight every other row.
Can that be done in smartsheet?
thx,
Laura
Best Answers

Hey @laura.buchanan
To my knowledge, the short answer is no. Here's a possible workaround, if you aren't deleting or moving rows around.
You'll need a helper checkbox column to use in the conditional formatting. You'll also need the system generated autonumber (ie Row ID).
=IF(ISODD([Row ID]@row), 1)
There is also an ISEVEN if that is your preference.

Hi @laura.buchanan,
Here's a method that will allow you to delete/move/sort rows at will and still maintain the every other row formatting:
Create an 'AutoNumber/System...' column and choose AutoNumber. In this case, I named the column "X."
Create a new Checkbox column and enter this as a column formula:
=IF(ISEVEN(MATCH(X@row, X:X)), 1)
Now just setup conditional formatting to shade any columns where the box is checked and you should be all set.

Thanks so much!

Not answered=IF(ISEVEN(MATCH(X@row, X:X)), 1) gives #CIRCULAR REFERENCE

Sadly that's not the behavior I'm getting. If I start with a sheet of 5 rows, the autonumber/system column numbers 15. If I delete row 4, the autonumber/system column now shows 1,2,3,5 and refreshing doesn't reorder it. Here's how I have the autonumber column defined. I've tried with and without specifying "1" as the starting number.
Answers

Hey @laura.buchanan
To my knowledge, the short answer is no. Here's a possible workaround, if you aren't deleting or moving rows around.
You'll need a helper checkbox column to use in the conditional formatting. You'll also need the system generated autonumber (ie Row ID).
=IF(ISODD([Row ID]@row), 1)
There is also an ISEVEN if that is your preference.

Hi @laura.buchanan,
Here's a method that will allow you to delete/move/sort rows at will and still maintain the every other row formatting:
Create an 'AutoNumber/System...' column and choose AutoNumber. In this case, I named the column "X."
Create a new Checkbox column and enter this as a column formula:
=IF(ISEVEN(MATCH(X@row, X:X)), 1)
Now just setup conditional formatting to shade any columns where the box is checked and you should be all set.

Thanks so much!

Hi there  I'm attempting this method and when I sort it throws off the conditional formatting. I'm sure I'm missing something, any help would be appreciated. I tried locking and freezing the new columns but that didn't work.

Not answered=IF(ISEVEN(MATCH(X@row, X:X)), 1) gives #CIRCULAR REFERENCE

Hi @Sue Hill
You'll want to ensure this formula is in a separate column to the one you're referencing. The "X" column should be an autonumber column, and then there is a new column to house the formula, like so:
Cheers,
Genevieve

I did perform this, working....figured it out later that day.

@John Pudar thank you for sharing this. =IF(ISEVEN(MATCH(X@row, X:X)), 1) worked for me just like you said.
However if I delete a row from my sheet somewhere in the middle the autonumbered list doesn't reorder itself automatically to close the gap from the now missing number. Is there any way to regenerate the list easily without deleting the column(s) and recreating them any time I have to delete a row? thanks!

Hi @Samscho  if you make sure that the "X" column is an 'AutoNumber/System...' column then you should be fine. You may need to refresh the sheet after a change to get the autonumbering to update, which in turn will update the conditional formatting. But as long as the column you're referencing in the MATCH function is an AutoNumber/System column it should work for you.

Sadly that's not the behavior I'm getting. If I start with a sheet of 5 rows, the autonumber/system column numbers 15. If I delete row 4, the autonumber/system column now shows 1,2,3,5 and refreshing doesn't reorder it. Here's how I have the autonumber column defined. I've tried with and without specifying "1" as the starting number.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 62 Global Discussions
 46 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!