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
Project 1 3
Project 2 2
Project 3 1
Any help would be really appreciated.