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

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
390 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
871 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
6k 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
690 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
248 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
251 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
684 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
4k 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
497 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
5k 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
4k 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
155 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
650 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
658 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 ...
6
votes
4answers
942 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 ...
0
votes
2answers
715 views

How do I set up a calculated column to reference itself?

I need to set up a column that will keep a running total of values. I have a program that automatically sets values for the columns in SharePoint. The program will overwrite the previous value ...
2
votes
1answer
483 views

How do you insert a column using the column editor in sharepoint designer 2010?

I would like to create a new calculated column in Sharepoint Designer 2010. So, IN SPD 2010 / Site columns, I click New, Calculated column, fill in the details and click OK. Up comes the the Column ...
1
vote
1answer
143 views

Cell(Column) modified date question

I would like to know if there is a way to know when a cell has been modified and to store the date and time in a new cell. Here is all the case: I have a list, that need to be filled when an event ...
4
votes
4answers
8k views

Calculated column with a Date

I am creating a list whereby I want following function: Current Day or Today - 2 days = Output Date i.e. 23/12/2010 - 2 days = 21/12/2010 Is it possible to change the current dates dynamically ...
1
vote
1answer
4k views

Not able to add calculated field in Sharepoint 2010 list

I have created a calculated field called "Overdue" and provided the below formula as mentioned in the below link. But it is not accepting this formula. Please let me know what might be an issue. ...
1
vote
1answer
1k views

HTML Calculated Column Indicators

I'm trying to insert KPI indicators from the Out of the Box SharePoint images when my slippage column is at certain points, but the indicators don't seem to be showing, please can you help me with my ...
1
vote
1answer
2k views

HTML Calculated Column Formula

I'm trying to use a HTML calculated column so that I can display a RAG status bar for my tasks in SharePoint. I had it working until I added the IF containing % complete. Can you tell me where I'm ...
2
votes
2answers
1k views

HTML Calculated Column

I'm using the HTML calculated column that's outlined on the pathtosharepoint blog, but I'm wondering, is there any way to create a calculated column, that displays a button/check box or anything that ...
3
votes
5answers
7k views

how to show HTML code in column?

how can i force sharepoint2007 (MOSS) to interpret HTML code instead of showing it? I have a column which calculates a yes or no (depending on other columns) within a HTML (i want to show images ...
2
votes
3answers
842 views

Calculated Field IF expression separators

I'm creating a list with some calculated fields from code that use IF expressions. fieldCalc.Formula = "=IF([Field1]=0,[Field2],[Field3]&\" (\"&([Field4]/[Field5]*100)&\"%)\")"; ...
1
vote
1answer
1k views

Why does my calculated column not pick up the correct ID

I'm trying to create a calculated column that uses the list item's ID field as part of the calculated string value. When I create a new list item, the calculated field seems to always use 0 as the ID ...
1
vote
1answer
691 views

Calculated Fields in Infopath

Does InfoPath allow me to use calculated fields based upon other field values on the form?
1
vote
1answer
367 views

Easiest way to display computed field Or Is custom Field only option

I have a need to calculate working days until an item is due or working days past due. I also have to exclude holidays and the holidays may or may not apply to that item based on what project the ...
5
votes
5answers
13k views

How to use [Created By] in a column?

SP 2007, calendar list. Want to add a column that gets its default value from "Created By" but then allows that to be edited. This is what I tried: Create column Give it a name Leave type set to ...
5
votes
2answers
16k views

Calculated value for Title field?

I would like to create a calculated value for the mandatory Title field: <username, created by> - DD-MM-YYYY That is I want the title to be filled in with the user name (the user that creates ...