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”)

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….

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….