0

So I have a simple SharePoint List with some custom columns of type "Single line of text", such as "Client Name". When I am in the Calendar View, I only have very limited filtering options, mainly Title, Employee, Begin and End dates. Is there a way to add a filter for "Client Name", where I could select in this same view? I do see an option to filter based on client name from "All Items" view but not from calendar.

There are some filter settings in the List Setting view but those are hardcoded so to say. I need to be able to quickly switch back and forth.

1
  • Where do you see the filter options for Title, Employee, Begin and End dates in modern calendar view, in filters pane? Can you add screenshot of it to your question? Commented Oct 27, 2023 at 13:26

1 Answer 1

1

Follow below steps to add single line of text column in filters pane in SharePoint online modern experience calendar view:

  1. Go to your calendar view

  2. Click on "Switch view options" drop down and select Add or remove fields:

    enter image description here

  3. Select your single line of text column and click Apply:

    enter image description here

  4. You can also add/show columns in calendar view using classic experience view settings page: Conditional Formatting in Calendar View is not showing a Column

  5. Now, open the filters pane from calendar view and you will see the single line of text column:

    enter image description here

Note: column in filter pane will be shown only when you have calendar events/items with some data in that text column in currently opened month (like January 2021 in above image). Here is the list data for reference:

enter image description here


Update from comments:

To add more columns in the filter pane, you can try pin/unpin the required columns in the filer pane from here:

enter image description here

3
  • Thank you! So interestingly, this works if I disable all columns from "Add or remove fields" and only leave "Client Name". But now another filter which was before - column with type "Person or Group" is gone. Is that because Sharepoint only allows 4 filters at any given time? If I enable both of them, only one is showing.
    – estranged
    Commented Oct 27, 2023 at 14:22
  • 1
    Yes, SharePoint by default shows only 4 columns in the filter pane. You can try pinning the columns in filter pane then add more columns in the view by following the steps in answer - again pin the required columns (check updated answer). Commented Oct 27, 2023 at 14:38
  • 1
    You're right! I spend a whole day try to get this to work, and now it finally works! Thank you so much! It's quite unintuitive I would say.
    – estranged
    Commented Oct 27, 2023 at 14:57

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.