Item option is visible only for Dropdown and Autocomplete cells, this option provides items for those cells. Items are provided as formula results and has to be in a form of an array.
Examples of items formula:
=LOOKUP(COUNTRY, NAME) - formula returns List of country names
=Section1.A1:A10 - formula returns the range from Spreadsheet section
=Section1.B - formula returns the range column B from Table section
=ARRAY(‘one’, ‘two’, ‘three’) - formula returns an array of three provided values
The maximum number of items in an autocomplete cell using the lookup formula is 200. This means that when you start typing in the autocomplete field, the values will be filtered and those that start with the characters entered by the user will be displayed, but only within the first 200 results. The query function is an exception, as it is not limited to 200 results. You can read more about it in the query article.
Remark: The maximum number of elements in the drop-down list and autocomplete using the lookup formula is 200. On the other hand, if you retrieve values from a section, there is no maximum number of elements.
0 Comments