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
SvenSieverding Question: if the status of [Active] changes from true to false, will that affect history in the referencing table?
RussellEva I've tried this, the old records became blank. I'm trying to find a solution that will not affect the old record that was previously selected.