Calculated columns are the SharePoint equivalent of Excel formulae. They allow you display values that are calculated from the values of one or more other columns. These calculations can be made using standard mathematical operators and SharePoint's built-in functions.

learn more… | top users | synonyms

0
votes
4answers
2k views

Trouble with IF formula

We have a task list with a column that categorizes tasks into one of 12 categories. We're trying to calculate a NEW column that will be populated with one of two values, "Technical" or "Procedural" ...
1
vote
1answer
4k views

How can I get HTML to display properly from a calculated column? [duplicate]

Possible Duplicate: how to show HTML code in column? I have a calculated column where I am generating some HTML code based on values in the list item. How can I get HTML to display ...
2
votes
1answer
5k views

SharePoint List Calculated column to calulate Totals

I could import the excel data shown here to a SharePoint list 2010.I imported all the columns. Let's say I have two columns. Name and Value. For Value column, I have numeric type. I need to calculate ...
0
votes
2answers
420 views

Trying to detect published documents

I have a site that has a document library and I made a calculated field for the content type called status that determines if a file is published or not. I used ...
0
votes
1answer
141 views

Sharepoint Column Totals to User - Value defined by status

So I have two list databases. User Points User Submissions These two databases work together. A user 'submits' for points in a status of 'submitted'/UserPoints[PendingPoints:Column] once 'approved' ...
0
votes
1answer
234 views

Calculated column to split the url Moss 2007

I have a link column eg: http://abcd/Shared%20Documents/test.doc. I need to create a calculated column to just get the name of the file..in this case "test.doc". Any help with the calculated column ...
0
votes
3answers
1k views

Calculated value column

In SharePoint foundation 2010 can i add a new calculated value column where the calculation are based on when another column is modified ?
1
vote
2answers
931 views

SP2007 formula to remove every occurrence of '#;' from a field

I want to create a calculated column to have values without the '#;' in it. What is the formula to do that?
5
votes
2answers
27k views

Column calculated value to get the current date time?

I have tried using =TEXT(Today,"mm-dd-yyyy hh:mm:ss") but that only returns the 5/5/55 00:00:00, it won't give the time. How do I get both the date and time with a calculated formula?
2
votes
2answers
2k views

Using SharePoint version number in calculated column?

I'm trying to get the value of column "Version" in a calculated column. I'm not sure if it's a bug with SharePoint 2007 but every time a document is updated, the version number shown in the calculated ...
3
votes
2answers
2k views

IF statement, Trouble with formula

I have created a simple list where we record time spent on troubleshooting customers. But now I would like to create a simple formula for a Calculated field, but I can't get it to work. We have two ...
3
votes
1answer
293 views

“Changed On/Modified” columns - Date Format & Regional Settings

I was wondering if I change my regional settings through: Site Settings - Regional Settings - Locale: Dutch (Netherlands), affects the date format of the standard columns (Changed On/Modified e.g.). ...
8
votes
2answers
21k views

Using calculated field to retrieve substring of another field

Suppose I have a field that contain the following data: ========================== | Email Address | ========================== | Jack@wonderland.com | | Peter@nobodyland.com | | ...
3
votes
2answers
1k views

How to create a calculated column based on Workflow Status column

I want to create a calculated column based on Workflow Status column which the system is not allowing. The error is "One or more column references are not allowed, because the columns are defined as a ...
2
votes
5answers
6k views

How do we create dynamic url in Sharepoint 2010 Calculated field

I am working on creating sharepoint dashboard using color coding. I have my custom list created and all of the traffic lights are working based on condition user provides. Following is the basic set ...
1
vote
1answer
4k views

Using an Additional Lookup Column Value in a Calculated Column

I have a lookup column based on another list's description (a 'Category' list) and have ticked the other list's 'Category ID' column to be shown at the same time (I note that this is a manually ...
0
votes
2answers
9k views

How to get Full Name in 'Calculated Column' from User Id in SharePoint List

I have a list with a column which consist of user id. there is also a calculated column which has to get the full name from this id. I was able to achieve this by installing custom WSP. Is there any ...
3
votes
2answers
2k views

How to calculate business days excluding Thursdays and Fridays given between two dates?

How to get the business days excluding the weekends (Thursdays and Fridays) in between two given dates? Given dates are two list columns (Start Date & End Date) and business days is a calculated ...
1
vote
1answer
797 views

Substring-after or similar to extract ID from a URL?

I'm using a script-based solution to add a Comment Box to dispform.aspx in a MOSS document library. The comments live in a separate list and I have a requirement to show the Name metadata from the ...
1
vote
1answer
782 views

How to Retrieve Numeric Column value from SharePoint List

In the SharePoint list I am having the numeric column and the value is like this 123,456,789,012,346,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000. I am using SPQuery to retrieve items ...
4
votes
5answers
16k views

How do you Sum a Calculated Column?

I have a calculated column in a list and I would like to get a sum of that column in the view. I can't use datasheet view, and I don't like the idea of a workflow because the user only sees a few ...
2
votes
2answers
2k views

Calculated column based on number of entries of each choice in a choice column

I am working in SharePoint 2010. I need to make a chart to represent how many projects we have from each division. We have a SharePoint list of our projects with a choice column of all the divisions. ...
3
votes
3answers
3k views

Sharepoint - Calculated Column showing different colours based on list item age

Marc, I understand you are a busy man, but if you can spare atleast sometime to my query below then I will really appreciate the gesture. Background: We get several requests (items on SharePoint ...
1
vote
3answers
2k views

Calculated field - Get Modify Date when a Particular Column is get Changed

How to get a calculated field with modify date, when one field or column changes in the share point list. For example, If I have a field status, i should get a modify field populated with today's ...
3
votes
4answers
12k views

How to use calculated field to retrieve the ID of the item in the SharePoint 2007 List?

I have a calculated field in a SharePoint 2007 list. I want this calculated field to include the ID of the item but I could not find the ID column inside the "Insert Column" List box. How should I go ...
1
vote
2answers
1k views

What is the formula for calculated field to calculate the milliseconds of the field “Created” in SharePoint 2007

In SharePoint 2007 List, there is a field (or column) called "Created". It contain the date in which a item is created. I want to create any field, a calculated field, to help me calculate the ...
5
votes
4answers
3k views

calculated field - formula for ageing

Again a calculated field question, How can I create a calculated field to find out, what is the age of the entry. In the list I will have a created date field, from that I would like to create a ...
3
votes
1answer
4k views

Calculated field Date formula

I have a date field, and it has the date in the format - 11/2/2011 11:40 AM How ever my requirement is to get the date in the format - 02 Nov 2011 11:40 AM For that I created a calculated field for ...
0
votes
2answers
424 views

calculated fields

I'm using SharePoint 2007 and I'm working on a List in a DataSheet view. I created the field "Color" - a dropdown field that contains: "Yellow","Green","Blue". I also created the fields: ...
1
vote
1answer
910 views

Problem with formula when creating calculated column when referenced column that has space in its name

Not sure what the problem is but when i use the following formula when creating a calculated column =IF([Event Type]="","Black",IF([Event Type]="PFL","Red",IF([Event Type]="VCL","Gold",IF([Event ...
2
votes
1answer
2k views

Calculated Column - Last Name from Full Name

I'm trying to write a calculated column formula to return the Last Name from a column that currently has employee's full names. The problem that I am having, is that the full names are stored in a ...
3
votes
3answers
7k views

Creating CASE statement with Calculated Column

I am using SharePoint 2010. I added a new Column and made it a Calculated Column. Now I need to place a CASE statement in my Formula. Something like this... CASE when [Region1] = 'A' and [Region2] ...
0
votes
2answers
778 views

How to prevent #NAME? error in Calculated (Site)Columns

In SharePoint 2010 I've made a lot of Site Columns that I use in different content types. When I make a calculated column, that involves a calculation based on other columns, something goes wrong. ...
0
votes
1answer
267 views

Calculate Time Passed After Item Created Using Javascript (or other)

I have a list that tracks loaned equipment. I want a little icon that is a visual indication at how long the item has been on loan to help visually cue employees to follow-up. For example: 0-4 ...
0
votes
1answer
254 views

calculate column

I'm using SharePoint 2007, Custom list. I have created calculate column. in order to configure this column I need to insert the column name and to create a formula. Is it possible to write a range ...
3
votes
2answers
2k views

How do I use “Approval Status” in a Calculated Field

I am trying to create a calculated field that will add the text [PEN] to the beginning of the displayed text on my Calendar when the event is still "Pending" according to its "Approval Status". If ...
1
vote
1answer
3k views

Reference a hidden column in a calculated column

In SharePoint 2010, I have a document library in which I want to add a calculated column, which references the Name of the document. Entering the following formula works fine: =[Title] But I can't ...
1
vote
1answer
711 views

Can I change a calculated column to a Yes/No column?

I currently have a list created with multiple column and column types. One column is a formula based on the answer of another....I need to change the column to a Yes or No choice instead of relying ...
2
votes
5answers
5k views

How to add line breaks in calculated columns without going into data view?

Just wondering how to create a list with line breaks in a calculated column without using data view.
1
vote
1answer
523 views

How Can I Perform a weighted average of 2 columns?

I need to set up a number of mini-project sites that have "Task", "Effort (md)" and "%complete" columns. Below these listings I need a weighted total % complete. This is done by multiplying effort x ...
3
votes
2answers
6k views

How to find out the number of the week in a calculated field?

How can I calculate the number of the week based on a date in a list? I tried several examples I found on the internet, but none worked correctly? The formula should comply with the ISO standard ...
3
votes
1answer
1k views

Unescape HTML from list column

I've got a multiline column in a list that contains HTML. When trying to use the field in SharePoint Designer 2010, it shows it as raw HTML, instead of rendering it. So using this syntax: ...
1
vote
4answers
5k views

URL in calculated column

Is it possible to have "clickable" URL address in (SP 2010) calculated column without any JavaScript code or Designer? I found the way how to easily make "universal" Document ID links visible for ...
1
vote
1answer
161 views

Creating 'Task Ranks' depending on user

I need to create a column 'Task Ranks' - which ranks each task/item for a user. I need it to be of lowest unique value/integer from all active tasks for that user and to serially generate the next ...
1
vote
2answers
152 views

Calculating event lengths that cross time changes

I have a calculated field to work out the length of an event in days, as follows: =DATEDIF([Start Time],[End Time],"d") I live in the UK and we're currently on BST; so if I create an event in GMT ...
9
votes
2answers
1k views

How can I display a message on a list item when within X days of a date?

I'm using SharePoint 2010 and I'd like to create a column in Task List that will display a message (not generate an email: just display a field text) such as "URGENT" or "Almost Due" when the date is ...
2
votes
2answers
711 views

Create a calculated column to diplay midpoint between 2 dates

Any help greatly appreciated. I'm using SharePoint 2010, typical TASK LIST. I want to put in a start date and a a due date but have a field (column) that displays the MID WAY POINT between those two ...
2
votes
2answers
159 views

calculated field help, moss 2007

I'm trying to build a calculated field with the following condition: if [field1], [field2], [field3] = approved set [field4] = 1 if [field1], [field2], [field3] = denied set [field4] = 2 else ...
0
votes
1answer
705 views

Can Search be performed on a calculated field in advanced search? (SP2007)

I have yet to find a definitive answer to this question. Right now this does not work for me in sharepoint 2007 and the only common characteristic I can find for the fields is that they are calculated ...
7
votes
4answers
1k views

Check if more than 3 hours

I need a calculated column to display "Yes" if the current time is more than 3 hours after the value of another column. This is what I've come up with: =TEXT(Today-[AddTime],"h")>3 But ...