Only use a dropdown list item once
I have a guest list and need to allocate a specific ticketnumber to each guest. But we don't want users of the sheet to select a ticket number twice accidentally. And we like the fact that we can filter to show the ticket numbers that haven't been allocated. Is there a way to dynamically update the dropdown list?
Help Article Resources
Check out the Formula Handbook template!