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
Remark: The maximum number of elements in the drop-down list and autocomplete using the lookup formula is 50.
On the other hand, if you retrieve values from a table, there is no maximum number of elements.
0 Comments