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
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?
SvenSieverding's avatar
SvenSieverding
Bronze Contributor
Mar 17, 2023

Hi mobmsc,

no. You just see one blank entry.

Best Regards,
Sven

Resources