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

3
votes
1answer
33 views

calclulate a sum excluding NA results. SP10

I have 6 columns. Each column has a NA, 1 or 0 entered. I need column7 to calculate a score (preferably as a percentage), however NA should not be included in the count. EG 1, 1, 1, 0, NA, 1 ...
0
votes
0answers
18 views

date+time field just get the date part

I have a column start date which output the date and time 12/12/2016 07:42:00 I want to set up another column that just has the date but not sure how to do this. I have tried TEXT(Startdate, ...
0
votes
1answer
6 views

Calculated field - number starts from 1 for every month

I am at loss here, please help. I have a list and for every item in the list, I need its ID to look like this: 201502-1 201502-2 201502-3 201503-1 201504-1 Number at the end is the order of ...
0
votes
1answer
35 views

calculated column javascript css cewp

Embedding javascript into a Calculated column works well, such as in this case Using HTML to recalculate calculated column However, where the following code ="function setTaskID(TR){" &" var ...
0
votes
2answers
31 views

Calculated date column in using multiple IF-Statements

Currently I am creating a calculated column called Next Meeting Due This column is linked to 2 other columns: Meeting Frequency -> (which can be monthly, 6 monthly and annually) Last Meeting ...
0
votes
3answers
32 views

SharePoint 2010 Calculated Column, returns FALSE and cannot add last two lines

I have two columns in an excel spreadsheet. One is Entity and one is Country. I have created the Country column in SharePoint as a calculated column and pasted the list of entities into the Entity ...
1
vote
2answers
49 views

Sharepoint Online - Calculated Column & Conditional Formatting

I'm trying to create a tracking list to track the status of jobs using SharePoint Online. I want to use the categories: 'In Progress' = 7 days + from Due Date 'Requires Action' = Within 7 days from ...
2
votes
3answers
33 views

Including a script in a jslink file

I'm building a simple app on a SP2013 online intranet that uses the Google Books API to pull in GB content (title, author, image etc). The goal is to modify a SP list view to populate the book isbn ...
0
votes
0answers
29 views

Column to Identify Duplicates Across Multiple Columns

I am working on a sharepoint list with 3 user-entered columns Customer Code | Product Line | Part Number I want to identify rows with duplicate values for all 3 columns. For example: ...
0
votes
1answer
21 views

Query with validation settings on columns

We have two columns,Status(choice) and Date(Date and Time). Now I want to make the Date column mandatory when the Status = Approved. I'm currently using this calculated values ...
0
votes
1answer
32 views

SharePoint 2013 JS Automatically Generate and Send Email on New Item Form Save

Here is a screenshot containing the references below: BACKGROUND (the numbers correspond with the items in the screenshot) The 'Add New Item' button is pressed, which causes the 'New Item Form' ...
2
votes
1answer
62 views

“Cannot index into a null array” and “Invoke method on null” errors

I am new to SharePoint 2013 and am not a coder. I have a List, "IRM Summary", that contains Date Opened, Date Closed Days Open and Today columns. If there is a Date Closed date, then Days Open ...
5
votes
1answer
43 views

How to set calculate column result in another item

I made a list for Event Planning, the columns name are: Row(to change the order) Subject start time duration end time(sum of start and duration) I need to copy each end time to start time ...
2
votes
2answers
42 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
42 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
75 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
34 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 ...
2
votes
2answers
31 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
54 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
47 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
25 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: ...
2
votes
1answer
23 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
41 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
46 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
153 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
41 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
40 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
57 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
68 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
32 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}" ...
0
votes
1answer
30 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 ...
0
votes
1answer
33 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
83 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
46 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
44 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, ...
4
votes
1answer
110 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
147 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
62 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
113 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
208 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
73 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
167 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
29 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
34 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
52 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 ...
0
votes
2answers
38 views

Hyperlink for Workflow

I've made one calculated field and in there Hyperlink for workflow. =("<a ...
1
vote
2answers
54 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
244 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 ...