INDEX-MATCH or VLOOKUP returns #INVALID REF when in COLUMN FORM

Options

Guys, Smartsheet is returning #INVALID REF after transforming the column to column form.

The formula is simple:

= INDEX ({Standard Tasks Reg. - 2021 - BASE AME Interval 1}; MATCH (Reference @ row; {Standard Tasks Reg. - 2021 - BASE AME Interval 2}))

or

= VLOOKUP (Reference @ row; {Standard Tasks Reg, - 2021 - BASE AME Interval 3}; 8; 0)

Observation: The sheets contains 5000 rows.

Can you tell me what could be happening?

Thanks.


  • Photo of the form inside the cell.
  • Photo as clumn form


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!