Category Archives: Sharepoint 2007

Home »  Sharepoint 2007

I needed to find a way to color code (highlight) something based on a status or value in a list view. There are 2 ways (a) will color code the whole row (b) will color code only the cell where the argument to highlight is. The implementation of both is the same it just has a slightly modified script to highlight. Prerequisites: We have a Sharepoint 2007 list We have at least “design” level permission (Can create lists and document libraries and edit pages in the Web site)  to the site where the list is located we have 1 column with the “status or keyword” we want to color code The below codes for either row or cell color code will need to be added to a list view as a “Content Editor Web Part” source code. To do so: On your list view where you like to highlight something […]

For a Sharepoint 2007 list I would like to have a calculated column that calculates a 2 way status based on a calculation of days between 2 dates. (ex: project time status) Prerequisites: We have a Sharepoint 2007 list We have at least “design” level permission (Can create lists and document libraries and edit pages in the Web site)  to the site where the list is located we have 1 column called  [Scheduled GMT] (default Date and Time type) we have 1 column called [today] (default Date and Time type)  At present I was not able to find a useable and workable solution to populate the today column automatically with todays date unless the entry is updated. So for now I update the [today] column manually in a separate hidden column user for my calculation. We now go to -> Settings ->  List Settings -> create column give the column a name “ex: […]

For a Sharepoint 2007 list I would like to have a calculated column that calculates the days between 2 dates. Prerequisites: We have a Sharepoint 2007 list We have at least “design” level permission (Can create lists and document libraries and edit pages in the Web site)  to the site where the list is located we have 1 column called  [Scheduled GMT] (default Date and Time type) we have 1 column called [start_date] (default Date and Time type) We now go to -> Settings ->  List Settings -> create column give the column a name “ex: Days left” The type of information in this column is: “Calculated (calculation based on other columns)” in the Formula field insert:”=IF(ISERROR(DATEDIF([Scheduled GMT],[start_date],”d”)),DATEDIF([start_date],[Scheduled GMT],”d”),-DATEDIF([Scheduled GMT],[start_date],”d”))”Where [Scheduled GMT] is the column with the GMT Time and [start_date] is the column with a start date for the calculation. Add the new column to your view of choice to see the automatically […]

For a Sharepoint 2007 list I would like to have a calculated column that calculates the GMT -5 =EST hours for a task list. Prerequisites: We have a Sharepoint 2007 list We have at least “design” level permission (Can create lists and document libraries and edit pages in the Web site)  to the site where the list is located we have 1 column called  [Scheduled GMT] (default Date and Time type) We now go to -> Settings ->  List Settings -> create column give the column a name “ex: Scheduled EST (GMT-5)” The type of information in this column is: “Calculated (calculation based on other columns)” in the Formula field insert: “=[Scheduled GMT]-TIME(5,0,0)” Where [Scheduled GMT] is the column with the GMT Time and (5,0,0) are the hours,minutes,seconds you would like to subtract. Add the new column to your view of choice to see the automatically calculated EST time based on your GMT […]

%d bloggers like this: