Limit to Dropdown values?

jmpbell · 03/27/20

We're creating a sheet where we want to have a column of a dropdown single select type. What is the limit to the number of values? For example, we have hundreds of departments we want to choose from, but have the submitter choose one from that list.. how many can be on the list?

Paul Newcome · 03/27/20

So I did 15,000 options in a Multi-select... It let me enter all of them. It saved and everything. The only two issues I ran into were that it was REALLY slow to load when you click in the cell to use the dropdown, and it is still limited by the 4,000 characters per cell limit.

Andrée Starå · 03/27/20

Hi,

I don’t know the limit because I haven’t reached it. 😉I don't think you'll reach it.

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

jmpbell · 03/27/20

So is there a limit? You say I can't reach it which implies there is one.

Andrée Starå · 03/27/20

The limit is 5000.

Paul Newcome · 03/27/20

@Andrée Starå Did you actually go in and add 5,000 values to a dropdown list, or did you find some documentation on it? I wonder if it is the same for Multi-select. Now I have to try... Haha

Paul Newcome · 03/27/20

So I did 15,000 options in a Multi-select... It let me enter all of them. It saved and everything. The only two issues I ran into were that it was REALLY slow to load when you click in the cell to use the dropdown, and it is still limited by the 4,000 characters per cell limit.

jmpbell · 03/27/20

Thank you everyone!

Andrée Starå · 03/27/20

@jmpbell Happy to help!

✅Remember! Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå · 03/27/20

@Paul Newcome

There was an official answer for the limit.

Also,

https://media.giphy.com/media/3oxRmGXbquXKz6DNPq/giphy.gif

🤣

Paul Newcome · 03/30/20

@Andrée Starå Haha. It is really easy to populate 15,000 rows relatively quickly in Excel and then copy/paste over to my Smartsheet column properties, and finding out that it was still restricted to the 4,000 character limit was as simple as checking the box to "Select All" in the dropdown. Hahaha

Kara Lumley · 05/12/20

Hi all,

There is not currently a limit of 5,000 values in a single or multi-select dropdown column.

There IS a limit of 4,000 characters in a cell.

Hope this helps,

Kara

Tana Rucker · 04/07/21

@Kara Lumley do carriage returns/lines count as a character?

Paul Newcome · 04/07/21

@Tana Perkins I believe so because it is picked up by the LEN function.

Tana Rucker · 04/07/21

Thanks @Paul Newcome!

Paul Newcome · 04/07/21

@Tana Perkins Happy to help. 👍️

JeremiahHorstick · 08/02/22

Hi, I recently tested the limit and it is 20,000 exactly setting the dropdown options using the API.

Limit to Dropdown values?

Best Answer

Answers

🤣

Categories