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
15 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 ...
-1
votes
0answers
25 views

Calculated Field - Based on Drop-Down Field, Populate Multiple Lines of Text Field

We have a list that looks like this: **ID # File Name Confidential Redact** 001 XXX_SOC Confidential We need to have the redacted multiple lines of text field auto-populate ...
0
votes
0answers
26 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
13 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
1answer
16 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
43 views

Conditional Formatting using Calculated Column as Condition (SharePoint Designer 2010)

I want to use conditional formatting to change the color of a row based on a Calculated Column. I know I could do this with a CEWP but I would prefer to do it in SPD 2010 because I am new to ...
0
votes
1answer
42 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
38 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
22 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
41 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
37 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
47 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
41 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
10 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
17 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
41 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
41 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
10 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
53 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
42 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
33 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
25 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
49 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
42 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
42 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
0answers
21 views

Calculated Column display formatting html in display form and in excel [duplicate]

I am struggling a little with calculated column. i have put the following formula with html in Calculated column. =IF([Gross Impact]*[Gross probability]<=3,CONCATENATE("<DIV ...
0
votes
2answers
62 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
73 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
23 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
99 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
61 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
73 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 ...
3
votes
3answers
80 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 ...
0
votes
0answers
46 views

SharePoint 2013 Online - Calculated field/Metadata email issue

When parsing out a section of text to be sent in an email I keep receiving error;#256 in place of the text. The column in the list looks good, but it's when sending out the data in an email is when I ...
1
vote
1answer
104 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 ...
0
votes
0answers
45 views

Conditional formatting not updating on calculated field

I have a calculated field with the following formula: =WENN(Fälligkeitsdatum<=HEUTE();"RED";WENN(Fälligkeitsdatum<=HEUTE()+4;"ORANGE";"GREEN")) For understanding purposes: Fälligkeitsdatum = ...
1
vote
1answer
62 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 ...
0
votes
2answers
128 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
72 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
319 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
0answers
18 views

calculated column based on a view

I have a created a calendar with 5 views to make it seem there are 5 separate calendars to the users. ( I cannot use 5 separate calendars due to workflows ) When they book an appointment on the ...
0
votes
1answer
43 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
68 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
248 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
259 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
45 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
27 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
152 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
69 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
2answers
101 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 ...