Unable to convert a vlookup formula into values

Rod H
Rod H
edited 07/13/23 in Formulas and Functions

I have multiple columns with column formulas built that do a lookup into another Smartsheet. Want to convert the lookup values into values in the workbook that I built the formulas in, and then delete the workbook that is currently being referenced to find lookup.

I cannot figure out how to do it.

I do not see an option to copy and paste values. In Paste Special it only offers paste format, not paste values

Does anyone know a solution?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!