Should VLookup Still Work On Referenced Sheet With Row Archive Active?

Jacob LeC
Jacob LeC âś­
edited 03/15/22 in Formulas and Functions


Formula works for a few days then starts kicking out.

=IF([Tool Number]@row = "", "", VLOOKUP([Tool Number]@row, {Schedule Range 1}, 3, 0))

Currently have to update the references every day or so.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!