Forum Discussion
Solved
How to filter lookup column based on another column from using specific criteria?
Hello, I have the following lists List - 1 : EmployeeList EmployeeName - Single line text column Active- Choice column : True or false List - 2 : EmployeeWorkLoad EmployeeName - looku...
- You could create a new calculated column in the EmployeeList, that only displays the EmployeeName if the employee is active...And nothing otherwise.
=IF([Active],[EmployeeName],"")
Then change the lookup column EmployeeName the EmployeeWorkLoad list to use that column instead of the EmployeeName column
You could create a new calculated column in the EmployeeList, that only displays the EmployeeName if the employee is active...And nothing otherwise.
=IF([Active],[EmployeeName],"")
Then change the lookup column EmployeeName the EmployeeWorkLoad list to use that column instead of the EmployeeName column
=IF([Active],[EmployeeName],"")
Then change the lookup column EmployeeName the EmployeeWorkLoad list to use that column instead of the EmployeeName column
I have done like this only.
=IF(Active="true",Name,"")And it worked as expected.
Thank you for your response.- Does that produce a lookup list with alot of blanks ? If you have 200 employees of which 50 are inactive does the lookup list still show 200 rows but only the names of 150?
mobmsc SvenSieverding
Yes, its shows blank rows for inactive employees.
so like If you have 200 employees of which 50 are inactive, the lookup list still shows 200 rows but only the names of 150.
Do you have a solution for this? It will help.
