Remove Formula Error if blank

HSabin

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!

Hollie Green

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

Hollie Green

=IFERROR(INDEX(COLLECT({$ Amount}, {POC DRAFT | Brand}, Brand@row, {POC DRAFT | Change Type}, "Shift Media to Non-Media"), 1)"")

HSabin

Thank you for the help, Hollie. Unfortunately the system is giving me an error that the syntax isn't right.

HSabin

Hollie Green

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

HSabin

That did it! Thanks so much for the help here, Hollie!