Count a multivalue lookup column

[AldaSemedo]

Hi,

I am new to developing SharePoint so I have a question for you.

I have to Lists

In list A I have two single text columns like this:

Area	Project
A1	1
B1	2

I have another list B that have a lookup column to List A - Column Project, that allows multiple choice like this:

Client Name	Project
A	1
B	1
C	2

And I want to add a column in list A that retrieves the total numbers of client for each project like this:

Area	Project	Clients
A1	1	2
B1	2	1

There is any way to solve this?

Thank you in advance :)

[#2]

@AldaSemedo There is no SharePoint out of the box way to achieve this. You will need a workflow / power automate flow which will run on item creation/update in List B & update corresponding item in List A.

OR scheduled flow/script which will run once a day & update items in List A based on values in List B.

---

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.