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

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.
0
votes
1answer
24 views

Skipping blank cells when using concatenate in a list's calculated column

I am using Concatenate in a calculated column to combine information from two columns in a list like this =CONCATENATE(A2, ", ",B2," feet"). Can you help me with a formula that would leave the field ...
1
vote
1answer
585 views

Adding nested IF statements

We have a company page to track mileage on company vehicles, and at the end of every month the driver enters the ending odometer reading. I wrote a formula to figure out the mileage for the year by ...
0
votes
1answer
819 views

Can sharepoint calculate the number of “business hours” for a list item to be completed?

I work in financial institution and we want a column in a case management database to show the number of "Buinsess hours" from start to finish of a case. Business Hours Monday to Friday 5am - 8pm ...
2
votes
2answers
722 views

Calculated value for Single line of Text doesn't work

I have a column named "Risk" and the condition of the values is here: Düşük: Risk <= 4 Orta: 4 < Risk <8 Yuksek: 8 <= Risk Risk value is the sum of 2 column values. ...
0
votes
1answer
305 views

Selecting desired option with drop down menu using formula

I was creating a sample List which has Category section, under which we have three different options, namely Hindu Muslim Christian Now, i want to create another column which should help the ...
0
votes
1answer
416 views

Conditional Formatting using Calculated Column as Condition (SharePoint Designer 2010)

I want to use conditional formatting to change the color of a row based on a Calculated Column. I know I could do this with a CEWP but I would prefer to do it in SPD 2010 because I am new to ...
1
vote
1answer
310 views

SP2013 : Generate an autoincrement identifier (YYYYMMDD9999) based on creation date for a document

I need to generate a record id for a document, with format YYYYMMDD9999 where 9999 is a autoincrement number per day. This id must of course be unique, but i have no idea how to be sure to avoid ...
0
votes
1answer
21 views

Display image based on task completion

I am trying to display a 'progress bar' on a page which includes 5 different images. I would like to create a workflow where the image would change based on the completion of tasks in a task list. The ...
3
votes
2answers
52 views

Calculated Column - IF true AND true

Using a task list I am trying to show a value if a cell is = to a certain string, AND task is complete. Im currently using this but returning a #VALUE error =AND([Task Name]="Task ...
0
votes
0answers
26 views

Change calculated column to xsl:value-of select

I work with a calculated column which depends on the title column. Now i want to change the cascading title inot the filename. This should be done with the SP designer and a customization of the xslt ...
0
votes
1answer
18 views

Changing a Column Choice value and updating the column value for any previously saved items

I have a list with a choice column which has muliple choices, so that the user can pick from a selection. Would like it so that the choice list is updatable (i.e can change the names) at a later ...
1
vote
4answers
81 views

How to filter calculated columns in the filtering menu

I would like to display my calculated columns fields in plain text in the filtering drop-down menu when I click on the column title. I don't know why SharePoint displays my calculated formula instead ...
0
votes
1answer
36 views

formula to select a choice column

I have two choice columns in a list : choice column 1: values 1 posible 2 unlikely choice column 2: values A bad B very bad and I want to select another choice column based on the previous selected ...
0
votes
3answers
39 views

sharepoint list column calculation

In a new list item form,the user wants to have a column to display month & year(pre populated on opening the form) based on the below condition. "1. If the current date is > 15 ,then that column ...
0
votes
1answer
9 views

Is it possible to report an activity date and calculate which pay period it falls under in a bi-weekly schedule

I really have no idea how to address this. I am tasked with marking and developing a way to track late entries based on the created date of a list item, the reported activity date(date selector), and ...
0
votes
1answer
17 views

Calculated Date after 3 years

Can anyone please tell how to get the calculated date after 3 years from current date. I have tried different combinations none is working =TEXT(YEAR(Created)+3,"MM/DD/YYYY") It returns ...
0
votes
1answer
607 views

Have an Association Column equal the field of another Column

I have created an association column as part of a reusable workflow in SharePoint designer. I am now trying to have this column equal the field of another column in Document Library. I have tried ...
0
votes
1answer
2k views

Use value of Hyperlink column in a calculated column

I want to create a calculated column, it should show the value of Title and the URL of a Hyperlink column called Main Website. But I get an error for my formula: =[Title]&" ("&[Main ...
0
votes
1answer
80 views

How to render HTML/Plain Text to the filtering drop-down columns

I have a custom list, with some columns. In order to design my list with colors, I used calculated columns with a Content Editor Web Part which contains my script (JavaScript). I used this script : ...
0
votes
0answers
57 views

Sum of a calculated Product Column

I am working with a custom Dataview in SPD. I have a calculated field that is the product of Quantity and UnitPricing. The view is grouped by another field, so I would like to get the node subtotal. ...
0
votes
1answer
76 views

Folder name as calculated field

I've created a Library which consists of two Folder Content-types. Customer Prequalfication I'm looking to create a calculated column in the Prequalfication folder content-type which fetches the ...
0
votes
3answers
250 views

How to show two dates in one calculated column

I'm using Sharepoint Foundation 2010. I have two columns, start date and ending date. I want to make calculated column which shows both of them in the same column. Everything is okay till I add both ...
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
1answer
24 views

Calculated column being changed on save

I need to keep the URL of a list item to use in a notification so I have a formula that looks like this: ="http://basicsample.com/next/List/EditItem?ID="&[ID] When I create an item in the list, ...
1
vote
2answers
91 views

Calculated column to retrieve total number of ID

I have a SharePoint list which all has a unique ID to identify the items, so I want to create a calculated column that counts how many ID are there, like a count! Any help is appreciated
1
vote
3answers
2k views

How to convert date field in single line of text using Calculated columns

I have created a calculated field for a content type in my Sharepoint 2010 and I want to return a date in the TEXT format because I am returning some text with it. The condition I have put in the ...
2
votes
3answers
114 views

DateTime calculated Column using Formula

I have a column Birthday which contains the date of the user's birthday. I would like to create a calculated column to hold the user's next birthday. For instance, if I wanted to know the birthday in ...
1
vote
2answers
1k views

Calculated Column left align header

In my list, I want a column to have a custom hyperlink. I create a Calculated column that has the following formula. ="<a ...
0
votes
0answers
20 views

Calculated column as a quick part

I need to return a value from a calculated column as a quick part in MS Word. How can I do this?
0
votes
2answers
219 views

Set current date i.e [Today] in a list column

I have a requirement where in user wants a column to be populated with Current date i.e Today. I went through many posts and found it is not possible to use Today() in list columns. The reason why ...
0
votes
1answer
38 views

How to build a modal dialog link in a calculated column to use modal dialog

I have tried appending a hyperlink in a calculated column that should popup a modal dialog but it's not working for me. Anyone got this working?
1
vote
1answer
40 views

Resulting year of a start date and end date

I have a SharePoint list item with a "start date" and a "end date" (both are always on the same year interval). I would like to have a column with the resulting year of these two dates. How should I ...
0
votes
0answers
20 views

Issue while uploading a picture to Picture Library with Calculated Column

I have provisioned a Picture Library using Feature. There is one calculated column in the Content Type which is used in the library. My calculated column is like: <Field Type="Calculated" ...
1
vote
1answer
42 views

The element cannot contain child element because the parent element's content model is text only Error

I want to provision the field using feature. I have a field which is of type Calculated and the xml for the column is like below: <Field Type="Calculated" ...
0
votes
1answer
37 views

sharepoint calculated column to round a number

I want to calculate a field value such that if it is less then 0.5 it would be round up to 0.5 (ex. .3 would be .5, 1.3 would be 1.5, 2.1 would be 2.5) and if the value is greater then 1.5 ti would be ...
1
vote
1answer
46 views

Yes if Due Date is less than 14 days from created

I want to set the contents of a field named Rush_Flag to Yes if the field Customer_Due_Date is 14 or less days than when the record was created (Created). Created is the default timestamp SharePoint ...
0
votes
0answers
25 views

Content Type IDs help

I have 2 Content Types, A and B. I am trying to create Content Type ID's(not proper ID's) and completely separate from the ID already in the list. I am creating them as a calculated field but I cannot ...
0
votes
1answer
26 views

creating an ID using calculated value

I have 2 content types which I want an individual ID(unique for each item) for both, how would I go about creating an ID's for this. So each Content type has IDs 1,2,3,... etc. I am thinking the way ...
0
votes
1answer
34 views

SP2010: Help with calculated column for multiple columns

Sharepoint 2010 Looking for some help here as I'm sure its a simple solution. I have: 2 Yes/No Columns: DivisionA, DivisionB (I will have a total of 15 divisions but using 2 for an example) 1 ...
0
votes
0answers
44 views

Add month in calculated date column

I'm using SharePoint 2007. I've a column with date in format DD/MM/YYYY I've also another column where I want to add some months to the previous date and obviously I've a column with the number of ...
1
vote
2answers
7k views

How can we create and calculate a ([Due Date]- [Today])/7 column in SP 2010?

How can we calculate ([Due Date]- [Today])/7 column that updates daily as value of Today changes and lets us calculate weeks left for due date ? Could create ([Due Date]- Today() )/7 and it worked ...
5
votes
2answers
26k 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?
0
votes
2answers
469 views

Sharepoint Document Library - Choice Column Default Value Calculation

I have a Shared Document Library with a choice column with 3 choices: Test1, Test2, Test3...now I also have 3 views, one for Test1, Test2, Test3, this is because I have three pages where I want to ...
0
votes
1answer
24 views

Getting Calculated Filed Data into Links

I know I can make links with calculated fields; however, I am having a hard time getting the value of a column I need within the URL. Here is my code. I think I am close here but still having ...
1
vote
1answer
266 views

Calculated Fields and Outputting to Excel

So my issue is with Sharepoint 2007 and what is happening is that when I output to a excel spread sheet a custom view, If I export some calculated columns it also brings in the columns that were used ...
0
votes
0answers
36 views

Calculated field from Sharepoint to Infopath

I created a list in sharepoint with some calculated field. When i modify the form through Infopath the calculated field doesn't contain the formula that i wrote in Sharepoint. For example: In ...
1
vote
1answer
158 views

using calculated field in calculated field

I have field1, field2, field3, calcfield1, calcfield2, complexCalcField1 Calcfield1 and Calcfield2 use field1, field2 and field3 for its values. ComplexCalcField1 uses Calcfield1 and Calcfield2 for ...
0
votes
1answer
27 views

Calculated column shows the value of another column, how in SP2013?

I have sharepoint 2013 portal. I have a list with some columns. Now I would like to add a new calculated column. In this column I would like to show the selected item in another column. This other ...
0
votes
0answers
17 views

I added a calculated column to my contenttype, but dont see all my other columns to use in formula, why?

I am using sp2013. I have a custom list and custom contenttype. In this contenttype I have many columns. One of the columns is a calculated column. I can implement a formula in this calculated column, ...