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

1
vote
0answers
72 views

; or , in calculated columns

The separator is related to the language settings. Rule of thumb: of the decimal separator is a . (dot) then the parameter separator is a , (comma) So most non-english languages have the , (comma) ...
0
votes
1answer
34 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 ...
2
votes
1answer
2k views

Use calculated column to add target“_blank” at the end of a Web field URL

It appears I cannot configure a hyperlink column to open in a new window. I read in this post that you can concatenate a hard coded url with the title field of an item to achieve this. However, that ...
1
vote
1answer
2k views

How to fix [today] and [now] in a list

I have the following issue: we use a SP list to send information through the steps of the process. On each step somebody adds information into the list, next person receives it, adds his own part of ...
0
votes
1answer
141 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
595 views

Skipping blank cells when using concatenate in a list's calculated column

I am using Concatenate in a calculated column to combine information from two columns in a list like this =CONCATENATE(A2, ", ",B2," feet"). Can you help me with a formula that would leave the field ...
0
votes
1answer
107 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 ...
3
votes
2answers
88 views

Calculated Column - IF true AND true

Using a task list I am trying to show a value if a cell is = to a certain string, AND task is complete. Im currently using this but returning a #VALUE error =AND([Task Name]="Task ...
0
votes
1answer
470 views

Changing a Column Choice value and updating the column value for any previously saved items

I have a list with a choice column which has muliple choices, so that the user can pick from a selection. Would like it so that the choice list is updatable (i.e can change the names) at a later ...
0
votes
1answer
110 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 ...
1
vote
4answers
229 views

How to filter calculated columns in the filtering menu

I would like to display my calculated columns fields in plain text in the filtering drop-down menu when I click on the column title. I don't know why SharePoint displays my calculated formula instead ...
0
votes
1answer
44 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
41 views

Calculated Date after 3 years

Can anyone please tell how to get the calculated date after 3 years from current date. I have tried different combinations none is working =TEXT(YEAR(Created)+3,"MM/DD/YYYY") It returns ...
0
votes
1answer
309 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
3answers
109 views

sharepoint list column calculation

In a new list item form,the user wants to have a column to display month & year(pre populated on opening the form) based on the below condition. "1. If the current date is > 15 ,then that column ...
0
votes
1answer
1k 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 ...
1
vote
1answer
33 views

Calculated column being changed on save

I need to keep the URL of a list item to use in a notification so I have a formula that looks like this: ="http://basicsample.com/next/List/EditItem?ID="&[ID] When I create an item in the list, ...
1
vote
2answers
1k views

Calculated column to retrieve total number of ID

I have a SharePoint list which all has a unique ID to identify the items, so I want to create a calculated column that counts how many ID are there, like a count! Any help is appreciated
4
votes
3answers
1k views

DateTime calculated Column using Formula

I have a column Birthday which contains the date of the user's birthday. I would like to create a calculated column to hold the user's next birthday. For instance, if I wanted to know the birthday in ...
0
votes
1answer
175 views

How to build a modal dialog link in a calculated column to use modal dialog

I have tried appending a hyperlink in a calculated column that should popup a modal dialog but it's not working for me. Anyone got this working?
1
vote
1answer
82 views

Resulting year of a start date and end date

I have a SharePoint list item with a "start date" and a "end date" (both are always on the same year interval). I would like to have a column with the resulting year of these two dates. How should I ...
1
vote
1answer
924 views

The element cannot contain child element because the parent element's content model is text only Error

I want to provision the field using feature. I have a field which is of type Calculated and the xml for the column is like below: <Field Type="Calculated" ...
0
votes
1answer
985 views

sharepoint calculated column to round a number

I want to calculate a field value such that if it is less then 0.5 it would be round up to 0.5 (ex. .3 would be .5, 1.3 would be 1.5, 2.1 would be 2.5) and if the value is greater then 1.5 ti would be ...
1
vote
1answer
438 views

Yes if Due Date is less than 14 days from created

I want to set the contents of a field named Rush_Flag to Yes if the field Customer_Due_Date is 14 or less days than when the record was created (Created). Created is the default timestamp SharePoint ...
0
votes
0answers
277 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
37 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
53 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 ...
1
vote
0answers
767 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 ...
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
51 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
62 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
3k 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 ...
1
vote
2answers
903 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
4k 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"
1
vote
2answers
132 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
140 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
109 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
723 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
41 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
34 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
441 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
2k 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 ...
1
vote
1answer
171 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
1k 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
51 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
58 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
899 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
558 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
481 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(),""),"") ...
1
vote
2answers
5k 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 ...