Lengthy text value in dropdown not a pickable option in certain filters

Question

Hi,

I have a dropdown column in a sheet. The column contains 98 separate dropdown values. I've noticed that one of the values (the longest one) doesn't show in the list when trying to filter using the "is one of" or "is not one of" options. All other 97 dropdown values display.

This is the name of the value that doesn't show in the filters: "Rx Stars: Pharmacy Stars Quality (PSQ) Report: Best Practices, Quarterly Strategies, Enhancements, and Performance Management (Ongoing)". As you can see in the image above, I've pointed to where it should be listed, but isn't.

Is there a character limit for a dropdown value to show when using these filter options?

Of course I can still do a manual "contains" filter to find this value, but that's pretty inconvenient, and not all of my users will know to do that. I can see users thinking there aren't any records containing this value when there actually are because they're expecting the "is one of" & "is not one of" filters to work properly.

cjsregcam · Answer

Never mind. I found this thread confirming that 100 characters is the limit for a dropdown value to be selectable in a filter. I also tested this limit myself and found that once a value reaches 101 characters it disappears from the list of selectable values in the "is one of" and "is not one of" filters.

https://community.smartsheet.com/discussion/78560/limited-characters-for-a-condition-within-a-workflow

cjsregcam · Answer

Hi, AJ. I checked and there's no white space in front. The issue isn't that the value can't be entered into the sheet rows, it's that it doesn't show up as an option when filtering.

hello_aj · Answer

Can you check if the item you listed has a white space in front? I tried the text on a dropdown and looks like its working OK on my end.