Forum Discussion

Shashank Achanta's avatar
Shashank Achanta
Copper Contributor
Jan 29, 2018

Count of Items in List Meeting Criteria

I have a list (Tracker) with columns for User Name and Status.  I am looking to create a table in another page which shows count of items assigned to a particular user and their status.   For Exa...
2013
Pablo R. Ortiz's avatar
Pablo R. Ortiz
Iron Contributor
Jan 29, 2018

I would try to add 3 calculated columns, like

 

Column name: Completed - Value: =IF([Status]="Completed", 1, 0)

Column name: In Progress - Value: =IF([Status]="In Progress", 1, 0)

Column name: Not Started - Value: =IF([Status]="Not Started", 1, 0)

 

Then use some JSLink to be able to Sum on the calculated columns, and finally create a view grouped by UserName, and with totals on all calculated columns

 

https://social.technet.microsoft.com/wiki/contents/articles/30317.sharepoint-2013-displaying-sum-for-calculated-column-in-a-list-view-using-jslink.aspx

 

For JSLink Info related to SharePoint online:

 

https://social.technet.microsoft.com/wiki/contents/articles/37203.sharepoint-online-customize-list-view-web-part-using-jslink.aspx

Resources