Forum Discussion
Data validation multiple criteria - Ticketing system
Hi, everybody,
I'm trying to mimic a task system tracker using data validation and filters and I really got stuck.
So, each time I select someone to do a task from a data validation list I want that person to not be shown in the next row when I'm selecting the data validation column ( There's where the filtering function works) only if he is assigned to do a task already ( I made a second column called "Status" with a dropdown list that has 3 criteria "Completed", "Work in Progress" and "Not assigned").
Example: So if let's say John is assigned to do something and his Status is "Work in Progress". Well, if I have another task (next row) and I want to select someone to do it, I don't want to see John's name in the data validation list until I change John status into "Completed" or "Not Assigned"
Is there any chance to do this in excel?
Thanks a lot!
Where is that status column? Could you post screenshots of they layout (with anonymized data)? Or attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar, thanks a lot! I have attached a version of it now.
So let's say that from the "Engineer assign" column of the the MainTable we choose Michael from the data validation dropdown list on row number 6 and we change the status to "Work in Progress"
When I want to add another task on row number 7 and access the data validation list from "Engineer assign" column, well I expect not to see anymore Michael's name in there because it's associated with a task already (Work in progress status) and he can be selected only if we change the status of its task (row #6) to "Completed" or "Not assigned".
So there's a big algorithm that contains Filtering, Vlookup (maybe?) and data validation.
Thanks a lot for your effort of answering me!
