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
0answers
4 views

Boolean field values differ between the InfoPath form and the SP view. Why?

I've got a 2010 SP list that tracks tickets about an application I own. It tracks various ticket attributes including'status' and 'type'. I want to create a view of 'open' tickets for my developers ...
3
votes
2answers
50 views

Calculate monthly occurance

I wanted to created a calculated SharePoint column which gives me a sum of the monthly occurrence. For example: During the month of July there were 7 occurrences so I wanted a calculated field to ...
1
vote
0answers
16 views

Map a calculated column to a managed property?

I'm trying to map a Calculated Column of the type Date and Time to a Managed Property of the type Date and Time and then use it in a display template. What i have done so far is: Created a ...
2
votes
2answers
71 views

Can't get calculated column syntax right

This "ought" to be easy and yet as with so many things SharePoint, it isn't. I have a calculated column where I keep getting a syntax error. If the user sets a dropdown column value to x, then y ...
0
votes
1answer
38 views

Update column using javascript

I'm somewhat new to SharePoint and I need help updating columns using javascript. I have a list that tracks expiration dates and shows traffic lights based on the days away from that expiration ...
0
votes
1answer
35 views

Display Sum of a calculated column

I have one calculated column and I want to display the sum of all its values but I know that's impossible in a OOTB way. How can I copy all the values to a new column (type number)? Do I need to use ...
1
vote
3answers
67 views

Images in calculated columns

I have a calculated column, formatted as number which is showing and image. Everything works fine on list views and in the web parts. But when I view a specific item, the calculated column only shows ...
6
votes
3answers
223 views

How to use Today and Me in Calculated column

I want to use a combination of Today and ME in SharePoint 2013. I am trying it in office 365 it gives me the below error Calculated columns cannot contain volatile functions like Today and Me. Can ...
0
votes
1answer
24 views

Calculated value field not the correct value in the main list view column [duplicate]

so I want to make a counter in my list that stars from a custom number. In the custom form I added a calculated value called CustomID and calculated the value for that field with: ID + 100 When I ...
0
votes
2answers
22 views

Using a Calculated Column to show Images

Ok, I've been working on this most of yesterday and today. I am able to render an image with the following formula - ="<div><img src='/xx/xx/PublishingImages/"&IF([Employees ...
2
votes
1answer
25 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
35 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
43 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
29 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
44 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
41 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
28 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
17 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
57 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
24 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
27 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
28 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
61 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
43 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
16 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
93 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
16 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
36 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
55 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
32 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
112 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
65 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
32 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
50 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
63 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
61 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
53 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
58 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
49 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
42 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
154 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
41 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
36 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
35 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
2answers
92 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
63 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
29 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
69 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
63 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 ...