LinkedIn
Twitter
AND((FILTER(Employees, [Crew] = โMaintenanceโ)), (NOT([Employee #1])))
Hi guys! I have a spreadsheet where I am trying to achieve having 3 employees being able to list their names on it. I have [Employee #1], [Employee #2], [Employee #3].
I would like to limit #2 and #3 so that neither of them offer the opportunity to have a repeat employee. So for example, if โFrankโ is the first employee, I donโt want his name to come up on the drop down menu of #2 or #3, as an option.
I was able to do this with a different timesheet with a different expression, but thatโs not working now and I think it has something to do with the key. But anyway, I think Iโm close with this. Can you please advise? The first part is working, but not the โNOTโ part of the expression. Thanks!
