Forum Discussion

as733y's avatar
as733y
Copper Contributor
Apr 11, 2023

Sorting Calendar View Items

What is the best way to sort items in the calendar view? I created a "SortBy" calculated column with If statements ranking each Choice value with a rank 1-4, however My "Event" choice, which should a...
Lists
ganeshsanap's avatar
ganeshsanap
MVP
Apr 12, 2023

as733y Can you show us the calculated column formula and the screenshot of view settings with sorting options?

If all settings are correct, it may happen because blue event/item is started before the gray event/item.

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.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

as733y's avatar
as733y
Copper Contributor
Apr 12, 2023

ganeshsanap 

 

If all settings are correct, it may happen because blue event/item is started before the gray event/item.

That's what I was thinking, because that is consistent with all the other items. The screenshots are below.

 

 

 

 

  • ganeshsanap's avatar
    ganeshsanap
    MVP
    Apr 12, 2023

    as733y Can you try using calculated column settings in below format: 

    Also, add some default value (example: 0) in last IF statement in your formula like: 

     

    IF([Status of Request]="Posted",4,0)

     

    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.

    For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

    • as733y's avatar
      as733y
      Copper Contributor
      Apr 12, 2023

      ganeshsanap 

       

      It doesn't appear to work. Thank you for the suggestion though.

Resources