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

lookup column in calculated column formula

I have a Lookup column(Discountfirst) which has Number. I also have another Calculated column(Finaldate) with Resulttype DateTime. One more column(DateofReceipt) in Date. My Calculated column formula ...
0
votes
0answers
7 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
1answer
24 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 ...
0
votes
1answer
2k views

Can sharepoint calculate the number of “business hours” for a list item to be completed?

I work in financial institution and we want a column in a case management database to show the number of "Buinsess hours" from start to finish of a case. Business Hours Monday to Friday 5am - 8pm ...
1
vote
1answer
583 views

Sum of a column by month using a Calculated Column

Here is the background to my question. We are uploading field data about various moth species caught by trap. These traps are checked every month, but not always on the same day of the month.The ...
2
votes
0answers
13 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 ...
0
votes
2answers
575 views

Calendar Overlay in sharepoint2013 programatically

I want to create calendar overlay in sharepoint2013 programatically using visual studio2012. Please help how to start with that. Happy Sharepoint!!! Regards, Aisha.
0
votes
1answer
1k views

Selecting desired option with drop down menu using formula

I was creating a sample List which has Category section, under which we have three different options, namely Hindu Muslim Christian Now, I want to create another column which should help the ...
0
votes
1answer
38 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 ...
2
votes
2answers
2k views

Unable to add a Choice field to a Calculated field (SharePoint Foundation 2013)

I'm not sure why I'm having this issue, as all material says that I should be able to do this... I have a required choice field that I would like to use in a calculated column. However, when I try to ...
1
vote
0answers
69 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) ...
3
votes
1answer
42 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
20 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
7 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 ...
1
vote
1answer
751 views

Error with special characters in site column names referenced by a calculated column

I have a site column Construction - Complete Date which is used by my calculated column Construction - Is Complete?. Whenever a date is entered for the Construction - Complete Date then Construction ...
0
votes
2answers
32 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
34 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 ...
0
votes
1answer
1k views

SharePoint 2007: Calculated column - formula for calculation based on column containing NA

In a SharePoint list, I have 6 numeric columns that can contain numbers in the range (1,4). However, one or all of these columns may contain "NA" value. There is a separate calculated column which ...
1
vote
1answer
948 views

Calculate Field with a Lookup Additional Column

Would like to ask some suggestion if i have 2 lists (Vendor List & Order List). Where Vendor List is contain with name & discount fields And i create new list "Order List" with field Items, ...
2
votes
3answers
34 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 ...
1
vote
2answers
51 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 ...
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
34 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
76 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 ...
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 ...
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
44 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
3answers
100 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 ...
2
votes
2answers
669 views

Sharepoint KPI using calculated columns

I am trying to create a KPI for the tasks schedule we have on a calendar. The formula I have is: "<div><img ...
3
votes
2answers
76 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 ...
2
votes
2answers
3k views

How to match current user to a username column?

I have a list view that should only show when an admin adds the person's username to an "allowed viewers" username column. So, I am thinking to create a calculated column that compares the ...
1
vote
1answer
45 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 ...
1
vote
3answers
211 views

Calculated column that takes a date field and sets the value to the first day of that month

Is it possible to create a calculated column that takes a date field and sets the value to the first day of that month? I want to create a view that only shows the current month events. Basically, I ...
10
votes
0answers
183 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 ...
5
votes
2answers
10k views

How to find out the number of the week in a calculated field?

How can I calculate the number of the week based on a date in a list? I tried several examples I found on the internet, but none worked correctly? The formula should comply with the ISO standard ...
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 ...
7
votes
4answers
42k views

Column calculated value to get the current date time?

I have tried using =TEXT(Today,"mm-dd-yyyy hh:mm:ss") but that only returns the 5/5/55 00:00:00, it won't give the time. How do I get both the date and time with a calculated formula?
0
votes
2answers
48 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
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" ...
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: ...
9
votes
3answers
3k 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 ...
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
43 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 ...
3
votes
1answer
154 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 ...
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 ...
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
44 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?
2
votes
4answers
17k views

How to get Full Name in 'Calculated Column' from User Id in SharePoint List

I have a list with a column which consist of user id. there is also a calculated column which has to get the full name from this id. I was able to achieve this by installing custom WSP. Is there any ...