Collecting a check box

Hi All,

The equation below is one that I have used elsewhere under the same circumstances: trying to mark a box based on another sheet that may have several entries. The index match won't work as it only will take the first entry ignore the next different entry for a particular client.

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

Annabelle Pruned is a Boolean and Pee Gee Name is a text box.

The error is unparseable.

I am always so grateful for the help I get here. I wish I could reciprocate.

Find more posts tagged with

Accepted answers

All comments

Georgie

Hi @Craig Lemberger,

Looks like you've received an answer to this question on a separate thread here. Let us know if you need any additional help!

Thanks

Georgie

Craig Lemberger

Thank you Georgie. Indeed Kerry helped me and solved my issue.

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.