How can I tell if an item is in the drop down list

oaishm

In Google sheets, you can tell if an item is in a dropdown list or not by the handy red caret on the upper right corner of the cell:

Is there an equivalent here?

Andrée Starå

Hi,

Unfortunately, there isn't, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

 

Paul Newcome

One workaround would be to have a list of all available options within the dropdown. You could then use a helper flag type column with a basic formula that will generate a flag if the value input is not on the list.

 

=IF(NOT(CONTAINS([Selection Column]@row, [Reference Table]:[Reference Table])), 1)

.

You can then either display this flag or use conditional formatting to provide a visible alert that the option is not available, or use it to trigger any number of automations.