Blank cells, iferror?

Options

Hello! i think i need an iferror to ignore the blank cells but i havent fully wrapped my head around those yet :)



three things in this

  1. 90+ Total current formula is =SUM([90+]@row:[180+]@row) but i want to ignore the blank lines
  2. same for % over 90 current formula is =([90+ Total]@row / Total@row)
  3. adding the % over 90 as a formula screwed up my "Previous Month" which compared to a prior month and added directional arrows depending if they increase or decrease. current formula is =IFERROR(IF(Month@row <> "", IF(INDEX([% over 90]:[% over 90], MAX(COLLECT(Row:Row, Row:Row, @cell < Row@row, Insurance:Insurance, @cell = Insurance@row))) < [% over 90]@row, "Up", IF(INDEX([% over 90]:[% over 90], MAX(COLLECT(Row:Row, Row:Row, @cell < Row@row, Insurance:Insurance, @cell = Insurance@row))) > [% over 90]@row, "Down"))), "")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!