Column Formula with VLOOKUP using External Reference

Kevin Miller

I love the new column formula functionality! I'm converting to it whenever possible.

I am trying to create a column formula that includes a VLOOKUP that uses an external reference for the data set.

=VLOOKUP($ROWID@row, {~ Master List Range 1}, 2, false)

I am getting an error message, and I think it's because of the external reference. What is the proper syntax for this?

Find more posts tagged with

Formulas

Cell linking

Accepted answers

AverageUser

Kevin, I believe it is the $ that is causing your issue. I was working on a similar issue and found a list of things that aren't compatible with the new "Column Formula" feature. One of those items was "Absolute References".

The error message that you're getting probably has a link to the following url, which is where I found the part about "Absolute References" being incompatible:

https://help.smartsheet.com/articles/2481944

Is the "Absolute Reference" necessary for your use?

All comments

AverageUser

The error message that you're getting probably has a link to the following url, which is where I found the part about "Absolute References" being incompatible:

https://help.smartsheet.com/articles/2481944

Is the "Absolute Reference" necessary for your use?

Kevin Miller

That fixed it, thank you! The absolute reference is no longer needed with the column formula.

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.