Index/Match formula not working

Hey community!

I've been using this Index/Match formula for a while now and suddenly, when I copy/paste it into a new sheet from my template sheet, I am getting an #INVALIDREF error. I didn't change anything and I have confirmed that it is pointing to the correct references so I don't know what is going wrong.

Is there anything that looks wrong about this formula?

Anything that might be causing it not to work suddenly?

=INDEX({SF Phase Mapper Range 2}, MATCH([Active Stage]@row, {SF Phase Mapper Range 1}, 0))

Thanks! and Tagging my formula guru @Paul Newcome for visibility!


Kelly L. Gabel


Tech-Savvy Academy

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!