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
0answers
47 views

Calculated Column returns excessive amount of zeros

In a Purchase Order form I'm putting together, I have line amount and total amount as calculated columns. However, when displayed in the InfoPath form, they show with a ridiculous amount of zeros at ...
1
vote
0answers
62 views

Display number of events per day in SharePoint 2007 Calendar

I have a SharePoint list which contains project name, start date, and due date. I have created a SharePoint calendar based on this list that displays the contents of this list in a calendar format. ...
1
vote
2answers
987 views

Autoincrement a field based on ID

So I'm trying to autoincrement a field on a list item. First i tried using a calculated value field "=[ID]" which works the first time, but after saving a new item to the list the "[]" are gone and, ...
1
vote
4answers
657 views

Duplicate Groups Showing when grouping a calculated column

I have recently upgraded our 2007 envrioment to 2013 and afterwards a few of our libraries are having trouble grouping on a calculated column. The year column is calculated using the following formula ...
0
votes
2answers
388 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
3answers
396 views

Automatically add value to column of new list item?

How can I automatically add a value to a column when making a new list item? Like, if I make a new item in a list named "Announcements", and I want the "Expires" column to automatically get a date 3 ...
0
votes
4answers
4k views

get the month from a date column with the calculated column

I am trying to get the month from a date field with the help of calculated column. However I get this syntax error whenever I want to submit the formula: Error The formula contains a syntax error or ...
1
vote
1answer
413 views

MAX Formula for Calculated Field

The Question How can I create a Calculated column with a formula that works the same way as an Excel MAX formula? Why I have a need to create unique ID's for process documents, but can't rely on the ...
1
vote
3answers
306 views

Auto-populate Sharepoint list based on most recent list item in another

Can anyone help? I want to be able to auto populate a field within a SharPoint list based on the most up-to-date field within another list. . List Details Projects List - List of projects. Fields ...
0
votes
2answers
523 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
1answer
48 views

Update Calculated date if not already entered

I have a field Closed_Date which is automatically calculated as =IF([Issue Status]="Closed",Modified, "") But this gets updated everytime I edit the entry and save. How do I update the field only ...
0
votes
2answers
403 views

Calculating the Number of times “Yes” appears in a column

I am using SPD 2007, Sharepoint 2007. I have a list that has a column of Yes/No choices. I need to calculate the number of times "Yes" is chosen. Is there a way that this can be done with ...
0
votes
1answer
44 views

Sharing a calculated value between lists

I have to create two separate lists. One list is an overall master table of data, the other is a list that shows the total for selections on the master. What I need to do is to calculate out the ...
1
vote
1answer
114 views

how to change the format of the “person or group” column

In my document set (Sharepoint 2010) I have a column with type of “person or group” which I can add the name of some users to it. The format of the names is like this: firsName1 Surname1; firstNmae2 ...
0
votes
4answers
357 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
2answers
135 views

Custom/autogenerated item name in Forms Library

I am trying to plan the auto-generated custom item name for Form library in a 2013 publishing website project. In other words, I don't want our users to enter the name of the form every time they ...
0
votes
0answers
63 views

Return Surname from full name with multiple middle names

I have been tasked with extracting the Last Name from a Full Name field in sharepoint 2010. Currently I can get the Last Name for names such as John Jiles, or John Stuart Jiles, but I have not been ...
0
votes
1answer
903 views

Validation formula that TEXT should not to have SPACE

Is there any validation formula which don't allow to save some value in column with SPACE in SharePoint 2010? I know that is Calculate column formula with TRIM formula but I need to validation formula ...
0
votes
1answer
161 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 ...
3
votes
3answers
5k views

Auto populate values in a sharepoint list based on another list

I have two Lists in Sharepoint 2010. They are PO master and Invoice Master. The columns in PO Master are PO number PO value Invoiced Amount Balance. The columns in Invoice Master are PO ...
0
votes
2answers
182 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
161 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
315 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 ...
1
vote
3answers
1k views

Dynamically hide column list item if the field is empty

I have a series of fields that I would like NOT to appear in my list dispForm.aspx. So when a user creates a new list item if these fields are unpopulated the do not appear DispForm.aspx but I still ...
-1
votes
2answers
88 views

Add calculated column data with decimals

Is there any way to sum all values in one calculated column without losing decimal data? We're using an XPath expression and it loses all decimal information. Where @myField is one calculated column ...
0
votes
2answers
59 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
1answer
130 views

Help with Conditional Statement (Calculated Column)

I have created a sharepoint workbook with contract information. Three columns in this sharepoint have dates. ([Planned Release Date] , [Revised Release Date] , and [Current Release Date]). I have ...
0
votes
2answers
87 views

Calculated Column name of company

I've a little problem. We've a document library and in this library every subcompany can upload their documents. Now I want a column where the name of the subcompany is displayed after the document ...
0
votes
2answers
310 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
468 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 ...
1
vote
1answer
121 views

Sharepoint Percentage Working Out

Scenario: We quality score work in our business to ensure this is updated correctly and we give each 'engineer' a mark out of 5 each week. Currently we are able to work out the percentage each week ...
0
votes
2answers
111 views

Calculated Column Formula

I have 2 Drop Downs Month Date In Month Column dropdown I am displaying Jan, Feb, March, April, May, June, July, August, Sep, Oct, Nov, Dec In Date Column dropdown I am Displaying 1, ...
0
votes
2answers
522 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
116 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
196 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 formula ...
2
votes
1answer
275 views

Color coded background on calculated column using Designer

I am aware of the various methods to colorcode columns (jquery, formula) I choose here to use designer on allitems.aspx on a list (im lazy and its easy). I have given various columns background ...
1
vote
1answer
331 views

Calculated column is not being crawled

I have a calculated site column AlertSortOrder, which I added to a list. I created a managed property nvAlertSortOrder (sortable, searchable, queryable, retrievable) mapped to the corresponding ...
3
votes
1answer
369 views

Calculated Value of “Start Time” in a calendar is not working

I am having a problem with a content type-specific, Reusable workflow. I use it for a calendar. When ever an event is created, I send an email to the approver with Name of the event, start time and ...
0
votes
1answer
353 views

SharePoint 2007: Calculated column - formula for calculation based on column containing NA

In a SharePoint list, I have 6 numeric columns that can contain numbers in the range (1,4). However, one or all of these columns may contain "NA" value. There is a separate calculated column which ...
3
votes
1answer
548 views

CAML Query on a Lookup Field that points to a Calculated Field throws Exception

I wrote some CAML Queries to get data from a List that has lookups on another List. All is working fine as long as I do not reference a Lookup Field which points to a Calculated Field. I tried ...
1
vote
3answers
341 views

Calculate the difference between system columns Created on and Modified on

I'm trying to create a new column in a shp list that contains the difference in days between two other columns in that list. These two columns are the custom list columns that contain the date Created ...
0
votes
1answer
82 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 ...
2
votes
1answer
124 views

Is there a way to determine if there is an attachment in a calculated column?

I'd like to have a column display "Yes" if there is an attachment to the sharepoint list item, or "No" if there isn't one. Default would be no, but then if they edit the item to add an attachment, I ...
0
votes
1answer
38 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
98 views

Calculated columns, columns names and localization

I provision a list in SharePoint 2010 with two date fields: one for a start date and one for an end date. I would like to add a third column for the duration. Naturally, I could add a calculated ...
2
votes
2answers
791 views

Calculated value for Single line of Text doesn't work

I have a column named "Risk" and the condition of the values is here: Düşük: Risk <= 4 Orta: 4 < Risk <8 Yuksek: 8 <= Risk Risk value is the sum of 2 column values. ...
0
votes
1answer
48 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 ...
2
votes
3answers
162 views

How do I apply a calculated column to new items only?

I have a formula in a column that calculates the target date of + 3 months. I want to change the formula to +9 months but only for new items. How do I add this to the formula? =IF([Type of ...
0
votes
1answer
1k views

Designer Workflow: “Find Interval Between Dates” action not working

I am testing a default SP Designer 2010 workflow action called "Find Interval Between Dates" located under the "Utility Actions" category. I need to compare the amount of time passed between the ...
1
vote
1answer
61 views

Getting Null Value with two statements in additional column settings

I am trying to subtract column "Previous Spend" from column "Current Spend" and put the balance in new calculated column named "Incremental Spend". Easy enough right. But if "Previous Spend" is left ...