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

2
votes
1answer
17 views

Will a calculated column formula interpret number strings as numbers?

This is my first time using calculated columns. I have a calculated column that is a number field, that is calculating it's value based on two other columns that are choice columns. I know that ...
0
votes
1answer
24 views

Calculated Column to extract text within file path

Due to SP limitations in workflows for extracting text strings, I'm looking for another way to skin the cat. If I have a single-line text column that has a file path like: ...
0
votes
1answer
40 views

Calculation for output that displays $1 per $1000 of amount from another column

I have a list that is a Sales Log. I have been tasked with creating a column that will look at a dollar amount and will give me a dollar amount based on that. Specifically, $1 per $1000. I am ...
0
votes
1answer
24 views

Issues with Color-Coded Calculated Columns

I have a list with a series of columns that all return percentages. I have done the stop light chart with status columns but not percentages. I have gone to 'Path to SharePoint' - the site everyone ...
0
votes
2answers
43 views

conditional subtraction between 4 fields

I need to create a calculation that basically is a subtraction between two fields (2 date fields). However it should be done only if a 3rd field is equal to a value of 5 or 6 AND a fourth field less ...
1
vote
1answer
39 views

Conditional subtraction

I need to create a calculation that basically is a subtraction between two fields (2 date fields). However it should be done only if a 3rd field is equal to a value of 5 or 6. My first field is ...
1
vote
0answers
24 views

Cannot create site from template due to missing column

I have created a site template that contains a list with a calculated column. Here is the column formula: ="<DIV><img src='"&IF([Project Status]="On ...
0
votes
0answers
13 views

SharePoint LIst Calculation Date(s)

I am trying to create a column calculation that will return 2 different dates based on the Date / Time the Request was Received/Submitted during 5 day work week. Example: If submitted the day ...
0
votes
2answers
49 views

How to remove Domain Name from [ME] Calculated field and show Display Name of User

I use [ME] in a calculated field it returns a username of \username. Customer wants to see the user name as display name not as login name. Would like to know whether a SharePoint formula I can use to ...
0
votes
1answer
19 views

How to add a column which has auto increment value based on update of other column in a list

I have a list where in we are capturing Completion Month date. It can be updated by users if required. I need to have a record of number of times this value is updated for each individual row starting ...
1
vote
1answer
27 views

Is there to have a parameter for an entire list?

Is it possible to have an attribute, like start date, where other columns would use it to calculate their value? For example the due date column would take the start date and then add the amount of ...
0
votes
0answers
21 views

pop up info tab for custom list in sharepoint 2013

I am looking for a pop-up something like in the picture. (column info) Is it possible to use calculated column or Client Side Rendering for this kind of requirement. Anyone who have any idea ...
0
votes
2answers
25 views

Calculated column - All records from [today] and [today]+5 when comparing to Due Date

I am trying to create a view where Invoice Admin wants to see all the records where invoice due dates are within next 5 days. I added a calculated column and i have =[DueDate]-5 but this formula only ...
0
votes
1answer
51 views

Insert a break point in a column

Okay so I have a sharepoint list, and in this list is a Choice column where you can suggest multiple choices. I am exporting those choices to a calculated column. I want there to be a line break ...
0
votes
1answer
37 views

Extract part character from a string using calculated column [duplicate]

I have the following string: XXXX.C.2.0.1 how do I extract just the "C"? thanks
0
votes
0answers
14 views

Calculated column used in reporting services shows #Error

I am using the following formula in a calculated column to extract the month from the "ResolvedDate" column. =""&MONTH(ResolvedDate) It works well, but now I intend to use it in reporting ...
0
votes
1answer
82 views

How do I sum a column in SharePoint 2013?

I have a requirement that I need to sum a column in my SharePoint page then send a email if its one or bigger. I have got the email part down and its working, the problem is everything that I can ...
0
votes
0answers
11 views

How do I add Date and Time together for a Calendar view, maybe in workflow

We need the user to be able to select a Time slot when creating a new item, from between a cycle of 6 hours, so 12pm - 6pm, 6pm - 12am, 12am - 6am, and 6am - 12pm. They would also pick a Date. ...
1
vote
1answer
27 views

Parsing multiple strings (numbers) from a single line of text column and adding them together

I have a user who has requested a way to track vendors and their price quotes for project work. The user would like to have the list automatically calculate the total of all quotes listed. There can ...
0
votes
2answers
50 views

How to create calculated field column for sorting the numbers

I have three columns value1 value2 value3 (100 100 80) (100 100 100) (70 40 50) I want to sort this by concatenating all these and padding left 0 and then sort it. Can any ...
0
votes
0answers
30 views

calculated column get_item returning 0

Using a calculated column, I am trying to print the value of a column for the current selected row into the console LOG, but all it ever displays is 0. Can anyone see what the error might be? The ...
0
votes
1answer
81 views

Can anyone color code a column with an if statement?

Here is what I am trying to do. I have a SharePoint 2010 list that I want to color code dates based on that it expires 364 days after the date entered. Example: If the date is older then 334 ...
0
votes
1answer
46 views

Calculating Fiscal Year in YY format

I found this post and it worked for a 4-digit year but I am trying to use a 2-digit year Calculating Fiscal Year This will give you the format 2013-2014, 2014-2015: ...
0
votes
1answer
23 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
2answers
45 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
42 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
60 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
41 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
54 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
34 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
37 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
130 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
33 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
35 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
30 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
64 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
57 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
26 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
49 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
54 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
63 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
16 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
55 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
36 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
55 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
55 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
52 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
28 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
115 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
96 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 ...