Hey gang,
Is there a limit to how many pieces of data can show up in a data validation list? I'd like to make a list of 50,000 options and can't seem to get more than half of those on my list. Currently have all items with the range name as "title" and that's what I've put as the range for the table.
Any help would be greatly appreciated!
Is there a limit to how many pieces of data can show up in a data validation list? I'd like to make a list of 50,000 options and can't seem to get more than half of those on my list. Currently have all items with the range name as "title" and that's what I've put as the range for the table.
Any help would be greatly appreciated!