Linked Questions

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 ...
Ayyappan Anbalagan's user avatar
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 ...
SharePoint Lady's user avatar
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, ...
liron's user avatar
  • 657
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 ...
John John's user avatar
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 ...
nando's user avatar
  • 149
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 ...
OldGold's user avatar
  • 15
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 ...
user15574's user avatar
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 "...
user avatar
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 ...
RaffaeleT's user avatar
  • 333
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 ...
Marlena's user avatar
  • 51