INDEX, COLLECT, CONTAINS Formula help

Hi!

I have a formula that is working the way I want...

=IFERROR(INDEX(COLLECT({LFH Date}, {LFH Date}, @cell > TODAY(), {LFH Analyst}, Name@row), 1), "")

But when I add another condition, I get #INCORRECT ARGUMENT SET. This is the formula:

=IFERROR(INDEX(COLLECT({LFH Date}, {LFH Date}, @cell > TODAY(), {LFH Analyst}, Name@row, {LFH Location}, CONTAINS("Home", @cell)), 1), "")

Any ideas on what may be the problem?

Thanks!

Find more posts tagged with

Accepted answers

All comments

KPH

The formula looks good. Can you click on the cell with it in, as if you were editing it, and take a screen shot?

Beth C

Hi KPH,

Thanks for the response. I ended up making a helper column in the source sheet that showed LFH Analyst if Location contained "Home." There's always another way, correct? 😁

KPH

Glad you got what you needed :)

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.