One of our New Years Resolutions for 2010 was to: “find out how people really use our stuff”. We really want to understand how people use our Planner, Reminder and Pivot Point in the real world.  We know we have clients from a huge range of industry sectors, so it will be great to see how our software helps with the special challenges of your area. And we know that some of you use 2 or 3 of our products together: we would love to know what you are doing there. So this year we want to find out how you use our products in your SharePoint environment. If we know how you use them it will help us to improve them! Just send us a quick email telling us a bit about your business and how you use our products and we will enter you into our free prize draw for the chance to win a funky Flip video camera. We would really appreciate your help on this one, so if you have a minute free please send us a quick email.

Terms and Conditions

1. You must be a user of Pentalogic Technology Software in order to enter (free trial users are welcome to enter.)
2. Entries must be sent to clare.stone@pentalogic.net with the subject line “Case Study”
3. The draw will take place at 12 noon GMT on Monday 1st March, you entry must be submitted by 12 noon GMT Sunday 28th February to qualify.
4. All entrants agree to take a 30 minute phone call from Pentalogic Technology, to clarify details of your case study.
5. All entrants agree to their case study being published by Pentalogic Technology, on line or in print.

Sometimes it’s all too easy to forget what it was like to be a new SharePoint user.  Sometimes you need a wakeup call to remind you of the “WOW” moments of delighted surprise when you discovered an amazing new feature, and the “AAAGGGGGHHHH!” moments of frustration, when you hit upon something SharePoint obviously should do, but for some inexplicable reason just doesn’t.

We got our wakeup call this week when we were putting together a product features chart for our Planner web part – which is an easy to use planning tool, with a Gantt chart view.  We like to do this with all our products, to see how we stack up against the competition, and against SharePoint out of the box.

When we looked at SharePoint out of the box, some of the basic things that you would expect from a Gantt chart just weren’t there.  Here are our top 5 “missing in action” feature in SharePoint Gantt charts:

1.  No Color Coding

Seems obvious.  All you organized souls out there with colored marker pens and highlighters that you use on your wall planners would naturally expect to be able to color code your SharePoint Gantt charts – and you would be disappointed.  Color coding is not possible.

Here’s a simple project Gantt chart in SharePoint out of the box – a little dull don’t you think?

And here’s exactly the same calendar list displayed in a Pentalogic Planner Gantt chart – color coding allows us to see the completion status of each task – so much more informative!

2.  No Zooming in to see the detail

In most projects there are times when you have a lot going on all at once.  It’s nice to be able to zoom in and take a look at the detail of a particular time period and then zoom out to take an overview of the whole project.  Sadly this just isn’t possible with a SharePoint out of the box Gantt chart.  Your view is 3 months, no matter how long your project is.

So if there is one day in your project that is chock full of meetings, like this:

you’ve got no way of seeing exactly when they are, who should be attending – like this view from our Planner:

3.   No Printing

For us techie types who are permanently attached to a monitor the concept of printing may seem a little old hat.  But for the rest of the world, those people who attend meetings where there may be no computer present (!) and people want to huddle round a paper version of the plan – maybe even scribbling notes on it – this is really quite important.  Like many things SharePoint, out of the box Gantt charts are just not designed to print – and that can be really quite frustrating. Whilst our Planner doesn’t have the world’s most sophisticated printing options we do at least off a basic printer friendly version – for everyone who still loves paper!

4.  No Labels

As you can see from the examples above, with Planner you can use labels to add that extra layer of information to your Gantt charts.  In this example we have used them to show who a task is assigned to, but you could use them to show the values in any column in your list.  Really quite useful – but simply not available with SharePoint out of the box Gantt charts.  Hmmm, disappointing!

5.  No Recurring Events

Recurring or repeating events are a mainstay of calendar usage.  Let’s try adding a regular weekly project meeting to this one.

Oh dear, the meeting doesn’t really go on for a whole six weeks does it?  Should I bring a sleeping bag?  Book a dog sitter?

Oh right – when I look at the view in Planner I can see that it’s actually just once a week for six weeks – what a relief!

SharePoint out of the box Gantt charts just don’t support recurring events.  Enter one into your calendar list and the Gantt chart will show one event, which starts with the first recurrence and ends with the last.  This surely must be a bug rather than a deliberate omission?

Well, that does all sound a bit disappointing – but surely all that will be fixed with SharePoint 2010 right?

Wrong! Although you do get some ability to zoom in and out with SP 2010 in the current beta at least, the rest of the omissions remain as is.  But maybe things will change with the release candidate?

So, those are our top 5 “missing in action” features for SharePoint Gantts, what are your most annoying missing features?

There may be times when you want to display timeline or category information from more than one list column in a gantt chart. For example in the chart below we have taken information from the “priority” and “title” columns of a list to populate the category labels.

With Planner you can show multiple columns in the Category or on the Timeline of a Gantt chart by using a calculated column to merge fields together.

For example to merge Priority and Title columns together you would :-

• From your list click Settings > Create Column
• Set a name such as “Category”
• Choose Calculated for the type
• In formula enter (where [Title] etc is the name of the columns you want to merge)

      =[Priority] & " : " & [Title]

• Uncheck ‘Add to default view’ checkbox if you don’t want this appearing for the normal list view.
• In Planner you can now select this column.

You can merge multiple columns together, for example :-

   =[Priority] & " : " & [Title] & " - " & [Assigned To]

You can also use SharePoint standard functions and formula (many similar to excel) such as :-

   =Text([Start Time],"mmm-yyyy") " : " & [Title]

Which would prefix the Title with Month and year, like so  October-2009 : Your title here

To display the the duration in days you could use

   =DATEDIF([Start Time],[End Time],"d") & " Days"

See some more examples of common functions

We are happy to be able to let you know that a German version of the Pentalogic Planner web part for SharePoint is now available.

Although Planner was already partially localized for German, so that German end users would have see Month and Day names in their own language, administration and set up screens were previously only available in English and French.

Over the past few weeks we have been working on a translation with one of our German customers and Planner v2.5.6, fully localized for German, is now available to download.

Depending on how SharePoint is setup you may have to perform some additional installation steps to enable the French or German language packs – please follow the instructions in the Languages FAQ.

And as ever, if you do have any suggestions, feedback or thoughts for us please do get in touch.

A new version (2.5.0) of SharePoint Planner is available to download.

The main change is the interface has been fully localized in French.

In addition :-

• New feature to automatically default the web parts Title to the name of the source list and link to the lists default view (WSS 3.0 and MOSS 2007 only). Both of these settings can be overridden if required using the toolparts Appearance > Title and Advanced > Title URL settings.
• Correction to an error that stopped the By Category view grouping correctly if you were using a User lookup field with presence enabled.

You can simply download and install the new vesion – there is no need to remove the old version first.

Update – an option to use horizontal gridlines has now been built into version 2.4

Alessandro from Italy contacted us wanting to know if there was a way of adding gridlines to SharePoint Planner so it’s easier to visually connect up the column on the left with the corresponding timeline.

With a few Cascading Style Sheets (CSS) ninja moves you can change the display from something like this.

The following snippet does the trick and can be added to an individual page using a Content Editor Web Part thereby changing just the Planner web parts that appear on that page.

DIV.SharePointPlanner2 TABLE.plgx_Default TR TD
{
border-bottom : 1px solid #B9D1F4;
}

Alternatively you can add it to the SharePointPlanner.css file that all planner web parts use or download one that’s already been edited. There can be multiple copies of this file depending on how you install SharePoint and Planner and they can be in different places so it’s best to do a file search and replace them all.

If you are a CSS Ninja then you can make other changes to the appearance and you will find some helpful comments in the CSS file to guide you.

But remember – if you reinstall or upgrade to a later version of Planer you will lose any changes so do keep a copy of your modified files.

We are considering adding this as an option to the configuration tool part so if you think it would be useful then let us know.

And if you’ve got any other questions or suggestions we would love to hear them!