I have a calculated column created in one of the Sharepoint list, here is the formula: =

IF(DaysDifference<0,"Overdue",IF(DaysDifference<=7," 7",IF(DaysDifference<=15,"15",IF(DaysDifference<=30,"30","Over 30"))))

I have then added group by this column for a view, below is the screenshot: enter image description here enter image description here

the return type of this calculated column is free text. Is it possible to change the group by column order? Currently its showing Overdue, Over 30, 30,15 and 7. How can it be changed to follow this order: Overdue, 7, 15, 30, Over 30? Is this possible to do?

Please advise, thanks in advance.

1 Answer 1


The "group by" is text, so if the alphabetical order does not work for your data, you can add something that is alphabetical. (letters or spaces maybe)

Option one, add a sorting prefix: (A. B. etc.)

A. Overdue
B. 7
C. 14


IF(DaysDifference<0,"A. Overdue",IF(DaysDifference<=7,"B. 7"  ...

Another option, add spaces (indent): (underlines typed below to represent spaces)

Over 30


IF(DaysDifference<0,"  Overdue",IF(DaysDifference<=7,"  7"  ...
  • Option 1 was perfect, thanks a lot again Mike.
    – mdevm
    Mar 21, 2019 at 1:21

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.