VLookup's in Smartsheet - Are there limitations?

Tonya Sloan

Does anyone know if Smartsheet has a threshold limit on the number of VLookups that can be used within one sheet? I have 7 columns with a max of 300 rows of data in a Target sheet, I am wanting to run VLookup's with to 3 different Source sheets and I want to make sure there's not some crazy limit that says your formula will no longer work if you have more than 5,000,000 cells that are being referenced. Or something like that. Thank you for the response.

Paul Newcome

You cannot reference more than 100,000 cells, and you cannot have more than 100 unique cross sheet references on each sheet.

Paul Newcome

That is correct.

Paul Newcome

You cannot reference more than 100,000 cells, and you cannot have more than 100 unique cross sheet references on each sheet.

Tonya Sloan

@paulnewcome Thank you for your prompt reply. So if any one source sheet has no more than 300 rows and the target sheet has no more than 300 rows and there are a max of 7 columns that will be running a different VLookup, I should be fine correct? Again, because this is per sheet limitation and not user account or enterprise wide?

Paul Newcome

That is correct.