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!!!
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… EtcI 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!!! Read More
