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...

SvenSieverding
Oct 02, 2022
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

SvenSieverding

Bronze Contributor

Oct 02, 2022

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

New_learner

Copper Contributor

Oct 03, 2022

SvenSieverding,

I have done like this only.

=IF(Active="true",Name,"")

And it worked as expected.
Thank you for your response.

Forum Discussion

How to filter lookup column based on another column from using specific criteria?

Resources