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
2answers
61 views

Using HTML to recalculate calculated column

I wish to create an auto incremented "TaskId" list field. I had intended to create a new value that padded out the [Id], but obviously [Id] cannot be used as it is not available until after the item ...
0
votes
2answers
675 views

Calculated column with today's date based on other columns

I've been struggling with the calculated column in SharePoint. I would like to have a column in which the date is calculated from the values in two other columns. I have one column named "Status", a ...
1
vote
1answer
530 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 ...
0
votes
1answer
43 views

Updating Column Name using Calculated Columns

I want to update a Column Name using a Calculated Column. In my attempts below, I'm trying to rename the Column name from Col2change to NewName. None of the code snipperts work. I do not have access ...
0
votes
1answer
3k views

How can I use data from Managed Metadata Columns in Workflows and Calculated Fields?

It seems that sharepoint does not allow MM columns to be used in calculated fields, and I'm not sure how to use them in a workflow either. Can someone please inform me as to how I can use terms in the ...
0
votes
1answer
19 views

Calculated column problem from Multiple lines of text

I need to add calculated column (or something else) to my list which can discover and write, if is something in column of "multiple lines of text" within the bounds of this list. I can do it with ...
1
vote
1answer
463 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 ...
1
vote
3answers
21 views

SharePoint List Column Formula using YEAR and LOOKUP

I have created a column named Quarter (Type - Calculated) in my List that I want to calculated based on a Date column (ex. 01/26/15). My formula is as follows: ="FY"&YEAR([Date]+274)&" ...
1
vote
1answer
1k views

Unable to add a Choice field to a Calculated field (SharePoint Foundation 2013)

I'm not sure why I'm having this issue, as all material says that I should be able to do this... I have a required choice field that I would like to use in a calculated column. However, when I try to ...
0
votes
1answer
33 views

how do I add 90 days to a calculated column?

I have 3 columns, for simplicity we'll say column A, column B and Calc Column. In the Calc Column I need a formula for the following: If column A is blank, and column B is greater than 90 days from ...
0
votes
1answer
15 views

List item default value based on another item in the same list + value

How do I set the default value of a list item to be based on another item's value + value? For example: List A: duedate, reminderdate once the user enters a value in the list--> duedate = 1/1/2016 ...
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 ...
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 ...
0
votes
1answer
21 views

calculated column. How to get part of the text from another field?

I have a people column. I need to add a calculated column that can give me the domain. This formula =RIGHT([ReportTo],LEN([ReportTo])-FIND("\",[ReportTo])) gives me the name. But I need to get the ...
0
votes
1answer
713 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 ...
2
votes
5answers
13k 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
389 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
17 views

sorting by calculated date column in date format

I have a calculated column of date strings. The calculated field reads 5 other columns and is filled with a date STRING from the other fields. The calculated field has an type of date. The problem is ...
0
votes
1answer
1k views

replace text with formula in calculate

How can I replace ";" in a text like this with " AND " ? example text: "abc;cde;efg;ijk" the result should be like this: "abc AND cde AND efg AND ijk"
5
votes
6answers
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 ...
0
votes
1answer
809 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 ...
0
votes
2answers
27 views

InfoPath table calculated column: simplifying conditional statements

I have a table in SharePoint using InfoPath where I would like to have a Calculated column with a conditional formula based on the values of another column. I have a formula that works: ...
1
vote
0answers
28 views

Way to calculate a column based off of a another column after filter is set?

This is the example after I filtered on what I need to calculate. JPP: = 14681369 WC/Site Code:= 386746 Bill =$1,138 ANOTHER Invoice is JPP: = 15091824B WC/Site Code:= 386734 Bill ...
2
votes
1answer
707 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 ...
0
votes
0answers
16 views

List Group By Week not working properly

I have a list grouped by the following formula. =CONCATENATE(TEXT([Effective Date]+(5-WEEKDAY([Effective Date])),"mm/dd/yyyy")," - ",TEXT([Effective Date]+(11-WEEKDAY([Effective ...
0
votes
0answers
36 views

How do I use COMPUTED field types in SP2013?

I currently have a limitation with some 3rd party software being unable to display calculated fields. I started investigating whether I could display my calculated field value using a COMPUTED column ...
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 ...
0
votes
2answers
307 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
1answer
456 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 ...
0
votes
2answers
19 views

Nesting a TEXT statement in an IF statement

I need a calculated column to return the mmm of a Date Field. Except, if the Date Field is empty, I would like the calculated column to also be blank. The original formula for the month is ...
0
votes
1answer
26 views

Calculating the week within Fiscal year in calculated field

I have been asked to make a list that contains a calculated column containing the week number within a fiscal year starting on 6th April 2015 (Monday) So for example, 6th-12th April would be week 1, ...
1
vote
3answers
41 views

Calculated column that takes a date field and sets the value to the first day of that month

Is it possible to create a calculated column that takes a date field and sets the value to the first day of that month? I want to create a view that only shows the current month events. Basically, I ...
0
votes
2answers
323 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
29 views

Formula to Calculate: Start Date + Duration (Days) = End Date ; Business Days M-F

Basically, I'm trying to use SharePoint as some what of a project tool for tasks. On a new task, we have "START DATE", and a custom number field "ETC". I'd like to have a calculated field "END DATE" ...
3
votes
1answer
100 views

Duplicate filter values in a calculated column

I have a document library with a calculated column. This document library is populated from a windows service. Every time a new document is added, the calculated column has a formula to choose ...
0
votes
0answers
14 views

Problem with Excel View and Calculated Column

I have a problem both in Sharepoint 2010 and Sharepoint 2013 when I create a Excel View to list, and have got a Calculeted Column there after klick on calculeted Column I can edit Excel formulas and ...
0
votes
2answers
47 views

Get string out of url in calculated column

I have column in sharepoint 2010 list which has value like http://mysitecollection/sites/SPDev/Arizona/Lighthouse.jpg I want the value in calculated column should be Arizona. Can anyone let me know ...
0
votes
2answers
32 views

Display year in calculated column in SharePoint

I am creating a column in SharePoint list. This column is calculated. I am using below formula as of now: =""&"INC0000"AutoID This shows results like: INC00001, INC00002, etc. I want to change ...
0
votes
1answer
333 views

Calendar Overlay in sharepoint2013 programatically

I want to create calendar overlay in sharepoint2013 programatically using visual studio2012. Please help how to start with that. Happy Sharepoint!!! Regards, Aisha.
0
votes
2answers
42 views

Calculated columns giving me values to thirteen decimal places

I have some calculated columns in a SharePoint list and a using an InfoPath form to make it look a bit nicer. The total for each line is based on the uint price multiplied by the quantity. The sub ...
0
votes
0answers
22 views

Update Sum from Total from one list into line of new list

I am trying to find a way to group list items, take the total of a column and have that number updated in another list automatically. So here is the process. Invoice-- Amount-- Tax ...
0
votes
1answer
5k 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, ...
0
votes
3answers
44 views

Issue with calculated column

I have a calculated column CRM ID with simple formula =CONCATENATE("CRM")&ID. The formula concatenates ID field with string CRM. The issue is: Sometimes when user update list records, the CRM ID ...
0
votes
2answers
80 views

Using a calculated column from a lookup list

I am working with SharePoint 2013 at a hosted site (not Office 365). Most of the questions I see when I search relate to including a lookup field in a calculated column. That is not my issue (but it ...
1
vote
0answers
18 views

Sum and then divide columns

So I have a list in which a column needs to be summed up, then grouped so I can create another column that allows me to do division off of the summed total. So for instance John Doe 1 - 0 - 1 John ...
0
votes
2answers
106 views

lookup column in calculated column formula

I have a Lookup column(Discountfirst) which has Number. I also have another Calculated column(Finaldate) with Resulttype DateTime. One more column(DateofReceipt) in Date. My Calculated column formula ...
0
votes
1answer
92 views

Calculate Field with a Lookup Additional Column

Would like to ask some suggestion if i have 2 lists (Vendor List & Order List). Where Vendor List is contain with name & discount fields And i create new list "Order List" with field Items, ...
1
vote
2answers
56 views

Combining two column conditions in calculated column

I have a task list which has color coding for Progress Bar and Task Status based on % Complete and Status column values. I have one more additional condition for: IF status=Blocked then whatever the % ...
0
votes
0answers
50 views

Item has already been added. Key in dictionary: 'Date_Date' Key being added: 'Date_Date'

How do I resolved the error in SharePoint 2010: Item has already been added. Key in dictionary: 'Date_Date' Key being added: 'Date_Date' I get this when I try to add a calculated column in site ...
0
votes
3answers
60 views

2010: Calculated column multiple if statements

Currently, I have a formula to execute some number stripping for a column. When the user uses a card swipe, it outputs something like: ;502780133=0444? The formula strips the semicolon and removes ...