Linked Questions
10 questions linked to/from How to make a filtered lookup field
1
vote
0
answers
205
views
Is that possible to filter and display the lookup values? [duplicate]
Possible Duplicate:
How to make a filtered lookup field
I am using project list lookup field in task list, so my project have # of items, but i need to restrict some of the project like if the ...
2
votes
0
answers
145
views
Filtering Lookup Column By Expiration Date [duplicate]
Scenario: I have created a lookup column with two columns. A department column and Expiration Date column. Each Department has a Expiration Date. For example see the image. When the Department ...
2
votes
2
answers
23k
views
Dependency between 2 choice columns
I'm using SharePoint 2007.
I created a custom list.
In the list I create 2 choice fields (column A, column B).
I want to implement this scenario:
If the user chooses the first choice from column A, ...
0
votes
2
answers
3k
views
Create a self-lookup field which only show certain items based on criteria
I am working on a sharepoint online classic team site. where i added a custom list named "Pricing", which contain these main 2 fields:-
1) a column named "Type" of type drop-down list and have 2 ...
1
vote
2
answers
2k
views
Filtered lookup column
i have two lists, list A creates events, list B creates reports based on events on list A.
I currently have a lookup field (in list B) that pulls the event name from List A, that way they can select ...
1
vote
1
answer
1k
views
How can I force one to one relationship in SharePoint lists?
I have one parent list and only one child can be associated with one parent item. For example,
Employee -> company access card
Each employee can have one access card and new access card can only be ...
1
vote
2
answers
1k
views
Page Field Filter displaying 1;#ColumnName instead of ColumnName. Bug?
I have a Document Library with a column (we'll call it ColumnName) and a Web Parts Page with a value assigned for that column. On that page I have a list view displaying the Doc Library files and a ...
2
votes
1
answer
807
views
Calculated field shows seemingly random number when set to be empty
I'm trying to set up this solution for creating a filtered lookup:
How to make a filtered lookup field
I have set up an ItemAvailable column like this:
The column "Availability" is a choice between "...
1
vote
0
answers
119
views
How to filter lookup field by site name
I have a list like this:
Title Site
AAA Site1
BBB Site2
CCC Site2
which is referenced in a lookup column.
Requirements are to filter in the lookup column only the items whose "Site" property is ...
0
votes
2
answers
51
views
'#Value!' error in filtered lookup column
I'm trying to create a filtered lookup from a 'Projects' list that sits on a SharePoint site.
I followed the steps to create a filtered column in a SharePoint list as outlined here: How to make a ...