Forum Discussion
How to filter lookup column based on another column from using specific criteria?
- 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 @mobmsc
Given you have a list with 200 entries like this (197 entries that are inactive und 3 that are active)
and with a calculated field calc defined like this
=IF([Active],[Title],"")
If you now create another list with a new lookup column "Lookup" to that list on the field "calc", then that lookup column will look like this on a classic SharePoint form
and like this on a modern form
So only the three active users will be displayed, 197 inactive Users will not be visible.
Best Regards,
Sven
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.
