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.

Conditional Formatting - Filter odd/even numbers

Jay Bautista
edited 12/09/19 in Archived 2016 Posts

Is there a way to filter and do conditional formatting for odd/even numbers used from auto-number?


If not, I would like to pose this as an enhancement request.


  • You can add another colum with the formula 

    =IF(INT([Row ID]1 / 2) = [Row ID]1 / 2, 0, 1) 


    assuming that [Row ID]  is your auto-number.  If the row id is odd then you'll get 1 and 0 if even.


    You can then filter/do conditionnal formatting based on this column (see column 3 in the screenshot below).


    Hope this helps.



    Screen Shot 2016-05-26 at 3.34.17 PM.png

  • Jay Bautista
    edited 05/26/16

    Thank you! That formula works. But, it doesn't work on auto-number with prefix.

  • J. Craig Williams
    J. Craig Williams Top Contributor

    Fixed length prefix? 


    Check out the RIGHT() function.



  • Your auto-number column could be number only and another column can contain the whole string (prefix + auto-number)

    Screen Shot 2016-05-26 at 7.26.33 PM.png

  • These methods only work if you do not insert or move rows.  The row ID's are static and odd id numbers can be adjacent, negating the effect.  A real WBS numbering system is needed to make this work.  Or an ability to reference an item's actual row number.

  • J. Craig Williams
    J. Craig Williams Top Contributor

    +1 for reference to actual row number



  • Kate French
    edited 05/30/16

    I've got your votes for this logged to our enhancement request list!

This discussion has been closed.