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

10
votes
0answers
264 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
0answers
48 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. ...
3
votes
0answers
403 views

CAML Contains on a lookup field of a calculated column

I have some issue when using the CAML Contains statement when the field is a lookup field on a calculated column. It basically does not work, the Equal works though. here is the query, nothing ...
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 ...
2
votes
0answers
68 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 ...
2
votes
0answers
146 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 ...
1
vote
0answers
27 views

Creating Scoring Matrix

I have a scoring matrix which I use in excel consisting of 5 categories each scored by Impact & Likelihood using a look up, then multiplied. The total from each category is summed to provide a ...
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: ...
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 ...
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
0answers
47 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 ...
1
vote
0answers
79 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 ...
1
vote
0answers
40 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 ...
1
vote
0answers
86 views

Sum and then divide columns

So I have a list in which a column needs to be summed up, then grouped so I can create another column that allows me to do division off of the summed total. So for instance John Doe 1 - 0 - 1 John ...
1
vote
0answers
111 views

Update SharePoint calculated column on Infopath form

I have an Infopath 2010 list form that displays a couple of calculated columns. My users have asked if I can make those fields update dynamically while the form is open. I have already tried moving ...
1
vote
0answers
43 views

Calculated Field formula for triggering the task 15 minutes before the starting time

I need to use a calculated field in order to trigger before 15mins of the task starting time. Please let me know what is the formula that I can use for this. Is it something like below? =[Start ...
1
vote
0answers
73 views

; or , in calculated columns

The separator is related to the language settings. Rule of thumb: of the decimal separator is a . (dot) then the parameter separator is a , (comma) So most non-english languages have the , (comma) ...
1
vote
0answers
806 views

Add month in calculated date column

I'm using SharePoint 2007. I've a column with date in format DD/MM/YYYY I've also another column where I want to add some months to the previous date and obviously I've a column with the number of ...
1
vote
0answers
456 views

Calculated field with library folder name

I have a library (e-amil enabled) with e-mail with attachments and I need to make a calulated field using the e-mail subject. The problem is that the calculated field shows only when I drill down the ...
1
vote
0answers
122 views

Calculated Fields and language packs

We are programmatically deploying a calculated field in a Sharepoint 2010 website using a site collection feature. Now we need to add localization support for a number of diff languages, so we had to ...
1
vote
0answers
540 views

Calendar Start and End Dates not correct

I am having trouble with out SharePoint calendar. I have some calculated columns set up to display start and end times for anything that is not an all day event (based off the guide here), but some ...
1
vote
0answers
139 views

Display number of events per day in SharePoint 2007 Calendar

I have a SharePoint list which contains project name, start date, and due date. I have created a SharePoint calendar based on this list that displays the contents of this list in a calendar format. ...
1
vote
0answers
430 views

Calculated columns supporting all column types

I would like to develop a column which will allow the end user to do the calculations based on values of other columns of the same item (SharePoint 2010). I need it to work also with people, look up ...
0
votes
0answers
16 views

Traffic Light Status in SP 2013 List

Is it possible to create a traffic light status in SP 2013 list without any custom coding?
0
votes
0answers
19 views

Comparing Calculated Date Columns

I have multiple calculated date columns and am using them to calculate some dollar amounts. These amounts are changing on every save, regardless of whether the day changes. Is this because the field ...
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 ...
0
votes
0answers
28 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 ...
0
votes
0answers
20 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
45 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
39 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
0answers
35 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
0answers
37 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
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: ...
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
0answers
23 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
0answers
51 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
0answers
31 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
0answers
43 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. ...
0
votes
0answers
51 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
0answers
161 views

Calculated Field with Multiple Columns

Thanks for providing this website as a resource. I am needing some help with coding a Calculated Field. I have 4 columns that all have an answer of Displayed or Not Displayed. In my calculated ...
0
votes
0answers
49 views

How to add a Sum, Avarage to Calculated Column

I must add an Avarage field to Calculated Column. How could I add an Avarage sum to Calculated column. When I tried to add by the View, the View doesn't see calculated Column.
0
votes
0answers
39 views

SP 2010 TEXT Function Subtracting 1 hour

I have a calculated column on a calendar that just formats the start time of an event. I am just using the TEXT function to format the time as hh:mm but for some reason the output of the function is ...
0
votes
0answers
30 views

Passing Parameter to Site Page or Webpart or Solution of some sort on SP10

I have a Windows Application in Java that i would love to connect to a Mind(Application of some sort) in SharePoint. I need to pass some number-parameters to it and it then has to give me also a ...
0
votes
0answers
118 views

Function to update date not working properly in list

I have a sharepoint list that calculates the expiration dates of items and does so by subtracting Todays date from the expiration date. In order for it to work properly, Today's date needs to update ...
0
votes
0answers
100 views

Creating a Calculated Date Field with embedded double quotes

I have been provisioning a load of Site Colummns with PowerShell . I am however, having a lot grief with a calculated field spField.Formula = "=TEXT(DATE([Created],"mmyyyy"))" spField.OutputType = ...
0
votes
0answers
841 views

how can we get the Current UserName instead of LoginName using calculated column in SharePoint 2013?

using [Me] as formula in column gives me current user login name. help me out if we can get the user name instead of login name.
0
votes
0answers
283 views

Content Type IDs help

I have 2 Content Types, A and B. I am trying to create Content Type ID's(not proper ID's) and completely separate from the ID already in the list. I am creating them as a calculated field but I cannot ...
0
votes
0answers
51 views

Calculated field from Sharepoint to Infopath

I created a list in sharepoint with some calculated field. When i modify the form through Infopath the calculated field doesn't contain the formula that i wrote in Sharepoint. For example: In ...
0
votes
0answers
99 views

Calculated Column returns excessive amount of zeros

In a Purchase Order form I'm putting together, I have line amount and total amount as calculated columns. However, when displayed in the InfoPath form, they show with a ridiculous amount of zeros at ...