Tag Archives: Calculated Column

Home »  Tag: Calculated Column

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: