Can i use iferror while using index(collect?

Hi, im trying do an index collect but i get an error when there is no value that meets the criteria. Can someone tell me if and where i can use IFERROR in the formula below?

=INDEX(COLLECT({Upcoming Jobs (High Level) Range 1}, {Upcoming Jobs (High Level) Range 2}, =[Date in Final]17, {Upcoming Jobs (High Level) Range 1}, <>[Job Name 1]@row ), 1)

Find more posts tagged with

Accepted answers

Darren Mullen

@Brandon Morales You can wrap that entire formula in an IFERROR, that will work.

All comments

Darren Mullen

@Brandon Morales You can wrap that entire formula in an IFERROR, that will work.

Brandon Morales

that worked! thanks for the help!!

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.