![]() Invalid data - Show warning: if enter an invalid or out of range value in the cell row, you'll see a warning message top right in the cell ( red colour).If uncheck, dropdown will remove the cell which highlights. Show dropdown list in the cell: this checkbox represents the show/hide option. ![]() List from a range: enter cell range which allows to the dropdown option, it will cell reference or name range.But if you have a large set of list item google sheet recommend name range instead of the list item. List of items: enter option items separated by a comma you can keep up to 500 items.Value Field: this will change based on your criteria type.List of item & List from a range applicable for dropdown) Criteria Option: this is a defined condition type that needs to be implemented. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |