INDEX / MATCH Formula Question

Marcela Hernandez
Marcela Hernandez ✭✭✭✭


I am missing something with executing this formula. This is my first time trying to apply to my sheet. I can only successfully return a #Unparseable error. 😥 Would appreciate any guidance you can provide.

Formula: =INDEX({CI Weight}), MATCH([Task Name]@row, {Project Name}, 0)

Goal: Pull in ranking (CI Weight) from source sheet

Thanks so much in advance!! 🤩

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!