=(INDEX(COLLECT Invalid Value Error

I am getting an Invalid value error in this formula:

=(INDEX(COLLECT({Zit Zap 102621 Units Needed}, {Zit Zap 102621 Formula}, Formula@row, {Zit Zap 102621 Inv ID}, [RM Inventory ID]@row), 1))

I'm trying to bring in the RM Units Needed from Spreadsheet 2 when the Formula and RM Inventory ID from Spreadsheet 2 matches the Formula and RM Inventory ID on Spreadsheet 1. The error is on Spreadsheet 1.

Any suggestions?


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!