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!

Find more posts tagged with

Formulas

Accepted answers

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

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.