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
votes
2answers
201 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
72 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
553 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
94 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
893 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
981 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"...
1
vote
1answer
479 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 ...
1
vote
2answers
185 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, 2,...
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
223 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
478 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 ...
2
votes
1answer
506 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 ...
2
votes
1answer
1k 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 ...
4
votes
1answer
2k 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 ...
1
vote
1answer
1k 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
1k 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
920 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
106 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
255 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
61 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
232 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
2k 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
71 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
195 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 MOC]="...
0
votes
1answer
4k 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
64 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 ...
1
vote
0answers
440 views

Calculated columns supporting all column types

I would like to develop a column which will allow the end user to do the calculations based on values of other columns of the same item (SharePoint 2010). I need it to work also with people, look up ...
2
votes
2answers
6k views

Sharepoint list If formula

I have a column that needs to return the value of another column based on if the value in a third column = S
1
vote
2answers
3k views

Issue with a Calculated column

I have in a list with multiple content types calculated column with this formula : =if( [ContentTypeId]="...
0
votes
1answer
199 views

How can I get a daily hour value from a date/time field?

I am trying to calculate the amount of time on a daily basis. Currently I have calculated "[total hours per diem]", "[total days]" and the time values (if not split over multiple days). Where I am ...
0
votes
2answers
8k views

Calculated date column to take into account working days

In my SharePoint list I have a default due date of =Today+10 How can I get this default date to be 10 working days from today? I'm not too worried about taking into account public holidays etc, ...
1
vote
1answer
2k views

sharepoint date column calculation

This is my first day using SharePoint and I was lost in trying to figure out how or if it can be done, custom column calculations, and if code is allowed in SharePoint? I am using SharePoint 2010. I ...
0
votes
1answer
1k views

Running Retention Policy from Custom Calculated Column

I have a calendar list in which to post deadlines. I need a reminder to be sent out two weeks before the deadline, so I am trying to put in a retention policy. To measure the date to activate this ...
1
vote
1answer
12k views

Calculated Column to Calculate Date

I need a column that contains the "Warning Date", which is two weeks prior to the expiry date. I am new to calculated columns so am not quite sure how to go about this. Any help is greatly appreciated....
0
votes
3answers
338 views

Modifying a calculated column gives different errors

I have site column with the following formula: [AmountLeftToPay]/([AmountAssigned]-[AmountReleased]) The problem is the division by zero, sometimes it shows on list items #DIV/0! So I wanted to do ...
1
vote
1answer
649 views

Sum of a column by month using a Calculated Column

Here is the background to my question. We are uploading field data about various moth species caught by trap. These traps are checked every month, but not always on the same day of the month.The ...
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 ...
3
votes
1answer
488 views

Calculated datetime column returns string;# in search index

We have a calculated column, that results in a date. It's output type is set to DateTime - Date only. When we run the search indexer, it shows up in "crawled properties" as a Text-column, and in the ...
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 ...
1
vote
1answer
585 views

SP2013 : Generate an autoincrement identifier (YYYYMMDD9999) based on creation date for a document

I need to generate a record id for a document, with format YYYYMMDD9999 where 9999 is a autoincrement number per day. This id must of course be unique, but i have no idea how to be sure to avoid ...
1
vote
1answer
861 views

Error with special characters in site column names referenced by a calculated column

I have a site column Construction - Complete Date which is used by my calculated column Construction - Is Complete?. Whenever a date is entered for the Construction - Complete Date then Construction -...
2
votes
2answers
1k views

Calculated column to Split text

I need to split column into two columns Column1: SHPS011SSAD Column2: SH Column3: PS What would be the calculated formula for this?
1
vote
1answer
2k views

Document Path as View Column

I have a library that contains documents and folder. I would like to have a view on this library that shows every document and includes the path to that document. For instance the following: Folder1 ...
1
vote
1answer
280 views

Calculation field randomly forgets ID

I have a calculation column that I use to display some HTML code that provides a hyperlink in a List view. The user clicks on the hyperlink to jump to another page which will generate a report based ...
1
vote
3answers
3k views

Calculated Column left align header

In my list, I want a column to have a custom hyperlink. I create a Calculated column that has the following formula. ="<a href='/_Layouts/tf.intranet/TFLutakastPage.aspx?LutakastId="&ID&"'...
2
votes
1answer
1k views

Adding nested IF statements

We have a company page to track mileage on company vehicles, and at the end of every month the driver enters the ending odometer reading. I wrote a formula to figure out the mileage for the year by ...
1
vote
2answers
886 views

Default Value for tomorrow at specific time

Say I'm currently using a Date/Time field for workflow purposes, the default value being Today+1. That gives the time at 12:00am tomorrow, which is great. Is there a way to always give the default ...
2
votes
2answers
4k views

How to match current user to a username column?

I have a list view that should only show when an admin adds the person's username to an "allowed viewers" username column. So, I am thinking to create a calculated column that compares the current-...
0
votes
1answer
835 views

Infopath: sum (non-bound) calculated values

Infopath & Sharepoint 2010, list Form: I have 2 calculated values placed on infoPath form. Those fields are not bound to existing list fields as I don't need store this data, just present to user....
1
vote
1answer
5k views

Infopath: Copy calculated value to list field

I'm using InfoPath and SP 2010. I'm using calculated fields which works well, but I wonder if there is a way to copy calculated field value to standard list field when form is submitted ?