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

Displaying Column Count Only

Not sure if this is possible, but I want to be able to show the total count of column without the line items present. The way I was thinking to approach is to create a calculated column then show ...
1
vote
1answer
107 views

Sharepoint 2013 Auto-populating the SUBJECT of an email with a List Item (No SPD)

I have created a button to send an email from a List Web Part on a my Site Page. Using a Calculated Column, I am trying to populate the SUBJECT with the corresponding List Item, and the only thing ...
3
votes
2answers
137 views

Calculated field based on a field in another list

I would like to create a calculated field which requires a digit. This digit must be between a Max and Min value which are two ListItems in another list. How can I create a formula for this calucated ...
1
vote
0answers
58 views

Workflow Button JS in calculated column will not fire properly in Document Library

The code is below. My workflow name is 'myWorkflow' Question 1 Why doesn't this WF work? It is allowed to start manually and it is a single step: Set 'Read' to YES End Workflow ="<button style=""...
2
votes
2answers
39 views

Adding month to calculated value

I want to created a calculated column where I add 3 months to a date. This is what I have so far. =DATE(YEAR([Last updated]); MONTH([Last updated])+3; DAY([Last updated])); SharePoint produces and ...
1
vote
1answer
73 views

Create Lookup + Calculated column

I've an issue on calculating lookup value from other list.. I have List called "Product". in that I have column name "ProductCode"(Single line text) and "Unit Price"(number with 2 decimal). I've ...
0
votes
2answers
80 views

Sorting Calculated Numeric Columns Based on String Column

I am having a hard time getting a SharePoint 2013 list to sort in the correct order. We enter strings like this example 50-00-0. Then we want to split this into three columns so we may order them ...
0
votes
1answer
34 views

Filtered view of list based on Date compared to [Today]

I am trying to create a new view for my list that is filtered if the [Date] field is too far away. T do this, I am tring to create a calculated column, "DaysAway" with something like this: =[Date]...
2
votes
1answer
47 views

I am trying to use an if and concatenate nested statement

The formula reads: =IF(([Potentially Impacted]="N/A") ,CONCATENATE("Potential Business Impact is to:" ,[Potentially Impacted Units]" ," " ) ) ...
2
votes
0answers
96 views

How to use a lookup column's additional field in a workflow?

Background I have two lists. One is a list of voltages and their corresponding costs. This is to be used as a lookup for other lists. Voltage Cost 120 2.50 240 ...
0
votes
1answer
76 views

Error when adding calculated column to list through powershell

I have two almost identical calculated fields that I want to add to a list on several sites through Powershell . "Calculated risk" formula: =Konsekvens*Sandsynlighed "Revised calculated risk" ...
3
votes
1answer
249 views

How to have a calculate column that compares the difference between the current item and the previously submitted item?

I have a list with the columns Room Number, Temperature, and a column Temperature Change. What I would like, is for Temperature Change to be a calculated like so: When the user fills out a new ...
3
votes
0answers
52 views

Calculate Remaining Spent on a budget list

Goal: Trying to calculate remaining spent on a budget list where item expenses are grouped per object code. Every object code has a fixed amount of money against which the item expenses are deducted. ...
0
votes
1answer
140 views

Edit Calculated Column Formula with jQuery or javascript REST JSOM

Is it possible to insert save a formula into a column within a list in list view using jQuery or JavaScript?
0
votes
1answer
60 views

How to add a DateNow or current Datetime in a calculated column field in a list

Is it posible to add a DateNow variable in the formula box in a calculated column? How?
0
votes
2answers
103 views

Calculated column with multiple IF statements

I am trying to create a calculated column based on this: where, L6 is a yes/no column, C6 is a number column and the lookup basically calculates the percentage based on another column, let's say ...
0
votes
1answer
72 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
100 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
120 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
172 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
142 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
499 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
97 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
311 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
953 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
79 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
174 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
70 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
72 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
60 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
724 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 ...
13
votes
1answer
309 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
883 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
221 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
62 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
199 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
179 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
411 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
62 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
139 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 ...
16
votes
4answers
16k 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
123 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
74 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 ...