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
1answer
70 views

Duplicate filter values in a calculated column

I have a document library with a calculated column. This document library is populated from a windows service. Every time a new document is added, the calculated column has a formula to choose ...
1
vote
1answer
30 views

Searching between two separate lists for matches

I have two SharePoint Lists each with a column called Unique Key, what I need to do is search list B for matches in List A. List B is the larger of the two and each List contains only unique entries ...
1
vote
1answer
40 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
637 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
138 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
172 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
546 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
63 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
411 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
435 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 ...
2
votes
0answers
353 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 ...
1
vote
0answers
36 views

Update SharePoint calculated column on Infopath form

I have an Infopath 2010 list form that displays a couple of calculated columns. My users have asked if I can make those fields update dynamically while the form is open. I have already tried moving ...
1
vote
0answers
29 views

Calculated Field formula for triggering the task 15 minutes before the starting time

I need to use a calculated field in order to trigger before 15mins of the task starting time. Please let me know what is the formula that I can use for this. Is it something like below? =[Start ...
1
vote
0answers
49 views

; or , in calculated columns

I can't understand the choice of the separators in calculated columns. I'm using SharePoint 2007 (MOSS), and I wrote a calculated column in order to extract the month name from a date. I used this ...
1
vote
0answers
234 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
0answers
227 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
76 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
283 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
74 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
324 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 ...
0
votes
0answers
6 views

Calculate Field with a Lookup Additional Column

Would like to ask some suggestion if i have 2 lists (Vendor List & Order List). Where Vendor List is contain with name & discount fields And i create new list "Order List" with field Items, ...
0
votes
0answers
26 views

Copy calculated column to another column in same list

I have a list with the columns rID, requestID and some other columns. Here rID column is type number and it will set the value from workflow. requestID is type calculated column and starts with some ...
0
votes
0answers
25 views

Calculated Field with Multiple Columns

Thanks for providing this website as a resource. I am needing some help with coding a Calculated Field. I have 4 columns that all have an answer of Displayed or Not Displayed. In my calculated ...
0
votes
0answers
19 views

SharePoint 2007 - column behaviour

There are few columns in task content type which are calculated, the hyperlinks to edit these columns are disabled, and hence cannot go to managecontenttype.aspx by clicking on the colmumn names in ...
0
votes
0answers
27 views

How to add a Sum, Avarage to Calculated Column

I must add an Avarage field to Calculated Column. How could I add an Avarage sum to Calculated column. When I tried to add by the View, the View doesn't see calculated Column.
0
votes
0answers
29 views

SP 2010 TEXT Function Subtracting 1 hour

I have a calculated column on a calendar that just formats the start time of an event. I am just using the TEXT function to format the time as hh:mm but for some reason the output of the function is ...
0
votes
0answers
19 views

SharePoint Designer workflow: Interval between the days is -0.7

My library having StartDate and DueDate columns, with one reusable workflow is associated. Using workflow Find Interval between days action, DueDate is updating with (days between Today and StartDate ...
0
votes
0answers
20 views

Passing Parameter to Site Page or Webpart or Solution of some sort on SP10

I have a Windows Application in Java that i would love to connect to a Mind(Application of some sort) in SharePoint. I need to pass some number-parameters to it and it then has to give me also a ...
0
votes
0answers
25 views

Function to update date not working properly in list

I have a sharepoint list that calculates the expiration dates of items and does so by subtracting Todays date from the expiration date. In order for it to work properly, Today's date needs to update ...
0
votes
0answers
44 views

Can I create a list which counts the number of documents of a specific metadata type by the folder they are stored within?

Running SP2013 Foundation. My users interact by uploading documents to personal folders within a document library, selecting the type of document they have uploaded via a lookup column and SP list. I ...
0
votes
0answers
34 views

Calculated Colum to pull Image filename and add Network Path

I am working on a project that will have nice Web ready images in our SharePoint (online) site. Each one of the images also has a hi-res counterpart that is on a network drive. The filename is the ...
0
votes
0answers
193 views

SharePoint 2010 - Custom List - Sum of Group and display in Chart web part

I hope anyone out there will be able to help me :) I have to create monthly reports on SharePoint that show a count of something. The reports must include a grand total (corporate level) and sub ...
0
votes
0answers
44 views

Creating a Calculated Date Field with embedded double quotes

I have been provisioning a load of Site Colummns with PowerShell . I am however, having a lot grief with a calculated field spField.Formula = "=TEXT(DATE([Created],"mmyyyy"))" spField.OutputType = ...
0
votes
0answers
35 views

How to copy calculated field formula client-side?

I am trying to copy a calculated field value from SharePoint (using web services) Paste the field value to another field Problem is this: SharePoint seems to give me two wrong versions of the ...
0
votes
0answers
12 views

Can you have a seperate indicator field that lists columns when data is entered?

Is this even possible? I have a list for used for new employees to track what training they have completed. The list has the following columns; First name, last name, when they joined and the dates ...
0
votes
0answers
14 views

Problem with filtering in a calculated value

I have a calculated value field, named Year1 = TEXT(mydate"yyyy") In allitems.aspx, if I select one year, it doesn't show anything. If I select two years, it show the results of the first year that I ...
0
votes
0answers
116 views

how can we get the Current UserName instead of LoginName using calculated column in SharePoint 2013?

using [Me] as formula in column gives me current user login name. help me out if we can get the user name instead of login name.
0
votes
0answers
32 views

Calculated column help

I have a Column with Title like below "sharepoint Documents(sp2010)". Now i want to have a calculated coulmn that will have sp2010. I have tried like this it is working but it has the value like ...
0
votes
0answers
96 views

Updating a (calculated) field based on lookup field :: Workarounds

I am a site owner in SP2010 impl., at work. Not a farm admin / super admin. For one of my needs, I am designing a list using Datasheet View. I have columns of People, Lookup and Choice datatypes. ...
0
votes
0answers
58 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
138 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
28 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
59 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
116 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
44 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
20 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
71 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
32 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
59 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
68 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 ...