I have a document library Doclib and a list Doclist.

Doclib has columns: Title, Approval Status, Projname(Lookup).
Doclist has Columns: ProjectName, Count(Want to lookup)

The ProjName column is a look up column which fetches ProjectName from Doclist.

I want the column Count to look up how many times a particular project is selected.



Title   Approval Status  ProjName

Document1   Draft    Project 1
Document2    Draft    Project 2
Document3    Draft    Project 1
Document4    Draft    Project 3
Document5    Draft    Project 1
Document6    Draft    Project 2


ProjectName   Count

Project 1   3
Project 2   2
Project 3   1

Any help would be really appreciated.


You can achieve this with two lookup columns:

  1. Create a lookup column in DocLib that points to itself, column 'ProjName'. Call this column 'ProjNameLookup'.
  2. Create a lookup column in DocList that points to DocLib, column 'ProjNameLookup (Count Related)'

See here for a guide.

  • Thank you for you post! When i try to select ProjName as a lookup for ProjNameLookup. It is not listed in the dropdown. – Pinak satra Sep 1 '15 at 12:32
  • Which lookup column are you referring to, 1 or 2? – Submits Sep 1 '15 at 12:35
  • I am refering to column no 1 – Pinak satra Sep 1 '15 at 14:29
  • What is the type of the ProjName column in your DocLib library? – Submits Sep 1 '15 at 14:31
  • it is a Lookup column to ProjectName in Doclist – Pinak satra Sep 1 '15 at 15:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.