Autocomplete cells are configured exactly like Dropdown cells, see: dropdown cells.
The difference is with end user usage, dropdown with values appears when a user starts typing inside a cell, only values that start with typed text are displayed.
Autocomplete cell example
Remark: The maximum number of elements in an autocomplete cell using a lookup formula is 50.
On the other hand, if you retrieve values from a table, there is no maximum number of elements.
0 Comments