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
7 views

How do I rename a calculated column using SharePoint 2010 list webservices

I'm having trouble figuring out how to rename a calculated column. The below code creates the 3 fields, and renames the first two but it won't rename the 3rd one. <UpdateList ...
0
votes
1answer
16 views

IP Address list sorting

I have a list that contains IP address and im unable to sort on them. I have a function that works in Excel ...
0
votes
1answer
20 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 ...
0
votes
1answer
47 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 ...
1
vote
3answers
23 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)&" ...
0
votes
1answer
34 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 ...
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
2answers
71 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 ...
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 ...
1
vote
0answers
30 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 ...
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: ...
0
votes
1answer
28 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
37 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
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
27 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
44 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 ...
2
votes
1answer
33 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" ...
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
33 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
2answers
43 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
25 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
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 ...
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
81 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 ...
0
votes
0answers
54 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 ...
1
vote
2answers
57 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
1answer
86 views

SharePoint 2010 - Calculated Column w/ Hyperlink & IF Statement

I am having some trouble getting this to work. I need to create a hyperlink in a column and learned that if you put some html into a calculated field and format it as a number then it works. For ...
0
votes
1answer
56 views

Change HTML page title to calculated column for custom list

I have a custom list called Customers which contains, columns First Name, Last Name and Full Name. Full Name is a calculated column which concatenates the first and last name values. Currently, when ...
0
votes
3answers
61 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 ...
0
votes
2answers
111 views

Sharepoint KPI using calculated columns

I am trying to create a KPI for the tasks schedule we have on a calendar. The formula I have is: "<div><img ...
0
votes
1answer
93 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, ...
0
votes
2answers
48 views

Calculate 90 Days

I am using Sharepoint 2010. I have a list, I will like to I.D. all files passed 90 days. What is the formula for this action?
0
votes
2answers
74 views

Single calculated Site Column for multiple content types

I have a list with three content types. I need to have a calculated status column in items for all three content types. The status calculation formula is different for all the content types. Since ...
0
votes
2answers
69 views

Calculated fields

I'm working on a SharePoint 2010 solution and I am trying to add a calculated column to an existing list. The column should display rendered html, but displays html encoded html. This problem occur ...
0
votes
1answer
37 views

Creating a KPI based upon multiple variables in a list

I have a list with the following dimensions that I am interested in developing a KPI for each user. For example, I have User1, User2,...User(n). Each of these users will have to develop certain ...
0
votes
1answer
47 views

Unique Validation on Calculated Column

I have 2 columns (first name and last name) in a SharePoint custom list. I have a calculated column called "full name" just concatenates the first and last name columns. Due to requirements, I need ...
0
votes
2answers
112 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
67 views

Calculated Field from another Sharepoint List

Relative newbie to Sharepoint Lists so please bear with me. I have 2 Lists that I need to work together to provide a bit of help to my Service Desk colleagues. List A (Tickets) FIELDS: Ticket ...
1
vote
1answer
38 views

Searching between two separate lists for matches

I have two SharePoint Lists each with a column called Unique Key, what I need to do is search list B for matches in List A. List B is the larger of the two and each List contains only unique entries ...
2
votes
1answer
19 views

Calculated column on SharePoint List

I use SharePoint 2013 FDN List for a basic IT Helpdesk - I'm looking to created a calculated column that can measure time it takes for a case to be closed. Date Created and Status = Not Started TO ...
0
votes
0answers
51 views

Copy calculated column to another column in same list

I have a list with the columns rID, requestID and some other columns. Here rID column is type number and it will set the value from workflow. requestID is type calculated column and starts with some ...
0
votes
0answers
56 views

Calculated Field with Multiple Columns

Thanks for providing this website as a resource. I am needing some help with coding a Calculated Field. I have 4 columns that all have an answer of Displayed or Not Displayed. In my calculated ...
0
votes
1answer
45 views

Whats wrong with this calculation?

Hi I tried add a column via calculation, and it seems to not be correct because I keep getting a syntax error.. Can anyone tell me why or where I went wrong? This is a dropdown box when a certain ...
1
vote
1answer
39 views

2010 - Changing #VALUE! error in Calculated Column

I have a calculated column called SUID # that pulls the value from a single line text input called SUID. The formula in SUID # is: ...
0
votes
0answers
19 views

SharePoint 2007 - column behaviour

There are few columns in task content type which are calculated, the hyperlinks to edit these columns are disabled, and hence cannot go to managecontenttype.aspx by clicking on the colmumn names in ...
2
votes
4answers
188 views

Calculated column that updates daily

Is there a way to make a column in a list that updates daily with the current date? If not what's the best way to do this? I was thinking of using the 'Lookup' field to link to the calendar that's on ...
0
votes
0answers
42 views

How to add a Sum, Avarage to Calculated Column

I must add an Avarage field to Calculated Column. How could I add an Avarage sum to Calculated column. When I tried to add by the View, the View doesn't see calculated Column.
0
votes
0answers
34 views

SP 2010 TEXT Function Subtracting 1 hour

I have a calculated column on a calendar that just formats the start time of an event. I am just using the TEXT function to format the time as hh:mm but for some reason the output of the function is ...