Hi dear all, I have a situation with my table where for each row from 5 to 8 I want to have a dropdown list based on values in column P.
However I want the options "Manager" and "Lead analyst" to be picked only once for each poject, meaning I want to eliminate these two options whenever it is picked for a specific employee and a specific project.
Is there a way I can do this with keeping the table in the same format?
Thank you so much.
However I want the options "Manager" and "Lead analyst" to be picked only once for each poject, meaning I want to eliminate these two options whenever it is picked for a specific employee and a specific project.
Is there a way I can do this with keeping the table in the same format?
Thank you so much.