Forum Discussion

New_learner's avatar
New_learner
Copper Contributor
Sep 29, 2022
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...
  • SvenSieverding's avatar
    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
New_learner's avatar
New_learner
Copper Contributor
Oct 02, 2022

SvenSieverding,

 

I have done like this only.

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

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

mobmsc's avatar
mobmsc
Copper Contributor
Mar 16, 2023
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?