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
768 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
824 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
584 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
96 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
172 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
49 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
148 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
1k 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
56 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
178 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
2k 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
350 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
5k 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
2k views

Issue with a Calculated column

I have in a list with multiple content types calculated column with this formula : =if( ...
0
votes
1answer
145 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
1answer
4k 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
1k 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
680 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
4k 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 ...
0
votes
3answers
194 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
2answers
449 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
386 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
337 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
655 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
465 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
499 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
926 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
836 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
214 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
2k 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 ...
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
437 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 ...
1
vote
1answer
3k views

How to match current user to a username column with Calculated Columns?

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 ...
0
votes
1answer
553 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 ...
1
vote
1answer
3k 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 ?
2
votes
1answer
445 views

Calculated field to show the greater of two calculated values

I have some documents that need to be deleted based on the following criteria: one year after termination, or three years after hire date, whichever is greater. I have created two calculated columns ...
0
votes
1answer
738 views

How to create a Project Tasks List view for Overdue tasks?

How do I create a dedicated view to display only the Overdue tasks based on three columns. Start Date and End Date (Actual End Date) and Target Date (projected completion date) Target Date - Start ...
0
votes
1answer
62 views

Calculated coulmns in sharepoint 2007

I need to use text formulas, but I also want to include data in coulmn 'ID'. As this is default column for any list it is not available in default selection. So I have added it manually. Now old ...
0
votes
1answer
63 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
1k views

Can sharepoint calculate the number of “business hours” for a list item to be completed?

I work in financial institution and we want a column in a case management database to show the number of "Buinsess hours" from start to finish of a case. Business Hours Monday to Friday 5am - 8pm ...
1
vote
1answer
1k views

Insert html in formula field of a calculated column in sharepoint 2007 using javascript [duplicate]

Possible Duplicate: how to show HTML code in column? Is it possible to insert html/code in the formula field of a calculated column in sharepoint 2007 using javascript?
3
votes
2answers
2k views

SharePoint Calculated Field Limitations - Need Work Around

I have the following in a calculated field. I need to add many more IF statements but when I start adding more to the code I begin to get Syntax Error. I need a workaround to make this work. ...
0
votes
1answer
272 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 ...
1
vote
1answer
1k views

Conditional Sum of Data in Another List

I have two lists 'Projects' and 'Tasks' where 'Tasks' are associated with 'Projects' with a lookup column. On the Projects list I would like to display the sum of all of the 'Actual Time' values (a ...
4
votes
5answers
8k views

How to resolve full names from a Person or Group column (that contains multiple entries) in a designer workflow

I have a custom list with a custom content type, with a workflow, on SharePoint 2007 as outlined in this other StackExchange question. I'm using a Person or Group typed column to contain a list of ...
1
vote
2answers
11k views

How can we create and calculate a ([Due Date]- [Today])/7 column in SP 2010?

How can we calculate ([Due Date]- [Today])/7 column that updates daily as value of Today changes and lets us calculate weeks left for due date ? Could create ([Due Date]- Today() )/7 and it worked ...
1
vote
3answers
5k views

How to convert date field in single line of text using Calculated columns

I have created a calculated field for a content type in my Sharepoint 2010 and I want to return a date in the TEXT format because I am returning some text with it. The condition I have put in the ...
1
vote
1answer
5k views

Calculated column- evaluating multiple conditions

Banged my head against this one for too long so thought I'd give in and post it. I'm trying to create a calculated column that evaluates two different conditions, as in: IF [Boolean A] = No OR ...
2
votes
1answer
3k views

How to make SharePoint 2010 calendar view Time Sensitive!

I am trying to create Dataview Webpart for SharePoint Calendar Events to display [Today] items. I was sucessful on that, my next challenge is how to make it time sensitive. I want to display events ...