(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

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭

    @Ryan Gil

    #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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!