I am trying to apply a filter to a dropdown in a column for only one view of a table. When I use lookup or list and apply filter, the filter is applied to the column in all views of the table. Is there a way to do it?
As far as I know, filtering selectable items of a lookup field for only one view is “not possible” simply because a source/base table and its connected views are linked to each others and what you do in a view or its source/base table is reflected everywhere …
May I ask why it is important to not have the Completed status as a selectable option in your lookup field ?
Could you give us more info about your use case scenario here ?
(Maybe, with more info, someone could have an idea for a workaround)
The document is structured as a single table with multiple views. So, the “backlog” is a filtered view of the table “Work items”.
I want to make it easier for the user to assign sprints from backlog. Suppose sprint 1 and 2 are already completed, it would be convenient if the user is not given the option to move a task from backlog to an already completed sprint.
This is my specific scenario. If there is solution or workaround, I will definitely use it for more than this scenario.