SharePoint can be a marvellous project management tool—provided you let it.
In order to do this, however, you have to think about how it can benefit you, and change your processes accordingly.
Sadly, until SharePoint is well established, most people won’t do this.
Take a really simple example.
A company I know uses SharePoint Portal Server as their company intranet. On the intranet they have a social area.
Every year this company holds a children’s Christmas party. Staff members bring their children along to the party where they eat party pies, play games and meet Santa. Each child gets a present from Santa, based on their age and gender.
The social page on the intranet advertises this party. It tells when the party is on, where it will be held, and what to do if you want to bring your child along.
The company needs to know the following:
- Name of each child
- Age of each child
- Gender of each child.
How do they do it?
They send around an email with voting buttons. Yes, I am bringing one or more children; no, I am not.
They ask you to include in the reply, the name, age and gender of each child.
A member of the social club receives the replies. They transfer the names to a spreadsheet. They use this spreadsheet to plan catering, and to work out how many presents to buy for each age group. They also use it to print labels for each present.
This is prone to error.
- Emails get lost in the many work emails that come through
- The parent replying may add their child’s name, but forget their age or gender
- The social club member may be in a hurry one day, and forget to transfer the name(s) to the spreadsheet
- They may mis-type the name when transferring it to the spreadsheet. Ditto the age, and gender.
It takes time. Time to set up the voting email, time to transfer the detail to the spreadshet.
So, how might we do this better in SharePoint? Remember that a page already esists advertising this event.
- Create a custom list with three columns—child’s name, age and gender. All of these fields would be compulsory.
- Create a view that only displays items you (the person viewing the screen) have added
- Add the list to the page, using the new view you have created
This is a simple list. It will take at most five or ten minutes more to set up than the voting buttons would have.
Now, copy the address (URL) of the page. Write your email exactly as you have before, but instead of asking the people to reply to your email, ask them to click on the link to the page.
Each parent goes to that page, and adds their child(ren)’s information by clicking Add New Item, and adding an item for each child.
They can’t omit any of the information because each field is compulsory. Not only that, because the view displayed on the page only shows the children they have added, they can see immediately whether they have made a typo and fix it.
Each parent has had to do maybe two clicks more than they might have done otherwise, but that’s all.
What about the social club person? Yes, so far they have spent five or ten minutes more creating the list, but that’s it. And now the usefulness of SharePoint comes to the fore.
They don’t have to receive the emails. They don’t have to transpose the names to a list. It’s all done for them. Not only that, we have eliminated nearly all potential for errors.
All the social club organiser has to do is export the list to a spreadsheet when they are ready to print labels and organise catering.
They have saved themselves 90% of the work. (Not 90% of work organising the party, but 90% of the work gathering the names.) And the results will be accurate.
Unfortunately, the company mentioned is not SharePoint savvy yet. When this idea was suggested, the reply was, “But it’s too hard to set up.”
You counter with, “Yes, it may take an extra five minutes to set up, but think of the time and effort you will save later.”
They came back with, “But it’s confusing for the user. And anyway, it’s not that much effort to transfer the names from the email to the spreadsheet.”
Nothing you can say or do will make them budge.
They won’t make the mind shift.