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
351 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
635 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
0answers
75 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 ...
1
vote
2answers
109 views

Calculated Column with time element

I know I've read that dates and time don't do well in lists. Does anyone know a workaround to create a calculated column that will bump the number up in the column by 1 every 24 hours. So the column ...
2
votes
1answer
103 views

Nesting double condition formulas

I need to nest several formulas just like this one: =IF(Service="ACB",(IF([Fac/Fellow]="Faculty","002701284","")),""). So first condition is: ...
2
votes
1answer
82 views

Calculated column based on 2 other columns

I want to create a calculated column that evaluates the conditions of 2 other columns to decide on a response. Column A Column B Column C So if Column A=aaa and if Column B=bbb then Column C should ...
1
vote
1answer
210 views

Calculated column help - nested if for all not null columns equal low then low

I have a calculated column (see below) testing the content of six rating columns and it is working, however, I want to add a condition so that only those columns that are not null are tested. A list ...
0
votes
1answer
22 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
27 views

Using field [year] in calculated column issue

I have an issue with the calculated field. Basically in SharePoint 2007 I have my field called Year, so this Year I would like to use in another calculated field. So I create the field and put there ...
1
vote
0answers
238 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 ...
0
votes
1answer
397 views

Calculating coloumn based on choice coloumn

I'm new to sharepoint and I wanted to create list about employee information, in which Experince level of employee is calculated based on its designation where, Experience level is text area and ...
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 ...
1
vote
1answer
89 views

Example of a workflow pulling lookup column data for use in a calculated value column

I'm looking for an example of a workflow using SharePoint Designer 2010 that pulls information from a lookup list or via a lookup column and places it within a hidden field for use in a calculated ...
0
votes
3answers
389 views

Override calculated value column in list

I am not sure if you consider SharePoint "programming" but I am very new to it. I would like to create a list with calculated values but still provide the user the ability to edit the values. For ...
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 ...
2
votes
1answer
40 views

Unable to retrieve ID # in calculated value column

So I manage to do a calculated value column and incorporate it with the default ID # SharePoint assigns on each list entry. However, I notice that there are a few that it was not done so. please see ...
0
votes
1answer
379 views

Calculated column: Lookup

Say I have a Date/Time [Date] column and a numerical [Value] column. I am creating a calculated column. I need a formula that will find the row with the most recent date in the [Date] column, then ...
0
votes
1answer
350 views

Sharepoint List auto ppulate

Team, I have 2 Lists. In first list i have 2 columns called ProjectID,project title In second list i have same 2 columns Requirement: When i select project title in second list,The projetc ID ...
0
votes
1answer
121 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
1k views

Calculated column issue with if statement and yes/no field

I have seen other similar questions about calculated fields/columns and Yes/No fields, but only regarding syntax. I don't have an issue with the syntax (I think) but I can't get an IF statement to ...
2
votes
1answer
345 views

Calculated field shows seemingly random number when set to be empty

I'm trying to set up this solution for creating a filtered lookup: How to make a filtered lookup field I have set up an ItemAvailable column like this: The column "Availability" is a choice ...
0
votes
2answers
29 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, ...
1
vote
1answer
572 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 ...
1
vote
1answer
509 views

Help with 'IF' Statement for Calculated Column

I need help writing an IF statement for a SP calculated column. I have it working right now to display the green indicator, but need to add the clauses for it to display the yellow and red indicators ...
1
vote
2answers
830 views

How could I have a custom task list update all start dates if an item is changed?

I'm not exactly sure how to approach this problem. I am hoping it can be solved with calculated columns or thru a workflow. If it can only be accomplished with some advanced technique beyond the ...
4
votes
3answers
641 views

Get difference in Minutes for DateTime format column

I have a formula for calculated column which gets the date difference in hh:mm format. =TEXT([COLUMN2]-[COLUMN1],"h:mm") But I want to get the difference in just minutes. I created very complex ...
1
vote
1answer
194 views

SP2010 Javascript Object Model: programmactially add calculated column to list

I am building lists and adding fields via the following. I am wondering if I can add a calculated field and how you set the formula in this (or another method): function onCreateRootCause() { var ...
1
vote
1answer
725 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
2answers
2k views

Calculated column value for Yes/No field in sharepoint

I am developing a KPi, where am using a column named Complete which contains Yes/No field in it. For this if i write a calculated value for yes/no field: =IF(CompletedTask=1,"Yes","No") its not ...
0
votes
1answer
150 views

Calculated field with images and multi-value column

Say I have this list that looks like this: Title Link ----- ----- Cat /animals/cats.aspx Dog /animals/dogs.aspx Duck ...
0
votes
1answer
2k views

How can I use data from Managed Metadata Columns in Workflows and Calculated Fields?

It seems that sharepoint does not allow MM columns to be used in calculated fields, and I'm not sure how to use them in a workflow either. Can someone please inform me as to how I can use terms in the ...
0
votes
1answer
94 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, ...
1
vote
1answer
103 views

Calculated value formula

I need help with the formula for the following problem. I have a list where you fill in a number of ordered items, and another column where you fill in how many of the items that are receieved. Lets ...
1
vote
2answers
772 views

Calculated column, when does it recalculate?

A calculated column refreshes its content when an item is created or edited, so far so good. However, when an item is displayed in a list view, is the result of the calculation updated or not? I have ...
1
vote
1answer
1k views

SharePoint 2013 calculated column not refresh data in ListView

Scenario: I have a list of controller the assets the enterprise. In this list I have a column with the warranty date. A calculated column verifies if the date already expired. When I add or edit an ...
1
vote
1answer
87 views

Workflow Instance Blocking Calculated Field Update

Is it possible that an instance of a workflow can prevent a calculated field from being updated? My scenario: SharePoint 2013 Workflow 2010 Calculated field: (=IF([Dt Prox Contato]<Now(),"Old", ...
0
votes
1answer
48 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
318 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. ...
1
vote
1answer
295 views

Calculated Column - # of Unique Values Within Column

I have a time off calendar. What I would like for a column to do is count and update the number of unique values for that day. Here is an example: Day Off ||||| # of Values 12/1/13 ...
0
votes
3answers
710 views

How to show two dates in one calculated column

I'm using Sharepoint Foundation 2010. I have two columns, start date and ending date. I want to make calculated column which shows both of them in the same column. Everything is okay till I add both ...
0
votes
1answer
111 views

Add additional user information to SPList as list column

I have a List Tickets with a field Client. This is a user from our AD and displays the name of the user. We now need to display the country and the location the user resides in to additional fields. ...
1
vote
1answer
245 views

Have calculated column return boolean

I have a calculated column which I have set to check if another column is blank or not. I have a webservice which looks into this list and should return true or false if the column is empty or not. ...
2
votes
1answer
398 views

Calculated Column - Calculate Date based on other column value

I'm looking for a solution that I'm really struggling to find the answer to (I have searched, plenty!), or more specifically, find an answer that suits my needs. I've read plenty of help including ...
0
votes
2answers
405 views

Set current date i.e [Today] in a list column

I have a requirement where in user wants a column to be populated with Current date i.e Today. I went through many posts and found it is not possible to use Today() in list columns. The reason why ...
0
votes
1answer
288 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
316 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
72 views

Writing an expandable conditional column formula

ModuleNum&"."&SectionNum&"."&Sub1_SectionNum&"."&Sub2_SectionNum&"."&Sub3_SectionNum&"."&Sub4_SectionNum&"."&Sub5_SectionNum&"."&Sub6_SectionNum ...
0
votes
1answer
2k views

Why can't I get this calculated field to work?

I'm trying to create a calculated column (text) which contains a combination of 3 other columns. I've asked another similar question but that was a different subject - now I'm trying to do this in a ...
1
vote
0answers
79 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 ...
0
votes
1answer
595 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 ...