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

List item default value based on another item in the same list + value

How do I set the default value of a list item to be based on another item's value + value? For example: List A: duedate, reminderdate once the user enters a value in the list--> duedate = 1/1/2016 ...
0
votes
1answer
102 views

calculated column. How to get part of the text from another field?

I have a people column. I need to add a calculated column that can give me the domain. This formula =RIGHT([ReportTo],LEN([ReportTo])-FIND("\",[ReportTo])) gives me the name. But I need to get the ...
0
votes
2answers
513 views

List Group By Week not working properly

I have a list grouped by the following formula. =CONCATENATE(TEXT([Effective Date]+(5-WEEKDAY([Effective Date])),"mm/dd/yyyy")," - ",TEXT([Effective Date]+(11-WEEKDAY([Effective Date])),"mm/dd/yyyy")...
0
votes
2answers
50 views

Nesting a TEXT statement in an IF statement

I need a calculated column to return the mmm of a Date Field. Except, if the Date Field is empty, I would like the calculated column to also be blank. The original formula for the month is =TEXT([...
0
votes
2answers
423 views

Calculated columns giving me values to thirteen decimal places

I have some calculated columns in a SharePoint list and a using an InfoPath form to make it look a bit nicer. The total for each line is based on the uint price multiplied by the quantity. The sub ...
0
votes
3answers
129 views

Issue with calculated column

I have a calculated column CRM ID with simple formula =CONCATENATE("CRM")&ID. The formula concatenates ID field with string CRM. The issue is: Sometimes when user update list records, the CRM ID ...
0
votes
2answers
1k views

Using a calculated column from a lookup list

I am working with SharePoint 2013 at a hosted site (not Office 365). Most of the questions I see when I search relate to including a lookup field in a calculated column. That is not my issue (but it ...
0
votes
1answer
134 views

Change HTML page title to calculated column for custom list

I have a custom list called Customers which contains, columns First Name, Last Name and Full Name. Full Name is a calculated column which concatenates the first and last name values. Currently, when ...
0
votes
2answers
1k views

Set default date based on date other date column

I'm fairly new to SharePoint and I'm still learning the terminology so please excuse I have 2 Date Time columns in a SharePoint list, Date Received and Due Date. The Due Date is supposed to be 30 ...
0
votes
1answer
274 views

How do I have a workflow update a field/column in the current list(InfoPath created list)?

I have a column with this formula: =YEAR(Created)&"-"&(ID) , the YEAR(created) part works as intended but the ID part doesnt. It often shows only 2014- but it should show 2014-50, the 50 beign ...
0
votes
3answers
233 views

How can I sort this by an actual DATE?

I have a calculated field in a document library that takes the "Modified" property makes a more readable date from it. The problem is, the column is now sorting alphabetically, even though the data ...
0
votes
1answer
36 views

Validation Formula

I need help with a formula that will return true only when ( category <> "red" ) OR ( category = "red" AND EmployeeName - a people picker field - is not empty ) Thanks very much !
0
votes
2answers
125 views

Speedometer gauge using calculated columns?

My idea is implement a speedometer gauge at the top of my page that will change dynamically based on the average of a column, what i'm thinking is to use three speedometer images (low/med/high) and ...
0
votes
1answer
226 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
733 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
501 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
42 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 07/06/1905....
0
votes
1answer
184 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
924 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
571 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
250 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 /animals/...
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
168 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
1k 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
388 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
462 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
651 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
888 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
956 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 Earned"...
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
221 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
468 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
70 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
352 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 Date]=""),""...