Posts Tagged ‘gantt’

5 things you never knew you couldn’t do with SharePoint Gantt Charts

Date:February 3rd, 2010 Author:Clare Tags: , ,
Category: General, SharePoint Planner, SharePoint webparts Comments:3 ;

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:

(more…)

Tip – Showing multiple columns in SharePoint Planner Webpart

Date:October 14th, 2009 Author:Ryan Tags: , , , , , ,
Category: Calculated Columns, SharePoint Planner, SharePoint webparts Comments:1 ;

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.

concat-columns
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

SharePoint Planner Webpart Free Trial Download

Adding gridlines to the SharePoint Planner webpart Gantt chart

Date:October 30th, 2008 Author:Ryan Tags: , , ,
Category: SharePoint Planner, SharePoint webparts Comments:0 ;

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.

Planner Gridlines Example

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.

(more…)