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
109 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
3k 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
452 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
1k 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
156 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
323 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
195 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
249 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
491 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
314 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
303 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
750 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
509 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
173 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
2answers
1k 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 ...
1
vote
1answer
638 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
228 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
2k 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
386 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
2k 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
252 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
518 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
61 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
61 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
856 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
1k 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
207 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 ...
3
votes
4answers
5k 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
7k 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
2k 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
3k 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 ...
2
votes
3answers
4k views

Calculated Column colour coded result

I have created a list on our new company sharepoint to track monthly sales orders, a kind of very basic sales pipeline if you will. In our list we have "Sales Price" and "Cost Price" columns and from ...
0
votes
1answer
65 views

How can I add a column tracking who last changed another column, so a modified column for a column

I need to track who mast modified specific columns, and would like to display this name in a column within the list. So within the list Column A would be Fix complete and Column B would be Fix ...
0
votes
2answers
2k 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 ...
4
votes
1answer
2k views

Calculated Hyperlink Column - Lost ID-Field Value Upon Editing

I created a calculated column with the following formula: ="<a href='../X_C03 Staff Members/DispForm.aspx?ID="&ID&"'>View</a>" and included this into a view. The column works ...
0
votes
3answers
3k views

Display Calculated Field as link

in a custom ListDefinition I used a calculated field to format a Text into an URL. I'm developping in VisualStudio2010 for SP2010. Here is my ListDefinition: <Fields> <Field ...
1
vote
2answers
2k views

How to apply CAML query on the Calculated Column of the list?

I have a calculated column that stores the calculated date value. When I apply the CAML query, it does not return any row even if the record exists. Can any one please guide me on this topic> ...
0
votes
1answer
2k views

Use value of Hyperlink column in a calculated column

I want to create a calculated column, it should show the value of Title and the URL of a Hyperlink column called Main Website. But I get an error for my formula: =[Title]&" ("&[Main ...
1
vote
0answers
338 views

CAML Contains on a lookup field of a calculated column

I have some issue when using the CAML Contains statement when the field is a lookup field on a calculated column. It basically does not work, the Equal works though. here is the query, nothing ...
0
votes
1answer
533 views

Assign a calculated column a value

Is it possible to assign a value to a calculated column in a workflow, even if the formula for the column has already been set?
4
votes
3answers
6k views

How to set the Default value of a Date/Time column to next Friday?

I did some poking around in the documentation for Calculated field formulas, but I don't see anything that would help me do this. Does anyone know if it can be done? Can you point me in the right ...
0
votes
1answer
94 views

set several list columns based on portions of document name seperated by an underscore

If I have a docuent library that has a documents in it using the following format: Region_Division_Store.pdf ...notice the underscores. I also have three columns named Region, Division, Store. ...
0
votes
1answer
2k views

How to use the countif function of excel in calculated column of list?

I have a calculated column in my list where I want to apply the countif function available in excel. How can I do tht? Please guide.. Thanx in advance..
1
vote
1answer
159 views

using calculated field in calculated field

I have field1, field2, field3, calcfield1, calcfield2, complexCalcField1 Calcfield1 and Calcfield2 use field1, field2 and field3 for its values. ComplexCalcField1 uses Calcfield1 and Calcfield2 for ...
1
vote
1answer
277 views

Calculated Fields and Outputting to Excel

So my issue is with Sharepoint 2007 and what is happening is that when I output to a excel spread sheet a custom view, If I export some calculated columns it also brings in the columns that were used ...
1
vote
1answer
292 views

Update field by code behind

I have an existing list with a text field and records in it. Now I want to change that text field into a calculated field to make it concat two other text fields in the list (possibly by changing the ...