Hide the rows with error without blocking the calculation
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
Answers
-
You would need to use an IFERROR function on the source data to "remove" the error.
-
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.
-
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, "")
-
For more clarification I'll attach the formula here "=IFERROR(COUNT({BP Tracker 2021 Range 5}))"
- BP Tracker 2021 Range 5 - Reference sheet selected column.
- I want to ignore the errors and count the column.
With regards,
Lepote Jo
-
Ok. Whatever "Range 5" is referencing... Go there. The formula that is triggering an error there, wrap that one in the IFERROR.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!