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

Calculated Field with formula DATEDIF

Im working with a calculated field and using a formula to retrieve the difference of the days between two dates, DATE1 and DATE2, my simple formula is: =DATEDIF([DATE1], [DATE2],"d") It works fine ...
0
votes
0answers
29 views

SP13: Showing Image in Custom List

The first part is working not the second. Intent: To have users select add attachment button on a custom list new form. Then select browse button that allows to browse out to select image on computer....
0
votes
0answers
31 views

'Disable-Output-Escaping' not working on calculated column

Ive created a calculated column that creates a dynamic URL and renders it as a button that opens the link as a URL. Everything displays fine as a list view, but when I open the dispform.aspx it still ...
0
votes
0answers
29 views

2010: Creating a color coded calculated column for multiple items

So I've previously created a traffic light-type "Priority Column" which displayed a red, green or amber circle next to my item, depending on it's priority ((1) High, (2) Normal, (3) Low) My code is ...
1
vote
3answers
77 views

Make dynamic calculated column Formula URL open as modal

Created a dynamic URL within a calculated column ="a href='/.../Test Doc Library/"&Title&"'>LINK</a> which works fine, but I need it to open as a modal and cannot get it to work. I'...
0
votes
1answer
34 views

Column validation accept a specific character and numbers only

So far I manage to make a validation that makes the column only accept numbers: =ISNUMBER([Column_Name]+0) But I want users to be able to type ";" inside as column value so only numbers and ...
1
vote
1answer
16 views

return blank if field is blank

I have the following calculated column that returns the "Max End Date" field using the following format YYYY/MM/DD. =YEAR([Max End Date])&"/"&MONTH([Max End Date])&"/"&DAY([Max End ...
1
vote
1answer
41 views

Calculated Column based on two others - Is there a limit on nested IF statements?

I'm trying to set up an automated column based on two others. Likelihood + Consequence = Calc Column 1 - Rare 1 - Minimal = 1 - Low 1 - Rare 5 - Severe = 10 - Medium 1 - Rare 2 - Minor = 3 - ...
1
vote
2answers
44 views

Calculating a fiscal quarter from a date

I'm using the following formula to find the fiscal quarter (where the year starts in April) from a date in a list: ="Q"&INT((MONTH([Date of inspection])-1)/3) HOWEVER -instead of displaying ...
0
votes
1answer
55 views

Highlight upcoming/overdue calculated column dates in a training list

I have a list to track customer training. Two of the trainig items are recurring; Ethics - annual and GPC Refresher - biannual (every two years). The due dates for each training requirement were ...
1
vote
0answers
23 views

Calculated column with custom ID

I have a list form which contains 3 fields: Company (choice field), NewID (lookup number field) and MyID (number field with min/max values 0000-9999). On NewID field lookup formula is set: =IF([...
1
vote
0answers
48 views

Calculated Column Requirements

KPI (Time) will be triggered from the 6 Milestone Expected Date fields (M1 Date Expected -> M6 Date Expected): If the date required of any of the milestone Expected Date field does is not greater ...
0
votes
0answers
23 views

SharePoint 2013 Knockout SPS Data-Bind for Calculated Columns

I have been looking everywhere and can't find any info on data-bind for calculated column. I have 2 calculated columns I'm trying to bind -- could someone help me with the "data format" for either of ...
0
votes
0answers
53 views

Negative DateDif Result

I'm trying to calculate the difference between 2 dates, (Starting Date) and Today. If the result is negative (IE: Starting Date is in the future) it means we still have that number of days before we ...
0
votes
0answers
42 views

SharePoint Tasks Outlook Categories Color Codes

I'm trying to get Tasks created in SharePoint to show in Outlook with a color category based on Priority. As of now, I can add existing site column Categories and manually type in "Red Category" and ...
0
votes
1answer
19 views

I want the Left 10 characters of the name column calculated in another column

A lot our names on SP are real long names; I would like to get say the left 10 (or any number of characters I put in the formula) characters of the name to calculate into a column. This would make ...
1
vote
0answers
23 views

How do I create the Calculated column that references three different static, hidden field value columns in 3 separate content types?

Danny: You wrote: Create a new SiteColumn in each of the 3 ContentTypes with a static (unique) Text value for each (eg. the ContentType name) Hide these SiteColumns in the 3 ContentTypes ...
1
vote
3answers
130 views

Count not updating in calculated column

I am getting number of days between Created & Now in SharePoint 2010 list using calculated column by below mentioned formula. =IF(ISERROR(DATEDIF(NOW(),Created,"d")),DATEDIF(Created,NOW(),"d")) ...
1
vote
1answer
25 views

Using more than 9 row colours in a SharePoint 2013 task list

On a task list, I want all 17 staff members of a team to have their own colour. I made a calculated column with this script found on the web, and it works fine for member 1 to 9. Unfortunately, member ...
0
votes
0answers
37 views

Running total of choice data from several lists

I'm using SP 2010. I have a few lists that have many of the same set of Choice columns. I want to be able to output a running total of how many there are of each choice from all lists. Maybe in a ...
0
votes
3answers
82 views

Calculated Field Returning Results Based On IF Statement

Here is the current IF statement string that I have; however the results are not providing what I want... In essence the formula is working but not entirely... For all statements true, I want the ...
2
votes
0answers
18 views

no items returned in a view with a filter on a calculated column

I'm having a strange issue and Google isn't helping me much in figuring out why. I have a custom list with 3 fields: Title Year calculated column =left([title], 4) single line of text Month ...
3
votes
1answer
45 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
40 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, "DD/MM/...
0
votes
1answer
16 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
44 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
61 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
46 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
61 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
46 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
30 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: 55555|...
0
votes
1answer
26 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 =IF(AND([Status]="...
0
votes
1answer
139 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
507 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
56 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
108 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
98 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
123 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
51 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
70 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
68 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
42 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
76 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
68 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
231 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
51 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
124 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?