Forum Discussion

BrianB43's avatar
BrianB43
Copper Contributor
Jul 15, 2024

Calculated Column Header Workaround

OK, I have a SharePoint List problem that I have to believe would be common; for anyone using calculated field however, I've looked high and low and cannot find a solution or JSON string that will seem to work.  I'll also add that I'm not a programmer and I'm relatively new to this level of SharePoint administration, but I'm pretty persistent and generally pretty capable. 

In solving the age-old "custom sort" challenge I created a calculated column that works off a frequency field (options being Daily, Weekly, Bi-Weekly, Monthly, Quarterly, Ad-Hoc, None) because I did not want to use the technique of numbering my labels (1 - Daily, 2-Weekly etc.)  The sort works perfectly; the problem is in the grouping.  I use a grouping on the (hidden calculated column) sort value and a secondary sort on the Frequency, ending up with Group Sort Title Labels that look like this 

FSort: 1 (17)
      Frequency: Daily (17)
      Daily  7AM Report Name Content1 Content1 Content1...
      Daily  7AM Report Name Content2 Content2 Content2...

      Etc

I want to either drop/not display the Primary Sort Title (in this case  and only show the secondary sort; I'm willing to use a professional-looking workaround like changing the Group Title font to white where it won't as awkward as it does today since most backgrounds will be white.  Any ideas or links to places that can provide me more options to try?  I'll note that CoPilot and ChatGBT provided me a cornucopia of irrelevant information.  I know all about Conditional Formatting in columns; this is specifically the Group title.  Thanks!!!

No RepliesBe the first to reply

Resources