Hide the rows with error without blocking the calculation

lepote 8003

Hi Guys,

I have a scenario here. I need to refer another sheet and I have to skip the count when the cell have any error. How should I perform that in smartsheet. Can anyone help with this one?

With Regard

lepote Jo

Paul Newcome

You would need to use an IFERROR function on the source data to "remove" the error.

lepote 8003

https://community.smartsheet.com/discussion/comment/296584#Comment_296584

Hi @Paul Newcome ,

Appreciate for you quick response. We can use "IFERROR" formula I got it, but I need some sample formula to follow there

Scenario: I need to perform a COUNT action by referring to the another sheet. In the reference sheet I need to select a column to perform my counting calculation. If I got any error in any of the cell in the column I want to skip that cell and continue my COUNT operation to bring the result.

I need a formula format/example to perform can you kindly assist with this?

With Regards,

Lepote Jo.

Paul Newcome

Right. So you will need to go to the sheet you are referencing and adjust the formula that is outputting an error. You will need to wrap that formula in an IFERROR.

=IFERROR(original_formula, "")

https://help.smartsheet.com/function/iferror

lepote 8003

Hi @Paul Newcome

For more clarification I'll attach the formula here "=IFERROR(COUNT({BP Tracker 2021 Range 5}))"

1. BP Tracker 2021 Range 5 - Reference sheet selected column.
2. I want to ignore the errors and count the column.

With regards,

Lepote Jo

Paul Newcome

Ok. Whatever "Range 5" is referencing... Go there. The formula that is triggering an error there, wrap that one in the IFERROR.