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

0
votes
0answers
75 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
132 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
30 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
45 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
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
1answer
45 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
418 views

Remove spaces from column

I am not sure if this is can be done with a calculated column or with a sharepoint designer workflow, therefore I used both tags. Basically I need a way to remove all spaces from an existing column. ...
0
votes
1answer
23 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
184 views

Manually Refresh All Items for Calculated Field

Using SharePoint 2010. Currently I have a column that is calculating the "Days left to respond" using the formula below. =IF(IssueDate>0,IF(CurrentSPIResponseDate="",ResponseDueDate-NOW(),""),"") ...
0
votes
2answers
33 views

Is this possible with calculated column?

Here is what I am trying to achieve: I have a column with this 2014-NNNN/XXT I need to extact the number part (NNNN) and increment with nearest multiple of 10. So for instance if the number is 5010, ...
0
votes
1answer
102 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
53 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
336 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
307 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
351 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
2answers
74 views

Writing an expandable conditional column formula

ModuleNum&"."&SectionNum&"."&Sub1_SectionNum&"."&Sub2_SectionNum&"."&Sub3_SectionNum&"."&Sub4_SectionNum&"."&Sub5_SectionNum&"."&Sub6_SectionNum ...
0
votes
1answer
674 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
0answers
66 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
3answers
663 views

Automatically add value to column of new list item?

How can I automatically add a value to a column when making a new list item? Like, if I make a new item in a list named "Announcements", and I want the "Expires" column to automatically get a date 3 ...
0
votes
1answer
58 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
2answers
663 views

Calculating the Number of times “Yes” appears in a column

I am using SPD 2007, Sharepoint 2007. I have a list that has a column of Yes/No choices. I need to calculate the number of times "Yes" is chosen. Is there a way that this can be done with ...
0
votes
1answer
46 views

Sharing a calculated value between lists

I have to create two separate lists. One list is an overall master table of data, the other is a list that shows the total for selections on the master. What I need to do is to calculate out the ...
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 ...
0
votes
1answer
453 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
252 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
768 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
149 views

Calculated columns, columns names and localization

I provision a list in SharePoint 2010 with two date fields: one for a start date and one for an end date. I would like to add a third column for the duration. Naturally, I could add a calculated ...
0
votes
1answer
2k views

Designer Workflow: “Find Interval Between Dates” action not working

I am testing a default SP Designer 2010 workflow action called "Find Interval Between Dates" located under the "Utility Actions" category. I need to compare the amount of time passed between the ...
0
votes
1answer
145 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
62 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 ...
0
votes
1answer
1k 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 ...
0
votes
1answer
886 views

Can Search be performed on a calculated field in advanced search? (SP2007)

I have yet to find a definitive answer to this question. Right now this does not work for me in sharepoint 2007 and the only common characteristic I can find for the fields is that they are calculated ...
-1
votes
2answers
127 views

Add calculated column data with decimals

Is there any way to sum all values in one calculated column without losing decimal data? We're using an XPath expression and it loses all decimal information. Where @myField is one calculated column ...