Follow Us:
Have you ever been using a SharePoint calendar with recurring events then noticed some events started showing with a title of “Deleted:”? I’m going to show you a quick way to hide these events from a view.
You have a SharePoint calendar, and you create some recurring events like daily scrums or weekly staff meetings. This creates an event for the series, as well as an event instance of the series for each recurrence of the event. Let’s say that Tuesday’s meeting is cancelled, so you delete that instance of the event for Tuesday. It disappeared, no problem. However, switch to the All Events view and let’s take a look:
If you delete the “Deleted:” item, the recurrence you deleted for Tuesday comes back. So the Deleted titled event needs to stay but how do you filter it out?
If we look at the filter options available for the view, notice there is no option that says “starts with”.
We need to do two things to easily fix this without any javascript or code:
Go to the list settings, and click Create Column, and choose Calculation, returning the value as text. The name of the column can be Truncated Title. For the formula, we want to use this:
=LEFT(Title,8)
This creates a text column that looks like this:
Now go edit your view, and for the filter, set it where the Truncated Title column is not equal to Deleted:.
Click Save, and our delete item is gone!
The complementary paper includes over 12 years of research, recent survey results, and CRM turnaround success stories.
Request Download
This 60-second assessment is designed to evaluate your organization's collaboration readiness.
Learn how you rank compared to organizations typically in years 1 to 5 of implementation - and which areas to focus on to improve.
This is a sandbox solution which can be activated per site collection to allow you to easily collect feedback from users into a custom Feedback list.
Whether you are upgrading to SharePoint Online, 2010, 2013 or the latest 2016, this checklist contains everything you need to know for a successful transition.