Results shows #UNPARSEABLE

jackiey001 ✭✭
edited 09/19/23 in Formulas and Functions


I recently came across a very helpful answer from here:

I have applied the formula to my sheet, but it was returning UNPARSEABLE. I tried another column and it works fine.

Below is the value that is resulting in UNPARSEABLE

Sample Formula is =INDEX({Sheet B Column B}, MATCH([Invoice Number]@row, {Sheet B Invoice Number Column}, 0))

My Formula is =INDEX({Samples QTY to be Shipped, MATCH([Sample Type]@row, {Sample Type REF}, 0))

What is the issue here?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!