How to remove the used options from a Dropdown Menu

Google Sheets is used by many in building all kinds of tables, easy or complex calculations for business but also for personal use. 

When using a dropdown menu you are generally looking for data consistency. You do not want to have different ways of writing your data as you might want to be able to filter your table, create summaries, or maybe graphs, and having 2 columns reading Flowers and Fowers will be a pity.

But now, what if you want to make sure that you are only using ONCE the options you select in the dropdown menu. Let's say that in the morning you have a list of activities that you need to do until the end of the day. If the list contains 2 - 3 items is not hard to follow them one by one. But what if you need to organize 20, 30, 100 actions for the week? Following up on what job was done and that not could slow you down.

Let's see if we can build a small scheduler in Google Sheets. We will have different actions that can be done by the team using various pieces of equipment. 

As this is not a real Workload Scheduler but more a case study to show how to remove the used options from a Dropdown Menu here is the limited setup: we have a printer, a laminator and a cutter, 2 employees and 4 jobs for the day:

• Print the Coca Cola campaign (est 2 h)
• Laminate the Coca Cola campaign (est 0.5 h)
• Print the Pepsi campaign (est 2.5 h)
• Contour Cut the Pepsi campaign (est 3 h)

So, how to make sure that your file will only show the unused time slots on the dropdown menu?

Make sure you are registered to see the answer.

Registered members have FULL ACCESS to the content. REGISTERING IS FREE!