Unable to convert a vlookup formula into values

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?

Thanks

Find more posts tagged with

Formulas

Accepted answers

Rod H

A Big Thank You! to both Paul and Itai! Yes you have the answer. Deeply appreciated.

Rod

All comments

Paul Newcome

Are you able to provide a screenshot of the poste special menu? I have always had "Paste Values" as an option.

Rod H

Rod H

Paul Thanks for checking in, is that what you requested?

Paul Newcome

That's exactly what I was asking for but not what I expected to see. Are you pasting into the same sheet that you are copying from?

Rod H

yes

Paul Newcome

Are you highlighting multiple cells before trying to paste? Are all cells that you are copying adjacent?

Rod H

yes, copying and pasting in the same column/cell

Paul Newcome

Can you provide a series of screenshots that shows the cells along with each step of what you are doing?

Paul Newcome

And do you have any filters applied to the sheet?

Rod H

I do not have any filters applied.

The first screen shot is a small overview of the sheet.

List of products (not showing) on far left and at the top is headers of categories of different attributes of products.

in the screen shot is the formula, the reference "Meat Hierarchy" is the name and range in the "other" sheet being referred to.

Rod H

I highlighted all the data in the column and click copy

Then I click Paste Special and get the following

Itai Perez

@Rod H,

You cant paste values into a coulmn formula column. you can convert the column formula to a cell formula and then paste it as values but it will not be a column formula column anymore.

Do you have access to DataMesh? it could help and make it easier.

Paul Newcome

You will need to covert to cell formula before pasting.

Rod H

A Big Thank You! to both Paul and Itai! Yes you have the answer. Deeply appreciated.

Rod

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.