VLookup's in Smartsheet - Are there limitations?
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.
Best Answers
-
You cannot reference more than 100,000 cells, and you cannot have more than 100 unique cross sheet references on each sheet.
-
That is correct.
Answers
-
You cannot reference more than 100,000 cells, and you cannot have more than 100 unique cross sheet references on each sheet.
-
@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?
-
That is correct.
Help Article Resources
Categories
Check out the Formula Handbook template!
