Forum Discussion
u156531
Feb 29, 2024Copper Contributor
Create count of distinct occurrences of two columns
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
Sort By
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.