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
217 views

Count Column in SharePoint List

I am trying to add a column that counts every time a date column is amended past the current date stored by more than 7 days. Column A would be a Project Live Date which isn't a fixed date column so ...
0
votes
1answer
662 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
489 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
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
181 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?
0
votes
1answer
1k 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 ...
0
votes
1answer
4k 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
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"
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 ...
0
votes
1answer
910 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
568 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
244 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
5k 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
166 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. ...
0
votes
2answers
1k 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
58 views

Need help with a formula

I need some help. I have created a pretty extensive list at work for my colleagues to use to track financials on some of our projects, I am using a formula one of the project managers had established ...
0
votes
2answers
1k views

Get Elapse time from Created and Modified Columns

I'd like to created a calculated column which subtracts the modified date/time from the creation date/time, is this possible? EDIT: This worked for me - =TEXT(B2-A2,"h:mm:ss") replace the cell ...
0
votes
2answers
996 views

Choose Username column in Content-Type

In my portal I have two lists. One (we'll call it the people-list) is a list of people's first and last names and their username (person column) if they have one. I have created a content type that ...
0
votes
4answers
1k views

Cascading Dropdown / Combo box in SharePoint List

I want to create a custom drop down combo box, which should show information based on selection of previous combo box. Just like we can do it in Excel. However, I do not want to do any coding in the ...
0
votes
1answer
386 views

How to give autonumber to item list but every day start from 1

How to give autonumber to item list but every day start from 1? I would like to achieve that every day counter(or with out counter) of item list will be reset and first item in day will give 1 and ...
0
votes
2answers
450 views

Calculated field - formula help

I am trying to improve my SharePOint skills, but really struggling with formulas and calculated values. First my questions is does it matter if the calculated field is reading dropdown, check box ...
0
votes
1answer
245 views

Programatically populate custom list column

I have a list definition project (schema.xml, etc.). I would like to create a computed column that's available for grouping, but not have the computed value from a CAML query, as it's going to be ...
0
votes
1answer
640 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
2answers
71 views

ID never ready for Calucated Column (SharePoint 2007 MOSS)

I have simple calcuated column that tries to multiplies ID * to some number. It worked once, but never again. It appears ID is not ready when the calculation runs? Is there a chance a workflow ...
0
votes
2answers
878 views

Filter List for DateTime using CAML against Calculated Field

In WSS 3.0, I have a list with a Calculated Field, 'MaxDate'. It gets the greater of two other dates, Notional Date and Override Date. I am trying (and failing) to build a CAML query to get all items ...
0
votes
2answers
934 views

How to add a calculated column to list view programmatically?

I have created a SharePoint feature where I have added a list named "Employees". I have added a Content Type "Employee" and added to it some columns like "Vacation Days Taken", "Vacation Days ...
0
votes
2answers
2k views

Sharepoint Document Library - Choice Column Default Value Calculation

I have a Shared Document Library with a choice column with 3 choices: Test1, Test2, Test3...now I also have 3 views, one for Test1, Test2, Test3, this is because I have three pages where I want to ...
0
votes
1answer
220 views

nested if condition in calculated field

If have a SP2010 List with all kind of productsnumbers in. Some are forbidden for some regions. I created my list as described below: Title = my productnumber ForBiddenRegion1 = YES/NO ...
0
votes
2answers
456 views

How to do A = A + B kind of operation in SharePoint Calculated column?

I have to create a calculated Column "A" for which the formula would be something like this =IF(SomeCondition = True,[A] + [B],[A]) However on trying this I am getting following error The ...
0
votes
1answer
104 views

Making a Request form that pulls from Calculated Columns of other list

I'm new here (first post). I have already read the great articles on this page but never posted until now. I am looking for some guidance on this and hope you experts can help me. Overview: I want ...
0
votes
1answer
60 views

Calculated Columns: Returning a value depending on parent curency column value

Morning all, Here's what I'd like to achieve and I'm hoping that you fine folk can help me with this. I have a currency column in a customised list, with values ranging from £1k - £20k. I'd like to ...
0
votes
1answer
69 views

Summing up the numbers based on a particular column value in a list

I have a list which displays the leave history of the users in a department. Now, I want to consolidate the data in this list in such a way that I want to calculate the total number of leaves availed ...
0
votes
1answer
1k views

How to use percent in calculated column over another calculated column

I want to create a calculated column which will calculate percentage over another calculated column. E.g.: I have three columns: ColA, ColB (=ColA-12%), ColC(=ColB-10%). The problem is, that ColC is ...
0
votes
1answer
1k views

Calculated Column Incorrect when All Day Event is selected

I've created a Calendar list. I've added a single calculated column ("Calculated Start Time") that simply references the "Start Time" column. It reports the correct date when the event is not an all ...
0
votes
1answer
69 views

How Create Decade Field Calculated

Hello I'm having trouble creating a calculated field I managed to create a field that takes the date of an event =YEAR([Event Date]) however I needed to create another calculated field, this needs ...
0
votes
1answer
350 views

How can I prevent a user from changing a formula in a calculated column?

I would like users to be unable to change formulas of some calculated columns, both from the list settings and from datasheet view. I am currently trying this via event receiver but I have went back ...
0
votes
2answers
3k views

Nested if statement in calculated list item

This should be easy but I have been beating my head against the wall on it. Here is my statement I'm using: =IF(AND([TODAY]>[Due In],[Comp Date]=""),"NO",IF(AND([TODAY]<[Due In],[Comp ...
0
votes
3answers
4k views

Display Calculated Field as link

in a custom ListDefinition I used a calculated field to format a Text into an URL. I'm developping in VisualStudio2010 for SP2010. Here is my ListDefinition: <Fields> <Field ...
0
votes
1answer
3k views

Use value of Hyperlink column in a calculated column

I want to create a calculated column, it should show the value of Title and the URL of a Hyperlink column called Main Website. But I get an error for my formula: =[Title]&" ("&[Main ...
0
votes
1answer
103 views

set several list columns based on portions of document name seperated by an underscore

If I have a docuent library that has a documents in it using the following format: Region_Division_Store.pdf ...notice the underscores. I also have three columns named Region, Division, Store. ...
0
votes
1answer
3k views

How to use the countif function of excel in calculated column of list?

I have a calculated column in my list where I want to apply the countif function available in excel. How can I do tht? Please guide.. Thanx in advance..
0
votes
1answer
817 views

Have an Association Column equal the field of another Column

I have created an association column as part of a reusable workflow in SharePoint designer. I am now trying to have this column equal the field of another column in Document Library. I have tried ...
0
votes
2answers
769 views

Trying to detect published documents

I have a site that has a document library and I made a calculated field for the content type called status that determines if a file is published or not. I used ...
0
votes
1answer
146 views

Sharepoint Column Totals to User - Value defined by status

So I have two list databases. User Points User Submissions These two databases work together. A user 'submits' for points in a status of 'submitted'/UserPoints[PendingPoints:Column] once 'approved' ...
0
votes
1answer
255 views

Calculated column to split the url Moss 2007

I have a link column eg: http://abcd/Shared%20Documents/test.doc. I need to create a calculated column to just get the name of the file..in this case "test.doc". Any help with the calculated column ...
0
votes
3answers
2k views

Calculated value column

In SharePoint foundation 2010 can i add a new calculated value column where the calculation are based on when another column is modified ?
0
votes
2answers
2k views

How to prevent #NAME? error in Calculated (Site)Columns

In SharePoint 2010 I've made a lot of Site Columns that I use in different content types. When I make a calculated column, that involves a calculation based on other columns, something goes wrong. ...
0
votes
1answer
400 views

Calculate Time Passed After Item Created Using Javascript (or other)

I have a list that tracks loaned equipment. I want a little icon that is a visual indication at how long the item has been on loan to help visually cue employees to follow-up. For example: 0-4 ...
0
votes
2answers
1k views

How do I set up a calculated column to reference itself?

I need to set up a column that will keep a running total of values. I have a program that automatically sets values for the columns in SharePoint. The program will overwrite the previous value ...
0
votes
1answer
10 views

Add Content to Search Index Based on Calculation of Properties in Record Center

I have a requirement to be able to search a record(document) in the record center based on a calculation. I can not store the calculated value as part of the item properties because an update of the ...