Column Drop Down

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
    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.