Create count of distinct occurrences of two columns

Copper Contributor

Can I use a calculated column to count the number of distinct occurrences of column1 within column2 where column3 = "Started"? If so can someone send me the basic code for that formula?

Thanks, Mark



1 Reply



Are you trying to do the calculation across all list items/records or for single (current) list item/record using the calculated column formula?


If you are trying to get the calculated value from multiple list items, it is not possible using SharePoint calculated columns: 


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.