I have two lists, A and B. I wish to find out the number of rows in list B that have a certain value in list A (through a lookup column) and display this in list A.

Is this possible at all using a calculated field? Or how to best approach this?

Many thanks.


You can use count related lookup column.

Below is the link for reference: How to create count related lookup column

| improve this answer | |
  • 3
    good find, not many SharePoint experts know this one.. I for sure learned something new today – Danny '365CSI' Engelman Jul 14 '15 at 19:34

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.