Forum Discussion
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 always be 1st, doesn't seem to show up first.
Example below. The grey item should always be listed first, however the blue item, which is ranked 3 in the sortby column is listed above the grey item.
4 Replies
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
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.
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
