Index Match

Hello All,

=IFERROR((INDEX((COLLECT({Annabelle Pruned}, {Client Name (Pruning)}, [Client Name]@row, {Annabelle Name}, "Annabelle"),1),0)

This formula I've used (with the help of the pro desk) elswhere under the same circumstances as the one above:

Anabelle pruned is a Boolean, Annabelle Name is a text box.

The error is unparseable.

You all are always so helpful. I wish I were in a position to reciprocate. :)

Thank you for your help in advance.

Tags:

Best Answer

  • Kerry St. Thomas
    Kerry St. Thomas Community Champion
    Answer ✓

    It appears that there's an inconsistency in parenthesis pairing. There are 5 ('s and 3 )'s. I did a quick test, and from what I did, if you replace the double (( on either side of INDEX with a single ( …issue solved. Of course you'll want to verify the ranges.

    And if I may make a recommendation? Get super familiar with how COLLECT works. It'll be your best friend. 😀 See this link for more information about the function:
    https://help.smartsheet.com/function/collect

    Good luck!

    If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!

Answers

  • Kerry St. Thomas
    Kerry St. Thomas Community Champion
    Answer ✓

    It appears that there's an inconsistency in parenthesis pairing. There are 5 ('s and 3 )'s. I did a quick test, and from what I did, if you replace the double (( on either side of INDEX with a single ( …issue solved. Of course you'll want to verify the ranges.

    And if I may make a recommendation? Get super familiar with how COLLECT works. It'll be your best friend. 😀 See this link for more information about the function:
    https://help.smartsheet.com/function/collect

    Good luck!

    If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!

  • Craig Lemberger
    Craig Lemberger ✭✭✭✭

    Thanks Kerry. I seem to make these small mistakes often. Ugh. Much appreciated.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!