dlocc.com

The ITS department created a new calendar dashboard and were delighted that they could finally discontinue the Outlook Public Folder Calendars that were previously in use.  There was though one request that is completely understandable: "Please remove the '12:00 AM and 11:59 PM' values for the Start Time and End Time and instead just make it one column."  I will show you how I satified this request.

Have you asked yourself the question: How do I remove the 'title column' from a Sharepoint list?  It can be annoying trying to figure out how to remove this column from default lists.  Often, site admins want their audiences to click on "New Item" in a Sharepoint list and not have to fill out the default 'Title' column content type.  I will show you how to remove this from the view.

 Recently I was asked by my manager to create a dashboard for executive members to quickly see the progress of active projects.  She explained to me that she wanted a "priority level" indicator similar to that of the KPI in a basic table structure.  The color of the indicator would change depending on the status of the project (Red, Yellow, Green).  I will show you how I satisfied this request by creating a calculated column, using wingdings to create color 'graphics' and displaying the sheet in a dataview.  You must have Sharepoint Designer to complete this tutorial.