Assistance with UNPARSEABLE error

Michelle St George

Looking for another set of eyes as I'm getting an UNPARESABLE error… I can't seem to find the issue …

Details

Using an INDEX MATCH from a checkbox column to populate a Text/Number column

Formula

=IF(INDEX({_Checkbox}, MATCH([Site ID]#, {SiteID}, 0))=true, “Yes”, “No”)

Find more posts tagged with

Accepted answers

Michelle St George

WORKING

Well… I ended up creating a test checkbox column to validate my index match (which worked fine) then copied the index match back into my original formula and it worked…

Not sure why SS sometimes doesn't like formulas for no apparent reason….

All comments

Michelle St George

WORKING

Well… I ended up creating a test checkbox column to validate my index match (which worked fine) then copied the index match back into my original formula and it worked…

Not sure why SS sometimes doesn't like formulas for no apparent reason….

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.