Index Match

Hello All,

=IFERROR((INDEX((COLLECT({Annabelle Pruned}, {Client Name (Pruning)}, [Client Name]@row, {Annabelle Name}, "Annabelle"),1),0)

This formula I've used (with the help of the pro desk) elswhere under the same circumstances as the one above:

Anabelle pruned is a Boolean, Annabelle Name is a text box.

The error is unparseable.

You all are always so helpful. I wish I were in a position to reciprocate. :)

Thank you for your help in advance.

Find more posts tagged with

Formulas

Accepted answers

Kerry St. Thomas

It appears that there's an inconsistency in parenthesis pairing. There are 5 ('s and 3 )'s. I did a quick test, and from what I did, if you replace the double (( on either side of INDEX with a single ( …issue solved. Of course you'll want to verify the ranges.

And if I may make a recommendation? Get super familiar with how COLLECT works. It'll be your best friend. 😀 See this link for more information about the function:
https://help.smartsheet.com/function/collect

Good luck!

All comments

Kerry St. Thomas

Good luck!

Craig Lemberger

Thanks Kerry. I seem to make these small mistakes often. Ugh. Much appreciated.

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.