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

How to create a calculated field and use it in a list definition?

Here is my code: <?xml version="1.0" encoding="utf-8"?> <Elements xmlns="http://schemas.microsoft.com/sharepoint/"> <Field ID="{A57D77CA-9D80-458A-AB81-884C4F5A946D}" Name="...
0
votes
1answer
34 views

Calculated Column To Display Desired Result

I have a user with a Document Library called Submissions. Below is an excel example of what the user's library looks like with data: The Display Name column is a Calculated Column. The user wants/...
0
votes
1answer
38 views

How to create a “Status” based on field values?

OK, this one might be simple and I am just not thinking it out right, or it is complex and will require code, please help. I need a way in a custom list to set a Item Status Value based on if one of ...
0
votes
3answers
98 views

Hide calculated column in view but still have it run its code

I have a task list with a calculated column that includes some code to change the background color of the list items based on their priority value, see below Is there a way to hide the calculated ...
0
votes
1answer
103 views

Calculated column with ID removes ID number on update

I'm using SharePoint 2013 and I have a calculated column in a custom list, called "Project ID" that has the following calculation: ="DS-000"&ID The first item in the list has the "Project ID": ...
0
votes
1answer
147 views

Calculated Column: Weekday of Last Day of the Month

Using a calculated column to output the day number for the last day of the current month. The current formula is: =IF(LeapYear, WEEKDAY(CONCATENATE(MONTH(TODAY()),"/",CHOOSE(MONTH(TODAY()),31,29,31,...
4
votes
1answer
137 views

Calculated column increase date column by one day

I want to create acalculated column that takes a date field and sets the value to the date, increased by one day. How can this be done? For ex: If date field value: 20/10/2015 calculated result will ...
2
votes
1answer
436 views

Sum Calculated Column (SP 2013)

There is a very nice solution below from ViewMaster (http://www.viewmaster365.com/#/Create/Sum) that involves some scripting within the formula of a calculated column itself. However, the Sum will be ...
0
votes
1answer
92 views

Using [Today] in calculated field results in “Cannot complete this action. Please try again.” error

As you can probably guess from the title, I am trying to use the formula =[Today] in a calculated field. I then use this field to compare two date fields. These represent start and end dates. Lastly, ...
0
votes
0answers
30 views

Calculated Issue

I'm getting syntax error with this formula can any point out what I'm missing or needed to be added. The results I'm looking for should be 1510AK15210#### =TEXT([Start Date],"YYMM") &[State or ...
0
votes
1answer
265 views

Custom List Calendar View to display Multiple Columns' Data

I am trying to display a custom list in a calendar view. I want to display more then just the title or one of my columns data. I want to show data from a few of the columns, one being a Name. ...
0
votes
2answers
800 views

Hide Calculated Column in SharePoint 2013

I am trying to hide a simple calculated column from forms in a custom list. However, unlike WSS 3.0, I am not able to achieve this simple task. Any way I take to hide it, the option is disabled. ...
0
votes
1answer
78 views

Column current time in sharepoint list

I want to create list column that will show current time of an item. Not time when item was edited or created but current time and it should show time anytime (always).
2
votes
1answer
172 views

Show only number before decimal in calculated column without rounding the number

Application : SharePoint 2013 I need to show only part of number before decimal nn calculated field that is looking on number column. And Calculated column results should be shown without rounding ...
0
votes
2answers
33 views

Capture Content Type selected at creation

I am trying to create a column that capture which content type a user selects to create an item in a list at the time of creation. I would also like to prevent that new column from changing regardless ...
0
votes
1answer
36 views

Combine value of a task list into hyperlink

in sharepoint 2007 I want to combine the number - value (of a task in another system) in to an hyperlink like this: "http://172.xxx/Iso/index.php?actie=cs&pt=ontwerp&volgnummer=" and "value of ...
0
votes
0answers
22 views

Add x number of calculated days excluding week ends [duplicate]

I want to create a calculated day with say 21 days from today.But it should exclude weekends from numbers. I was using [Today]+21 as formula but it does not exclude weekends count. Does anyone know ...
0
votes
1answer
65 views

Calculated Column - with datefield

I have one date column and one calculated Column. If date column is blank i want to save null in calculated column and if it is provided then calculated column should save that date. I tried =IF(...
0
votes
2answers
67 views

Hyperlink for Workflow

I've made one calculated field and in there Hyperlink for workflow. =("<a href='https://Site/_layouts/15/start.aspx#/Workflows/JustDoIt/JustDoIt.aspx?List={b5cf27e0-a4f1-4e2a-82e8-1b598ef4af3b}&...
1
vote
2answers
59 views

Calculated column - using multiple AND and IF functions

I have been trying to figure this out and I cannot solve it. I am trying to create something which say IF column a = "High" AND Column b ="High" THEN "Red" should be inputted. So far I have... =IF( ...
1
vote
3answers
570 views

How to create a total (SUM) calculation in a view

I have a view that I want to find the sum of, which is the total miles... So if the user filters on july-15 then I wanted a sum to display anywhere on the view of the total miles, in bellows example ...
11
votes
0answers
286 views

Save Calculated Column Formula in Language Localized notation using REST or JSOM?

[multiple blogs/posts out there noted the issue, no solution was ever published] What is required to save a Localized Calculated Column Formula using JSOM/REST? I am injecting the script below into ...
3
votes
2answers
778 views

SharePoint 2013 Find/Replace Calculated Column

Was hoping someone could assist me with regards to SharePoint Calculated column. I have an address column which has an &. We need to find and replace the & with and. The problem is that the &...
0
votes
1answer
202 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
61 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 ...
2
votes
0answers
168 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
168 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
368 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 date....
0
votes
1answer
59 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
131 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 ...
12
votes
4answers
14k 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
45 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
83 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
68 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
146 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: C:\folder1\folder2\...
0
votes
1answer
49 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
50 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
53 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
131 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
85 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 track","/_layouts/images/KPIDefault-...
0
votes
0answers
24 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
155 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
44 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
30 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
54 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
53 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
135 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
136 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
32 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
199 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 ...