Remove Formula Error if blank
I am pulling in data from another sheet based on conditions in the sheet. I can't figure out how to hide the formula error if the value from the other sheet is blank. There will be many cells with blank values and a few that have values to pull in and the formula errors overwhelm the sheet.
Formula I'm using:
=INDEX(COLLECT({$ Amount}, {POC DRAFT | Brand}, Brand@row, {POC DRAFT | Change Type}, "Shift Media to Non-Media"), 1)
Any help would be GREATLY appreciated. Thank you!
Best Answer
-
apologies I missed typing a comma after ,1) it should be
=IFERROR(INDEX(COLLECT({$ Amount}, {POC DRAFT | Brand}, Brand@row, {POC DRAFT | Change Type}, "Shift Media to Non-Media"), 1),"")
Answers
-
=IFERROR(INDEX(COLLECT({$ Amount}, {POC DRAFT | Brand}, Brand@row, {POC DRAFT | Change Type}, "Shift Media to Non-Media"), 1)"")
-
Thank you for the help, Hollie. Unfortunately the system is giving me an error that the syntax isn't right.
-
-
apologies I missed typing a comma after ,1) it should be
=IFERROR(INDEX(COLLECT({$ Amount}, {POC DRAFT | Brand}, Brand@row, {POC DRAFT | Change Type}, "Shift Media to Non-Media"), 1),"")
-
That did it! Thanks so much for the help here, Hollie!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K 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
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!