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"))), "")

• ✭✭✭✭✭✭
Options

You need to use an IFERROR to get rid of the divide by zero errors.

• ✭✭✭✭
Options

Thanks @Paul Newcome

I got the % over 90 to work with if error but im not 100% sure on this one

=SUM([90+]@row:[180+]@row)

i tried this =IFERROR([90+]@row:[180+]@row, "") but it didnt work

• ✭✭✭✭✭✭
Options

What do you mean by "it didn't work"? Is it throwing an error? Is it outputting something different? Is it breaking something else?

• ✭✭✭✭
Options

@Paul Newcome yes when i use that formula i am getting an Invalid Column Value error

• ✭✭✭✭✭✭
Options

Oh. Because you aren't keeping the SUM function in there.

• ✭✭✭✭
Options

okay so add the SUM, im still having a bit of trouble on where to place it ive tried the below, neither worked

=IFERROR(SUM[90+]@row:[180+]@row, "")

=SUM([90+]@row:[180+]@row, IFERROR(90+ Total(@cell), ""))

trying to go through old threads and find my answer but im just not getting it correct.

• ✭✭✭✭✭✭
Options

In the first one, you need to close out the SUM function before moving on to the second part of the IFERROR.

=IFERROR(SUM(.....), "")

• ✭✭✭✭
Options

thank you! it seemed to accept that formula but i am still showing zeros

• ✭✭✭✭✭✭
Options

How exactly are those columns being populated?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!