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

3
votes
1answer
103 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 ...
2
votes
1answer
717 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
17 views

sorting by calculated date column in date format

I have a calculated column of date strings. The calculated field reads 5 other columns and is filled with a date STRING from the other fields. The calculated field has an type of date. The problem is ...
1
vote
1answer
38 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
42 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
1k 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
164 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
218 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
64 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 ...
3
votes
0answers
364 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
30 views

Way to calculate a column based off of a another column after filter is set?

This is the example after I filtered on what I need to calculate. JPP: = 14681369 WC/Site Code:= 386746 Bill =$1,138 ANOTHER Invoice is JPP: = 15091824B WC/Site Code:= 386734 Bill ...
1
vote
0answers
18 views

Sum and then divide columns

So I have a list in which a column needs to be summed up, then grouped so I can create another column that allows me to do division off of the summed total. So for instance John Doe 1 - 0 - 1 John ...
1
vote
0answers
64 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
35 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
53 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
351 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
263 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
84 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
332 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
83 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
357 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
37 views

How do I use COMPUTED field types in SP2013?

I currently have a limitation with some 3rd party software being unable to display calculated fields. I started investigating whether I could display my calculated field value using a COMPUTED column ...
0
votes
0answers
14 views

Problem with Excel View and Calculated Column

I have a problem both in Sharepoint 2010 and Sharepoint 2013 when I create a Excel View to list, and have got a Calculeted Column there after klick on calculeted Column I can edit Excel formulas and ...
0
votes
0answers
25 views

Update Sum from Total from one list into line of new list

I am trying to find a way to group list items, take the total of a column and have that number updated in another list automatically. So here is the process. Invoice-- Amount-- Tax ...
0
votes
0answers
52 views

Item has already been added. Key in dictionary: 'Date_Date' Key being added: 'Date_Date'

How do I resolved the error in SharePoint 2010: Item has already been added. Key in dictionary: 'Date_Date' Key being added: 'Date_Date' I get this when I try to add a calculated column in site ...
0
votes
0answers
50 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
56 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
42 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
34 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
33 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
25 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
38 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
51 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
42 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
238 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
67 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
49 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
13 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
15 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
278 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
33 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
114 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
65 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
183 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
32 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
146 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
45 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
67 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
73 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 ...