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

1
vote
1answer
36 views

How exactly does =[Me] work?

I've read that in 2010, using 'volatile columns', like [Me], isn't encouraged. Though this functionality is needed as a default value for a column separate of Created By or Modified By. However, when ...
1
vote
1answer
146 views

Unable to add a Choice field to a Calculated field (SharePoint Foundation 2013)

I'm not sure why I'm having this issue, as all material says that I should be able to do this... I have a required choice field that I would like to use in a calculated column. However, when I try to ...
1
vote
1answer
111 views

how to change the format of the “person or group” column

In my document set (Sharepoint 2010) I have a column with type of “person or group” which I can add the name of some users to it. The format of the names is like this: firsName1 Surname1; firstNmae2 ...
1
vote
1answer
115 views

Sharepoint Percentage Working Out

Scenario: We quality score work in our business to ensure this is updated correctly and we give each 'engineer' a mark out of 5 each week. Currently we are able to work out the percentage each week ...
1
vote
1answer
264 views

Calculated column is not being crawled

I have a calculated site column AlertSortOrder, which I added to a list. I created a managed property nvAlertSortOrder (sortable, searchable, queryable, retrievable) mapped to the corresponding ...
1
vote
1answer
60 views

Getting Null Value with two statements in additional column settings

I am trying to subtract column "Previous Spend" from column "Current Spend" and put the balance in new calculated column named "Incremental Spend". Easy enough right. But if "Previous Spend" is left ...
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 ...
1
vote
1answer
286 views

Error with special characters in site column names referenced by a calculated column

I have a site column Construction - Complete Date which is used by my calculated column Construction - Is Complete?. Whenever a date is entered for the Construction - Complete Date then Construction ...
1
vote
1answer
168 views

Calculation field randomly forgets ID

I have a calculation column that I use to display some HTML code that provides a hyperlink in a List view. The user clicks on the hyperlink to jump to another page which will generate a report based ...
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 ...
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 ...
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
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 ...
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
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
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 ...
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
1answer
48 views

replace text with formula in calculate

How can I replace ";" in a text like this with " AND " ? example text: "abc;cde;efg;ijk" the result should be like this: "abc AND cde AND efg AND ijk"
0
votes
1answer
14 views

calculated formule help

I have a field Title with value like below Title=3.10-gotomeeting I want a calculate formule to remove ("-")and (".") so that the output should be only a number i.e "310". Can any one help me on ...
0
votes
1answer
190 views

How to set a column value based on another column value

I have a sharepoint list which contains a drop down of the values , Immediate , Hire , Specific I have another column Grace Period which is a numeric When the drop down column Immediate is selected ...
0
votes
1answer
52 views

Extract data between parenthesis in calculated value field

I'm using SharePoint 2007 and I would like to extract data from parenthesis from another column to a calculated field in the same list. For example: Column named "Team", value "RED (Mark, John, ...
0
votes
1answer
34 views

New Item Fields Automatic Population

I sure this is possible to do in SharePoint, however, I am not 100% sure on how it's to be done. My objective is to 2 fields to automatically populate when adding a 'New Item' to an List Library. ...
0
votes
1answer
220 views

How to add a calculated column which shows the modified date/time of an attachment?

I have a list where each item has an attachment (or in some cases 2 attachments). I would like to add a "Last modified" column in a view which shows the date/time of the last attachment modification. ...
0
votes
1answer
148 views

Padding a numeric string in a calculated column

I need to pad a numeric string using a SharePoint calculated column. I have two fields, Sectiontxt and calcPadNum. For example, if a user enters 1.12.1 into Sectiontxt, I want calcPadNum to be 011201. ...
0
votes
1answer
169 views

Calculated Column formula returns syntax error

Found this one that seems to be the solution needed but i cant get it to work: Column1 has the value of BD122 Formula: =EXACT([Column1], "BD122") Expected result: Compares contents of Column1 and ...
1
vote
0answers
115 views

Calculated field with library folder name

I have a library (e-amil enabled) with e-mail with attachments and I need to make a calulated field using the e-mail subject. The problem is that the calculated field shows only when I drill down the ...
1
vote
0answers
61 views

Calculated Fields and language packs

We are programmatically deploying a calculated field in a Sharepoint 2010 website using a site collection feature. Now we need to add localization support for a number of diff languages, so we had to ...
1
vote
0answers
207 views

Calendar Start and End Dates not correct

I am having trouble with out SharePoint calendar. I have some calculated columns set up to display start and end times for anything that is not an all day event (based off the guide here), but some ...
1
vote
0answers
59 views

Display number of events per day in SharePoint 2007 Calendar

I have a SharePoint list which contains project name, start date, and due date. I have created a SharePoint calendar based on this list that displays the contents of this list in a calendar format. ...
1
vote
0answers
281 views

Calculated columns supporting all column types

I would like to develop a column which will allow the end user to do the calculations based on values of other columns of the same item (SharePoint 2010). I need it to work also with people, look up ...
1
vote
0answers
335 views

CAML Contains on a lookup field of a calculated column

I have some issue when using the CAML Contains statement when the field is a lookup field on a calculated column. It basically does not work, the Equal works though. here is the query, nothing ...
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
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
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
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" ...
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
0answers
43 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 ...
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 ...
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, ...
0
votes
0answers
35 views

List template with a calculated column referencing another calculated column

I have a list that includes a calculated column that uses the result of another calculated column in its formula. When a list template is created and then I try to use the list template it gives the ...
0
votes
0answers
23 views

SP2013 - Calculate a coaching Score from a sharepoint list

Scenario : We use a sharepoint list with a custom InfoPath form to Quality Coach our colleagues. The list itself is a series of questions with Yes (Y) , No (N) and Not Applicable (X) as options. We ...
0
votes
0answers
64 views

SharePoint 2013 Online - Calculated field/Metadata email issue

When parsing out a section of text to be sent in an email I keep receiving error;#256 in place of the text. The column in the list looks good, but it's when sending out the data in an email is when I ...
0
votes
0answers
73 views

Conditional formatting not updating on calculated field

I have a calculated field with the following formula: =WENN(Fälligkeitsdatum<=HEUTE();"RED";WENN(Fälligkeitsdatum<=HEUTE()+4;"ORANGE";"GREEN")) For understanding purposes: Fälligkeitsdatum = ...
0
votes
0answers
23 views

calculated column based on a view

I have a created a calendar with 5 views to make it seem there are 5 separate calendars to the users. ( I cannot use 5 separate calendars due to workflows ) When they book an appointment on the ...
0
votes
0answers
33 views

Script File and Calculated Column Format/Data Types

This may be a bit of a best practices question, but today I made a few changes to the site/lists I'm developing to facilitate development and data rendering. In CEWPs I've begun using .aspx files ...
0
votes
0answers
119 views

Calculated column with formule in visual studio

I am creating calculated column through content type in visula studio.But the Formule is empty when i check in the calculated Column. Can any one help me .Below is the scenario which i have tried. ...
0
votes
0answers
46 views

Calculated Column returns excessive amount of zeros

In a Purchase Order form I'm putting together, I have line amount and total amount as calculated columns. However, when displayed in the InfoPath form, they show with a ridiculous amount of zeros at ...
0
votes
0answers
136 views

Displaying Calculated Form in EditForm

I have a calculated form that concatenates 3 fields. These fields are editable in the new form but in the edit form I've used Javascript to set them as readonly. What I'm hoping to achieve is to ...
0
votes
0answers
60 views

Return Surname from full name with multiple middle names

I have been tasked with extracting the Last Name from a Full Name field in sharepoint 2010. Currently I can get the Last Name for names such as John Jiles, or John Stuart Jiles, but I have not been ...