Index Match Formula Unparsable to Link Cells

We've been trying to link cells across sheets using variations of

=INDEX({Other Sheet Column A}, [Row #]@row)

and keep getting "UNPARSABLE." Since it is coming from a live form, too, cell linking won't work since that only pulls data that is already there.

Any help??

Answers

  • Matt Lynn-PCG
    Matt Lynn-PCG ✭✭✭✭✭✭

    @itpanther Can you give more detail? I mean your index formula is simple enough but what's this about a form? The formula will only ref data on the sheet.. nothing to do with the form. The form has no relevance on the formula at all. Either it pulls data from the sheet and it's data or it has no data thus it won't pull. You can't put a formula in a form. Sorry just trying to understand what you're doing. If you want that formula to always be in the column/row then you should add it as a column formula and not a cell formula. If you want to wrap that formula in an iferror() for when it's pulling blank data that would improve it, but I'm not sure what you mean about the form and live data.

    Certified Platinum Partner

    PrimeConsulting.com

  • itpanther
    itpanther ✭✭✭

    I'm trying to link data from one sheet to another, not the form.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Can you provide a screenshot of the formula open in a cell as if you are about to edit it?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!