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

Related posts:

1. Adding gridlines to the SharePoint Planner webpart Gantt chart This post shows how to use CSS to add gridlines...
2. SharePoint Calculated columns – Adding hours onto a date field A customer recently contacted me with an interesting question....
3. New version of SharePoint Planner Webpart (2.5.3) Version 2.5.3 of SharePoint Planner webpart is now available with...
4. SharePoint Planner Webpart – New Version 2.5.0 Now Available v2.5.0 of Pentalogic SharePoint Planner webpart is now available, the...
5. Working Days, Weekdays and Holidays in SharePoint Calculated Columns This post shows you how to work with weekdays and...

Tags: Calculated Columns, Formula, gantt, Planner, SharePoint, Tip, WebPart