Assistance with UNPARSEABLE error
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”)
Best Answer
-
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….
Answers
-
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….
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!