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?

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?

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?

Kevin Miller

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