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.

Comments

  • 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.

     

    Craig

  • 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

     

    Craig

  • Kate French
    edited 05/30/16

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

This discussion has been closed.