Auto-Number/System for Child Rows Only

Options

Is there a way to have an Auto-Number/System column only auto-increment in child rows, while avoiding auto incrementing of parent rows?

Answers

  • Antonio Figueroa
    Antonio Figueroa ✭✭✭✭✭✭
    Options

    In Column number 32 put this formula. =Count(Parent())

    In Column33 on row two Put this formula =sum($[Column32]$1:[Column32)@row)

    In column34 put this formula =IF([Column32]@row = 0, "", [Column33]@row)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!