Forum Discussion

Copper Contributor

Sep 12, 2023

Sharepoint list countif help needed

I have a sharepoint list thats a list off colleagues. One of the columns contains the name of the line manager. Those line managers also have their own rows in the list. On their row I want one ce...

Bronze Contributor

Sep 13, 2023

Hi JohnESummers,

there is no "countif" equivalent in SharePoint's calculated columns. That is because calculated columns are only updated when the item itself updates, so they cannot include calculations from other columns.

What you could do is create a new page and add two list-webparts to it. Configure them to both show your list. Then open the property pane of one webpart and activate "dynamic filtering". Define it so that that webpart is filtered by the linemanager column and that the filter comes from the name column the other webpart.

If you now select a person in the first list, the second list will filter to just the people that belong to the line manager. You can create a different view for that list, that only contains the name and linemanager column.

Best Regards,
Sven