In my list I have Regions and Organizations
Region is a lookup to Regions list
Organizations is a look up to Organizations list.
In the parent list there are entries with these values and I need a numeric value of how many Organizations are in a particular Region so I can use it for a Google chart
Is there a formula,workflow or another way to get a numeric value how many
For instance
Hi @Scott1-1615,
Are you using SharePoint online? You could use Power Automate flow to get lookup value then update column in SharePoint list if you are using SharePoint online.
For Reference: Count of column based upon lookup values
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi @Scott1-1615,
Per my research, there is no available way to achive this in SharePoint 2013.
4 people are following this question.
