(SOLVED without programming) When viewing 2 calendars how can I apply a filter to just one? (hoping for update)

Question

The last occurrence of this question appears to have been from 2012. Eleven years on, I'm hoping for a better answer ;)

I have a personal calendar and a shared calendar. I want to set up a filtered view to show EVERYTHING from my personal calendar, but only those items that match a particular set of filters from the shared calendar.

Here is the current search term: "urn:schemas-microsoft-com:office:office#Keywords" = 'APR' This shows everything that matches having category "APR" in both my shared and personal calendar. I need to adjust something in the designator portion (urn:schemas-microsoft-com:office:office) to just apply to the one calendar. Unfortunately, I can't guarantee that users won't have no categories, so I can't do a NOT() equivalent. Any suggestions most welcome. I've spent about 5 hrs googling about, but short of starting to learn VBA from scratch, which I simply do not have time to do (charity, and work is crazy busy), I'm stalled out.

Answer 1

Dear NCCmmcksmith,

Good day to you and thanks for update.

We appreciate your skill and glade to hear that issue has been resolved. to help other users, we are making summary of this thread. You can also give vote on it, by this other users who are searching for the same query can easily found this thread.

Issue : without programming : When viewing 2 calendars how can I apply a filter to just one? (hoping for update)

Solution : And I just figured it out. I created a category "SchedulingSharedCalendar" and assign it to every appt created in the shared calendar. Now I can adjust my filters to find the categories I want, surround them with a bracket and use a NOT to catch everything with no calendars.

We also welcome to share your troubleshoot skill on our community by posting thread and for the queries, we are happy to assist you.

Thank you and have a wonderful day.

Sincerely,

Ankita Vaidya

Answer 2

And I just figured it out. I created a category "SchedulingSharedCalendar" and assign it to every appt created in the shared calendar. Now I can adjust my filters to find the categories I want, surround them with a bracket and use a NOT to catch everything with no calendars.

Answer 3

Dear NCCmmcksmith,

Good day to you and thanks for reply.

Based on your post, have checked and seems filter apply to all calendars, not for specific calendar. It should be possible that with VBA code, you can manage your requirement. For VBA, as we have separate team, so we suggest you contact them and check if they have any suggestion or workaround to achieve this requirement. We have observed that you have limitation of time to start with VBA but once you reach VBA team and if they have some suggestion, they will make it easy for you. For VBA programing query, please check contact details Office VBA support and feedback | Microsoft Learn. I hope this information helps you to get correct way to reach out dedicated team for further check. If you think, I provided required information which helps you to get further check with dedicated team, you can also give vote on this reply, it helps other users who are looking for same information. At this point, thank you so much for your precious time.

Sincerely,

Ankita Vaidya

Answer 4

If you were able to, could you copy in the code from the SQL tab please? Unfortunately, I've attempted that several times in both the "more choices", "advanced" and "SQL" tabs of the filter setup window. It applies the filters to ALL shown calendars, not just the selected calendar. I've also tried using the applicable radio buttons to set "all calendars" and "only this calendar". I can't get filters to apply to only 1 of the displayed calendars.

Answer 5

Dear NCCmmcksmith

Thanks for choosing Microsoft Community.

Based on your description, I know your reuquirement. So sorry to bring you inconvenience.

To apply a filter to just one calendar when viewing two calendars in Outlook for Windows, you can follow these steps:

1. Click on the "Calendar" button in the bottom left corner of the Outlook window.
2. In the left-hand pane, select the calendar you want to apply the filter to.
3. Click on the "View" tab in the ribbon at the top of the window.
4. Click on the "View Settings" button.
5. In the "Advanced View Settings" window, click on the "Filter" button.
6. In the "Filter" window, click on the "Advanced" tab.
7. In the "Field" dropdown menu, select "Categories".
8. In the "Condition" dropdown menu, select "contains".
9. In the "Value" field, enter the category you want to filter by (e.g. "APR").
10. Click on the "Add to List" button.
11. Click on the "OK" button to close all the windows.

This should apply the filter to only the selected calendar, and show all items from your personal calendar and only those items from the shared calendar that match the specified category.

Hope these can help. If these cannot help or there is any update, for this, please be kindly to let me know, I will continue to help you based on the information you provide. Your understanding and co-operation are highly appreciated.

Thanks for your precious time. Have a nice day.

Sincerely,

Katherine