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
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!