Column Drop Down

jtomeaCH

Hello! I have a column drop down with a a list of products we sell. I do not want to lock it down as we continually have new products coming in. I would like to know when my team adds something new. They do not add it to the list, just type it into the space. Is there a way to have an exception report or list of products that are not on my drop down so I can decide if they need to be or not? Thanks!

Nick Korna

Hi @jtomeaCH .

Here are a couple of options:

Have a separate sheet of the existing dropdown options and use a helper column to do a MATCH on what is entered:

=IFERROR(MATCH(Dropdown@row, {Match product list}, 0), "New")

This can then trigger an automated workflow to inform you when a "New" value appears in the relevant column.

Alternatively, you could skip this by having a workflow having a step like this:

In this example, your existing products are the 3 listed options, but as this will show as a tickbox list it doesn't take too long to fill out.

You can then have this inform you when new products have been added.

Hope this helps give you a couple of ideas, but if you've any problems/questions then just post them.