I have a view setup were "call sign 1" is grouped and then grouped by "Call sign 2". This allows me to see when mutable submissions of the call sign have been submitted to my custom list. However, I really only care if there are more than one submission that links two call signs to each other. How do I get the view to only show groups of 2 or more?

If this is not possible is there at least a way to sort them were call signs that have the most submissions show at the top of my view?

enter image description here

  • Which version of SharePoint? There are things would could do with older versions and SharePoint Designer that we cannot do with newer versions. Commented Jul 6, 2019 at 17:05

1 Answer 1


Go in Modify View and check the settings under Group By - try changing it to descending and see what happens. grouped by sort

When you are using Group By it overrides the usual Sort By settings. BTW - I'm using SP2013.

As for sorting by the grouping with the most items under it, you could create a new column which counts items in that grouping - you could use a calculated column for this. Once you have a value in the new column you can configure the view to sort by the NewColumn value in descending order.

You might be able to filter out any groupings that have less than 2 by filtering on NewColumn not less than 2.

  • I'm using SP2013 BTW. I don't have any experience using calculated columns. How would that work? Commented Jul 8, 2019 at 11:05
  • Try googling calculated columns for Sharepoint or have a look on the marvellous SPSE site - it's a treasure trove of information. Try looking at the calculated columns tag for a start: sharepoint.stackexchange.com/questions/tagged/…
    – Tally
    Commented Jul 8, 2019 at 14:23
  • I think my question now is what would the formula in a calculated column, were I want to count the number of times a single line of text is entered into my list? Your advice got me the rest of the way to my goal, just need this last bit of help. Thank you! Commented Jul 8, 2019 at 15:10
  • Hmm, I've been mulling this over and spent 15 minutes experimenting before i finished work yesterday, but didn't crack it. I think you could post a new question on this one, specifically asking how to: 1. Count # of values that are the same and 2. How to then filter out anything that there are less than 2 of. BTW - like many users on this site, I obsessively collect points, so don't forget to upvote Answers (or even Accept answers) if it's been useful...hint hint :)
    – Tally
    Commented Jul 9, 2019 at 8:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.