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

Calaculated column to display the next 8 business hours

In one of the column I am having the current date and time based on that using calculated column I have to show the date and time of the next 8 business hours date and time. How can this be done?
0
votes
1answer
28 views

Display an image based on date range

I have a SharePoint list of devices that are checked out or reserved by a personnel. We check them out or reserve them based on the requested dates that has a start date to finish date column. How ...
0
votes
1answer
94 views

Can MIN and ISBLANK be used together in a calculated column?

I have a custom list that displays the expiry date of Certificate 1 and Certificate 2. Candidates must have both to be considered Certified. The Certification expiry date is the earlier of the two ...
0
votes
1answer
51 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
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
1answer
84 views

formula to select a choice column

I have two choice columns in a list : choice column 1: values 1 posible 2 unlikely choice column 2: values A bad B very bad and I want to select another choice column based on the previous selected ...
0
votes
1answer
21 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
172 views

How to render HTML/Plain Text to the filtering drop-down columns

I have a custom list, with some columns. In order to design my list with colors, I used calculated columns with a Content Editor Web Part which contains my script (JavaScript). I used this script : ...
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
1answer
623 views

Folder name as calculated field

I've created a Library which consists of two Folder Content-types. Customer Prequalfication I'm looking to create a calculated column in the Prequalfication folder content-type which fetches the ...
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
145 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
46 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
46 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
456 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
189 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
34 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
104 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
54 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
349 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
325 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
366 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
77 views

Writing an expandable conditional column formula

ModuleNum&"."&SectionNum&"."&Sub1_SectionNum&"."&Sub2_SectionNum&"."&Sub3_SectionNum&"."&Sub4_SectionNum&"."&Sub5_SectionNum&"."&Sub6_SectionNum ...
0
votes
1answer
715 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
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
3answers
687 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
60 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
697 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
456 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
266 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
813 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
152 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
147 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
63 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
909 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
131 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 ...