Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [calculated-column]

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.

3
votes
0answers
110 views

Sharepoint 2013 Dynamic Calculated Column in List View

I need to calculate transaction totals (total price and tax etc) when entering data into SP2013. The following JS code works very well in the New and Edit views but when I try and implement in a SP ...
3
votes
0answers
204 views

Calculated site columns/Lookup site columns - cannot add calculated numeric fields

I have a list with broken down data that is aggregated to some kind of combined ID data format that references a certain file. (Say, there is a file called 123-1. I have a field then that stores "123" ...
3
votes
0answers
102 views

SharePoint Conditional Validation / Formula

In SharePoint Online can i perform the following? I have a column to calculate the date difference between Last Visit Date and Next Visit Date. Last Visit Date is already provided, and users will ...
3
votes
0answers
61 views

Calculated Column not showing appropriately on Mobile

I created a Calculated Column for a contact list which will create a URL to open the contacts Address in Google Maps. It works perfectly on a desktop browser and while requesting a desktop site while ...
3
votes
0answers
901 views

How can I create a traffic light status column

I want to create a traffic light status column in my task list. I have referenced the Path to SharePoint solution (and most of the others out there) but using a calculated column to display HTML and ...
3
votes
0answers
41 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
0answers
652 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
223 views

How to change date format correctly? (1899-Dec-30 error)

I would like to use date format for "Modified" field YYYY-MM-DD instead of the default MM-DD-YYYY. So I created a calculated field with the code: =TEXT(Modified,"yyyy-mmm-dd") But at about 70% of ...
2
votes
0answers
191 views

JS Link not working for Calculated Column with OpenPopUpPage command (SPO)

I am trying to make a JS Link for a calculated column that creates a button that invokes a modal pop form. The Calculated column has the Internal Name 'btnEditor', external name 'Update'. Questions ...
2
votes
0answers
34 views

Finding workings days for a month

I have a SharePoint list having field as WorkingDays like workday1, 2, 3 etc. For each and every column I have different reports. I need to create a calculated column for all working days for a ...
1
vote
0answers
46 views

SharePoint 2010 - Calculated column - IF statement with (OR) not working

I have the following entered as formula in a Calculated column (returns single line of text)... I'm going to add to the formula, but it's stuck on this point; takes me to error page: =IF( OR( LEFT([...
1
vote
0answers
50 views

Sharepooint Color Progress Bar Calculated column not working in Sharepoint 2013

I copied a formula for color coded progress bar from Path to sharepoint site And everything seems simple, however I think this code was written for sharepoint 2013 and I am getting error for ...
1
vote
0answers
28 views

Need to count entries

I am looking to make it so that each item in a list has a column that shows how many total items there are in that list that share the same value in a column as that list item. If that makes sense. To ...
1
vote
0answers
58 views

Me Filter on Multiple Selection Lookup Column

I have found plenty of information about filtering lookup columns (title: Employee)during searches but I haven't located something that said using [Me] filter. I created a lookup column that has ...
1
vote
0answers
17 views

SharePoint online Column Empty Item Count

I have a rather large list and I need to count items in a couple of the columns. For example: column1 is [open date] column2 is [closed date]. Both of these are date columns. Column1 has all the ...
1
vote
0answers
98 views

force infopath field to update

How can you force a number field to be updated? Once the entry has been changed from i.e 365 to 700 the number doesn't refresh. An example I have 2 lines of information. you can only select one by ...
1
vote
0answers
25 views

Multiple Content Types Duplicating Values in Calculated Column when updating CT

List Setup I have a list setup with 3 content types. Content Type A, Content Type B, Content Type C The list has 3 choice columns setup for each content type. This enables the choices available to ...
1
vote
0answers
72 views

Calculated column based on specific elements from another site column

I have this site column in a Sharepoint 2013 list showing a few deadlines. I need to create a calculated column next to the one in the picture, that gives as a result the number of days between one ...
1
vote
0answers
121 views

Calculated value not showing in custom Display form

So I have a calculated column that is adding up data from 6 other columns in my list. The calculation adds up just fine. However I need to create a custom Display form. When I create the custom ...
1
vote
0answers
108 views

Calendar Current Event ID to string SP2010

The ID of a current event in a calendar is displayed in the format of "ID#.#.yyyy-mm-ddThh:mm:ss" This format is only displayed as the ID in the current events view. I need to pull this value into ...
1
vote
0answers
43 views

Adding/updating column tags after populating a new document with bookmark values

Im currently running a project for a customer with the goal to automate a SharePoint environment along with word templates. So far i managed to create a word template which includes a Userform where ...
1
vote
0answers
14 views

How to filter the items particualr month?

I need to create a view and it displays only June month records.How to filter the records? Help me on this. Thanks in advance
1
vote
0answers
126 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
64 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
60 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
64 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
119 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=""...
1
vote
0answers
210 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-...
1
vote
0answers
44 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 =$21,874 ...
1
vote
0answers
216 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
957 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 field,...
1
vote
0answers
238 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
55 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 Time]...
1
vote
0answers
107 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
984 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
186 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
220 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
506 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
9 views

EXCEL import: share point calculated field source columns are blank while others can see data in them

I understand that exporting a share point List view with calculated column will pull the source columns for that calculated column to excel even if they are not in the view. my issue is there is no ...
0
votes
0answers
15 views

Calculate Business Days

I've been using a calculated column with some IF statements to calculate the number of business days between 2 dates. =IF(ISERROR(DATEDIF(Created,Today(),"d")),"",(DATEDIF(Created,Today(),"d"))+1-INT(...
0
votes
0answers
12 views

Adding a sum column which uses data from lookup

I have a list with employee names and a lookup column from another list, which has the training names and training duration. The training duration is added as an "additional field" from the lookup ...
0
votes
0answers
6 views

Calculate “Days Since” a specified date

Good Afternoon I am using Sharepoint 2013 OP with SPD 2013. I want to create an element on my SP site which calculates how many days have elapsed since our last accident. For Health and Safety ...
0
votes
0answers
32 views

SharePoint Online : Help to Update Calculated Column in a List on a daily basis

I have a list in SharePoint Online environment where I need to calculate DaysLeft using 'Expiry Date' Field - Today() in a calculated column. The calculated field is not updating on a daily basis. ...
0
votes
0answers
29 views

Workflow and columns set up for calculation

In a list that we use as ticketing tool, I have a field where I have to input my working hours every time. I'm looking for a way in which I can just input a number in that field but also have another ...
0
votes
0answers
34 views

Multiple choice lookup field does not render on edit form

I have, for the last few years, used a field called "Enabled" and a calculated field which returns the value of the Title field if Enabled is true. If Enabled is false, it returns an empty string ("")....
0
votes
0answers
163 views

Column validation - can the column name contain special characters?

I have a column called Machine #. It is a Single line of text. I would like it to be in this format: Mxxxxx - all the 'x digits' are numerical. The first item should be called M00001. I would like ...
0
votes
0answers
32 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
60 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
175 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
84 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 ...