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
71 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. ...
1
vote
1answer
121 views

Have calculated column return boolean

I have a calculated column which I have set to check if another column is blank or not. I have a webservice which looks into this list and should return true or false if the column is empty or not. ...
2
votes
1answer
157 views

Calculated Column - Calculate Date based on other column value

I'm looking for a solution that I'm really struggling to find the answer to (I have searched, plenty!), or more specifically, find an answer that suits my needs. I've read plenty of help including ...
0
votes
1answer
110 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
0answers
25 views

Script File and Calculated Column Format/Data Types

This may be a bit of a best practices question, but today I made a few changes to the site/lists I'm developing to facilitate development and data rendering. In CEWPs I've begun using .aspx files ...
0
votes
1answer
76 views

Padding a numeric string in a calculated column

I need to pad a numeric string using a SharePoint calculated column. I have two fields, Sectiontxt and calcPadNum. For example, if a user enters 1.12.1 into Sectiontxt, I want calcPadNum to be 011201. ...
0
votes
1answer
118 views

Calculated Column formula returns syntax error

Found this one that seems to be the solution needed but i cant get it to work: Column1 has the value of BD122 Formula: =EXACT([Column1], "BD122") Expected result: Compares contents of Column1 and ...
0
votes
2answers
62 views

Writing an expandable conditional column formula

ModuleNum&"."&SectionNum&"."&Sub1_SectionNum&"."&Sub2_SectionNum&"."&Sub3_SectionNum&"."&Sub4_SectionNum&"."&Sub5_SectionNum&"."&Sub6_SectionNum ...
0
votes
1answer
237 views

Why can't I get this calculated field to work?

I'm trying to create a calculated column (text) which contains a combination of 3 other columns. I've asked another similar question but that was a different subject - now I'm trying to do this in a ...
1
vote
0answers
51 views

Calculated Fields and language packs

We are programmatically deploying a calculated field in a Sharepoint 2010 website using a site collection feature. Now we need to add localization support for a number of diff languages, so we had to ...
0
votes
1answer
200 views

Selecting desired option with drop down menu using formula

I was creating a sample List which has Category section, under which we have three different options, namely Hindu Muslim Christian Now, i want to create another column which should help the ...
0
votes
1answer
43 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 ...
1
vote
0answers
169 views

Calendar Start and End Dates not correct

I am having trouble with out SharePoint calendar. I have some calculated columns set up to display start and end times for anything that is not an all day event (based off the guide here), but some ...
0
votes
0answers
107 views

Calculated column with formule in visual studio

I am creating calculated column through content type in visula studio.But the Formule is empty when i check in the calculated Column. Can any one help me .Below is the scenario which i have tried. ...
0
votes
0answers
40 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
52 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. ...
0
votes
2answers
442 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, ...
0
votes
0answers
80 views

Displaying Calculated Form in EditForm

I have a calculated form that concatenates 3 fields. These fields are editable in the new form but in the edit form I've used Javascript to set them as readonly. What I'm hoping to achieve is to ...
1
vote
4answers
431 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
179 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
186 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
2k 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
193 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
246 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
256 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
43 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
234 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
42 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
98 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
238 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
116 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
57 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
609 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
114 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
3k 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
133 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
0answers
75 views

Intermittent calculation failures in calculated date column WSS 3.0

Little late in the game to still be asking WSS 3 questions but I'm stuck with Project Web Access 2007 so that's what I have. I created a calculated column in a document library to give me the Week ...
0
votes
1answer
143 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
194 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
724 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
65 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
55 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
108 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
70 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
0answers
68 views

SharePoint 2010 Calculated Date: Monday of the current week

I want to have a date column in a list that will auto-populate to Monday of the current week. So, for example, say I was adding an entry to the list today, Tuesday, June 11 (6/11/2013). The date ...
0
votes
2answers
233 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
396 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
96 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
96 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
407 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 ...