Cross sheet reference,

Options
vipul
vipul ✭✭
edited 09/11/23 in Formulas and Functions

I'm writing to you because I'm having some trouble with cross sheet reference formulas. I lost all of the formulas in my sheet, and now when I try to add a new one, it works fine for the first row, but when I drag it to another row, it says "no match." I'm sure that the formula was working fine before, but I'm not sure what's wrong with it now.

Can you please help me troubleshoot this issue? I'm really not sure what else to do.

=INDEX({stocksupplier}, MATCH(CODE@row, {stockcode}))

It works fine for First Row, the movement i drag it t apply to another row it Says "~NO MATCH


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!