4 Common processes that SharePoint can streamline

So your organization has a SharePoint intranet. Your Communications team has done their best by creating and executing a communication plan including a teaser video, a naming contest (Check out this collection for inspiration), emails, intranet news articles and posters. They have given you a training and perhaps a nice gadget like a pen, a  mug or a USB stick. The intranet is here and it will be used for news, blogs, video, employee services, policies and procedures. Oh yes, and you can have Team Sites for collaboration. Good luck with it, folks!

But how often does an employee change their personal details online? How often do they go and find a policy? How many video’s will they upload? If they do these things only occasionally, they will never learn how SharePoint can help them in their daily work.

Few people know that SharePoint is very good at streamlining those annoying little processes that have been wasting your time for ages. Here is a list of processes that can be found in every organization, where SharePoint can add value by saving time and effort.

1. Recurring projects

Many projects occur regularly and follow the same procedures. Think about innovations, promotion campaigns, year plans and recalls.
You can create a tailor-made subsite and make a template out of it. If you use this in one site collection you will be able to create a ready-to-use team site for every project in almost no time, have all projects in one place and support consistency in your process.

Example: Crisis Management 

2. Requests with incomplete data coming from multiple channels

How often do people send you a request, by plain email, telephone, or Word/Excel document? And how often do you have to contact them again to ask for missing information?
Depending on the complexity, you can use a simple SharePoint list, an Office template in a Document Library, or an InfoPath form in a Forms Library, with mandatory fields. As additional advantage SharePoint stores all your requests in one central place, so you do not have to spend time on filing them. You can even add a filter to show only those requests you still have to process. The finished requests can be used to gain insights in your process.

Examples: Employee Directory  and Packaging Requests

3. Editing an online Excel file by many people at the same time

When several people are updating one Excel sheet in a document library, especially when this has to be done in a short period, e.g. at the end of the reporting period, you are asking for problems.

• If you use mandatory check-out, editors may forget to check-in and you will have to chase people to check-in or to override the check-out yourself.
• If you do not use mandatory check-out before editing, chances are that people edit the file simultaneously and overwrite each other’s changes.

Why not use a list, where everyone can update their own line items independently from others? Not only will it save problems, but you will also have much more transparency and better overviews if you do not “hide’ your data in a document.

Example: Telesales

Checked-Out Document

4. Collecting data by sending (Excel) files to a large audience

This is still a favourite process in many organizations. As the process owner who asks people to complete a form by the end of the month, you will have many files to chase and store. Then you have to spend your valuable time cutting and pasting the information into a report before the due date.
If you use a list to collect the information, you will have less inbox overload (just a small alert email when someone adds their information will do) and much more time to spend on analyzing your data and setting a strategy. That is what they hired you for, after all! And the results will be more transparent to your audience.
In fact, you may not even need that report at all…

Example: Travel arrangements in a Team Site

Do you recognize these situations? Could you please share some examples of how you have handled these processes with SharePoint? All tangible examples help us to help our colleagues save time and effort.

“Lady with megaphone” image courtesy of Stockimages at FreeDigitalPhotos.net

Crisis Management in a Team Site

Have you ever been involved in a product recall or another crisis? If yes, you will know that this is a stressful time! A recall is very important, it has to be dealt with NOW, and it has to be dealt with correctly to avoid risk, and all on top of your normal work. Everything that can relieve the stress is more than welcome.

What was the problem?

One of our larger countries had occasional recalls. It did not happen too frequently, fortunately, but it was a real hassle when it occurred.  There was an official procedure, and many people from different departments and external partners were involved, lots of documents were being sent in various formats and versions. Since people were in a stressful mood, they did not want to spend time on thinking.
The briefing was:

• make all essential information as easy to find, read and edit as possible (not everyone was Team Site savvy, especially the external partners, and everyone was hurried)
• avoid sending documents and emails back and forth – but notification emails are welcome
• have the option to archive the generated information for legal reasons and for learning
• make it re-usable

What is the solution?

We have set up a Team Site collection, with a templated subsite for every recall. The subsite can be created from the top site by the process owner without any help from the intranet team – he has Site Collection admin rights, a rare gift 😉
The site is set up to deliver maximum info with minimal effort. The process owner only has to check and update the  Team Members list which is in the template.  The email addresses are displayed in the list so process owner can copy these and give access to all in one step.
Next to that, there is an ongoing Live Meeting to be used exclusively for emergencies. The access information is  incorporated in the template.

The Homepage displays the essentials:

• Announcements
• Picture of the product and the problem, if it can be visualized
• Last 5 documents
• Actions assigned to me
• Decisions taken
• Links to set Alerts (all changes, immediately) to Announcements, Documents and Actions/Decisions
• Content editor web part with information for the  Live Meeting
• Content editor web parts to inform people how to work in the site

First I created a sort of wireframe, to test if we could display all the most important information on one page. 

Wireframe. The items in red contain the most important information.

We decided not to display two lists: the Evaluation (survey), which was only used at the end of a recall, and the Expense Declaration form, which was only used by a few individuals. The process owner will announce the path or link to those lists when necessary.
When a recall is finished, the process owner removes all users except himself and the designated legal person, and stores the site for the legally required period.

This is the final setup:

Recall Subsite Homepage

What are the benefits?

After the first recall that was managed in this new setup, all team members were very positive:

• The Alerts mean that people receive many emails, but smaller in size and they do not need to be stored, since the actual information is in the site.
• The Alerts ensure that everyone receives the same information – nobody is accidentally left out of an email.
• Sharing everything in one Team Site creates one official version-controlled dossier  instead of various personal ones. This saves everyone time and stress and creates confidence.
• The Live Meeting allows  people to discuss anytime from anywhere, saving time and travel. (especially since you need to meet at least once a day)
• The evaluation survey and the expense declaration are now online, and no longer in individual documents. This saves time in aggregating the results, and creates instant transparency.

This is in fact a very simple setup, without any complicated lists or workflows. The most time-consuming part was making sure that a new subsite copied everything correctly, so it was ready to use instantly. I had to make some sacrifices, e.g. display the lists and libraries and train people to set an Alert, rather than displaying the direct links to the alert pages.  But because it is tailor-made for the situation and can be used almost instantly, it is a real time- and stress-saver!
Further improvements are possible, like using an Issue List for the required log, but at the time it was too complicated for the users.

Have you used Team Sites in a similar way? Please share your examples!