Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

SharePoint Lesson #64: Sort-of-Gantt

Visualisation of booked Project Time
by

Peter Heffner

on 7 April 2016

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of SharePoint Lesson #64: Sort-of-Gantt

=WENN([01]=WAHR;"
<div><table><tr>
<td bgcolor=red>________</td>
</tr></table></div>";"
<div><table><tr>
<td bgcolor=WhiteSmoke>________</td>
</tr></table></div>")
=IF([01]=TRUE,"
<div><table><tr>
<td bgcolor=red>________</td>
</tr></table></div>","
<div><table><tr>
<td bgcolor=WhiteSmoke>________</td>
</tr></table></div>")
Colored Monthly Oerview
This tutorial is about visualizing
booked months.
As an example we need an overview
of booked project time:

Add auxiliary columns
As we don't want to make it too
complicated, we create 12 auxiliary columns, one for each month, of the type [Yes/No]
12 auxiliary columns
Calculate Start/End Month
In this step we calculate the start and end month in 2 separate columns:
Create a List Workflow
Open SharePoint Designer and create
a new list workflow
on your calendar
or list:
Create a List Workflow
Give it a name and set the Start Options.
Initialization
In a first step we set
all auxiliary fields to
[No].
This helps when dates are changed and need to be changed from [Yes] to [No].
Calculate each Month
Each month is calculated in a separate step.

For January the logic is like

IF [Start_Month] <= 1
AND [End_Month] >= 1
THEN [01] = "Yes"

In the following 11 steps we check each month and set the auxiliary fields [01], [02] ... [12] to "Yes" if the criteria meets.
Calculate each Month
Each month is calculated in separate step:
Calculate the colored fields
Calculate the colored fields
In the previous step we calculated the auxiliary fields and know if a month meets the criteria [Yes/No].
The next step defines the HTML-code for a colored cell.

If the month="True", display the cell in "Red" color, otherwise in "WhiteSmoke" color.
Here is the formular:
Depending on your local settings of the SharePoint the delimiter of the arguments can be either a comma or a semicolon.
It is important to set the datatype of the calculated field to "Number".
This will render the content and display HTML.
Done!
Rendering HTML-code in a calculated column by setting the datatype to "Number" works fine in SP2013.
If you are using MOSS2007 you will need a Javascript "Text2html" as described in tutorial #28.
http://sp.peterheffner.cloudappsportal.com/
Please find here an overview of all available Presentations:
Full transcript