Tag Archives: Status

Home »  Tag: Status

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: […]

%d bloggers like this: