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
33 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
59 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
98 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
96 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
174 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
57 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
296 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
236 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
135 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
473 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
148 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
245 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
12 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
14 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
38 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
10 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
98 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
43 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
27 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
150 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
75 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
118 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 ...
0
votes
1answer
198 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
43 views

Update Calculated date if not already entered

I have a field Closed_Date which is automatically calculated as =IF([Issue Status]="Closed",Modified, "") But this gets updated everytime I edit the entry and save. How do I update the field only ...
0
votes
1answer
194 views

Calculated columns using ID field not showing all details

I am a Sharepoint site admin without any development tools, I'm solely battling on with the Sharepoint web front end. What I would like to do is to create list items and generate a unique reference ...
0
votes
1answer
108 views

Help with Conditional Statement (Calculated Column)

I have created a sharepoint workbook with contract information. Three columns in this sharepoint have dates. ([Planned Release Date] , [Revised Release Date] , and [Current Release Date]). I have ...
0
votes
1answer
124 views

SharePoint 2007: Calculated column - formula for calculation based on column containing NA

In a SharePoint list, I have 6 numeric columns that can contain numbers in the range (1,4). However, one or all of these columns may contain "NA" value. There is a separate calculated column which ...
0
votes
1answer
91 views

How can I get a daily hour value from a date/time field?

I am trying to calculate the amount of time on a daily basis. Currently I have calculated "[total hours per diem]", "[total days]" and the time values (if not split over multiple days). Where I am ...
0
votes
1answer
60 views

Calculated coulmns in sharepoint 2007

I need to use text formulas, but I also want to include data in coulmn 'ID'. As this is default column for any list it is not available in default selection. So I have added it manually. Now old ...
1
vote
0answers
41 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
51 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
169 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
52 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
264 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
316 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
22 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
13 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
21 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
10 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
46 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
45 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
17 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
24 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
107 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
40 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
79 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
57 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 ...
0
votes
0answers
74 views

Intermittent calculation failures in calculated date column WSS 3.0

Little late in the game to still be asking WSS 3 questions but I'm stuck with Project Web Access 2007 so that's what I have. I created a calculated column in a document library to give me the Week ...
0
votes
0answers
68 views

SharePoint 2010 Calculated Date: Monday of the current week

I want to have a date column in a list that will auto-populate to Monday of the current week. So, for example, say I was adding an entry to the list today, Tuesday, June 11 (6/11/2013). The date ...
-1
votes
0answers
21 views

Calculated Field - Based on Drop-Down Field, Populate Multiple Lines of Text Field

We have a list that looks like this: **ID # File Name Confidential Redact** 001 XXX_SOC Confidential We need to have the redacted multiple lines of text field auto-populate ...