(Index(Collect
I am using the (Index(Collect formula as well and it is telling me that my formula is "#UNPARSEABLE". Could someone help me with this? I tried using the following format "INDEX(COLLECT({Column to return}, {Column 1 with value to match}, "Value 1", {Column 2 with value to match}, "Value 2")", but it unfortunately stopped working. I can't seem to figure out why.
Answers

#UNPARSEABLE almost always indicates a syntax issue, usually something like a missing parentheses. You always have to have an end parentheses to close off each function in a formula. Then there's the missing row_index parameter in the INDEX portion of the formula. Try adding a comma, space, 1, end parentheses at the end like below and see what happens.
=INDEX(COLLECT({Column to return}, {Column 1 with value to match}, "Value 1", {Column 2 with value to match}, "Value 2"), 1)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!