Getting a cell to return the value above it plus 1 if another cell is true

Options

I am trying to apply a formula to the whole column that is a countif but it returns an error. I want the cells in [wheel id] to count the number of trues in [new wheel] but only that row. Picture attached. This only returns the overall total of trues.


Best Answer

  • parulmishra
    parulmishra ✭✭✭✭✭
    Answer ✓
    Options

    Hi @MaCabe

    You need to, give an additional condition to count only thos rows which are above your existing row something likes this

    =COUNTIFS(New Wheel:New wheel, Row:Row, @cell <= Row@row, New Wheel:New wheel,@cell,=1)

    Parul Mishra

Answers

  • parulmishra
    parulmishra ✭✭✭✭✭
    Answer ✓
    Options

    Hi @MaCabe

    You need to, give an additional condition to count only thos rows which are above your existing row something likes this

    =COUNTIFS(New Wheel:New wheel, Row:Row, @cell <= Row@row, New Wheel:New wheel,@cell,=1)

    Parul Mishra

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!