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

1
vote
1answer
12 views

Calculated Value Changing when issue tracking list has been resolved

*Hope someone can help me with this issue. I am currently using the following formula to calculate a number of hours a ticket has taken to complete. =IF(Completed="","",INT(((Completed-Created)*...
0
votes
1answer
15 views

SP2013: Calculated column returns 0 instead of “” when list items change

List has 3 columns; Employee Name, Status, and a calculated column. Status is a choice drop down between "Active" & "Inactive". The calculated column formula is =IF(Status="Active",[Employee Name],...
0
votes
1answer
16 views

How To Calculate Difference Between Two Different Lists?

So I have two different lists: contains skills, based on a role, with a Required Level (int) contains skills, based on personnel, with an Actual Level (int) For reasons beyond my control, these ...
13
votes
1answer
318 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 ...
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
655 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 ...
0
votes
1answer
40 views

How to add hyperlink from other list with lookup

I gave up. The task looked simple: I have a list with clients with 2 columns: clientname, clientid, URL. I made another list where managers could collect clients from this list that they frequently ...
16
votes
4answers
16k 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 ...
3
votes
1answer
23 views

calculated column: How to add more variables to a “If-Then” formula SharePoint 2013

Document Library Calculated Column in SharePoint 2013 Enterprise version: I want the column "Priority" to reflect a calculated status based on data in "Current Status" as follows: If column "Expire ...
0
votes
2answers
4k views

Conditional Formatting using Calculated Column as Condition (SharePoint Designer 2010)

I want to use conditional formatting to change the color of a row based on a Calculated Column. I know I could do this with a CEWP but I would prefer to do it in SPD 2010 because I am new to ...
3
votes
2answers
20 views

if and else if in calculated field

I have a column in SP called Pursuit status that contains various states a proposal can be in. For a diffrent project I need to lump them into 3 buckets (win - loss - pending) The fields below are: ...
0
votes
2answers
23 views

Calculated Field - Open/Today Until Closed

I have seen a few tickets with this general solution, but I have a thought about how this would work and how I would like it to update and need some input on how to make it work. I have a trouble ...
0
votes
1answer
22 views

sharepoint calculated column hyperlink not coming if return type is Single line of text

I have a list with country name and country code, I am using the list while creating a form and selecting the country code when a user selects a third column 'select country' which is a calculated ...
1
vote
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
862 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
0answers
12 views

Are Exponential Notations in SP 2013 possible?

I'm using a Calculated column to calculate 'MD' using this formula: (A+B+C) /3 x2 / D x10 And then to calculate 'MC' another Calculate column using formula: MD x D x 10 D = 1E-06 (0.00001) ...
-1
votes
1answer
25 views

Need Help with SP2010 calculated or scripted field based on multiple other colums of data

In a SP2010 environment, I have a couple challenges. I have a list of records that I need to add a calculated field (we'll call this column "STATUS Ratio) for each persons record. Each record has ...
0
votes
2answers
33 views

Update [Closed On} When Status = Closed

I am wanted to add similar functionality to the "Created On" Date column for my "Closed On" column. I want the date to automatically populate once I change status from Active or Pending to Closed, and ...
1
vote
1answer
36 views

Can't see the calculated column “Start Date”

I created Start Date calculated column, now I can't see the column in the list setting.But when I try to create Start Date, I get a alert the column name you entered is already in use or reserved. ...
0
votes
2answers
99 views

How to automatically create item number?

Without programming, I need an item number in the following format: AA-160101-01 AA is static 160 101 is the date, -01 is autoincrementing number, I want to have it counting from 01 every day. ...
2
votes
2answers
1k 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, ...
-1
votes
1answer
28 views

Sharepoint-Online Caculated End Date shows as blank on Gantt View

I have noticed a number of issues with DataSheet/Gantt View when using calculated columns, i will list others at the bottom, however my main concern here is my gantt chart not showing an end date for ...
3
votes
1answer
69 views

Calculated column in Task List is not updating when Task is changed

Scenario: I have a Tasks List A new calculated column added to it Task_ID a. Formula used - =CONCATENATE("TL_",ID) It produces a column having values like TL_1, TL_2 .. and so on. Now whenever ...
1
vote
1answer
621 views

Calculated Fields and Outputting to Excel

So my issue is with SharePoint 2007 and what is happening is that when I output to a excel spread sheet a custom view, If I export some calculated columns it also brings in the columns that were used ...
0
votes
1answer
23 views

create a column of sequential numbers

I want to create a column that auto numbers items as they are added to the list. In my instance, I want to count how many people who RSVP for an event.
1
vote
1answer
44 views

Calculated column - Find Multiple Spaces

A SharePoint list contatins three columns, Requestor name (Single Line of Text) First name (Calculated column) Last Name (Calculated column) I want to extract First Name and Last Name from the ...
0
votes
2answers
51 views

Calculated Column formula for contains

What if I need a "contains" command instead of an = ? =IF([Package Status]="Further Clarification","Yes","No")
0
votes
3answers
3k views

Calculated Column to change text color in a custom list

I have created a custom list and with a column called Account, the column is a dropdown list and with following options Hourly Silver Gold I would like the options above to be bold and be certain ...
0
votes
3answers
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 ...
1
vote
0answers
11 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
2
votes
3answers
3k 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
1answer
58 views

Read calculated column previous value if status equal Closed

I have a "Days Past Due" calculated Column and used your calculated formula (link Sharepoint 2013 Custom List Calculate difference between Today and Column Value) and is working fine. But there is ...
3
votes
2answers
3k views

Use calculated column to add target“_blank” at the end of a Web field URL

It appears I cannot configure a hyperlink column to open in a new window. I read in this post that you can concatenate a hard coded url with the title field of an item to achieve this. However, that ...
0
votes
0answers
33 views

SP '13 - Calculated Column -> with Look up -> JavaScript with color output

I'm building a column that combines two Look up columns (CDF_oQ and CDF_oT) and one date (CDF_date) column. The result should be a column (the calculated Column = CDF) showing the date and the (...
0
votes
0answers
20 views

Calculated column query

I'm trying to color code a column based on Due date field that I have. These are my requirements: If Due date is blank and today’s date is less than 8/1/2016, status column should be green If Due ...
0
votes
1answer
29 views

Create a calculated column that populates a lookup column, based on another columns selection

I've been out of the Sharepoint game for a few years, but the company I work for now has a need for a sharepoint site (and I'm the one to create it). I'm not a programmer and I've just recently ...
0
votes
2answers
730 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.
1
vote
3answers
67 views

Calculate the total of column using calculated column

Is it possible to get the total count of items within a column on another column in the same list using calculated column formula? I researched a lot cant find any calculated column formula that ...
2
votes
1answer
21 views

Can calculated columns be exported, if site saved as a template?

I've created 10 different Calculated columns in various lists in SharePoint 2013 site. I am planning to save the site as a template for future reuse. Please let me know is there any limitation for ...
0
votes
2answers
28 views

Add Content to Search Index Based on Calculation of Properties in Record Center

I have a requirement to be able to search a record(document) in the record center based on a calculation. I can not store the calculated value as part of the item properties because an update of the ...
0
votes
1answer
39 views

Error creating new sites. The formula refers to a column that does not exist

I can successfully save a model of my site but when I try to create a new site with this model, I get this error: The formula refers to a column that does not exist. Check the formula for spelling ...
0
votes
1answer
72 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
3answers
40 views

How to make a KPI appear next to a value in a column

I am trying to work my way around, adding KPIs next to a desired value. I have tried this so far by using this in the calculated column formula field <img src=" "/_Layouts/images/kpidefault-" &...
3
votes
1answer
97 views

filtering rest api call by calculated column

I am not getting any results when I try to filter by a calculated column/field. The calculated field returns yes/no and it displays YESes and NOs in the view on browser. But when filtered for Yes or ...
1
vote
1answer
50 views

Calculated column to take folder name in the library

Can I configure a calculated column in my document library to take the name of the folder where a document is uploaded to? if yes how? for e.g If there is a folder called 'HR' I want the value 'HR' to ...
0
votes
2answers
43 views

Calculated field - If date = date then return another date, otherwise date

I have two fields, StartDate and NewDate. The NewDate field, I want to calculate based on StartDate and return a date. If the Start date is greater than or equal to 3/31/2016, then enter 4/26/2017 in ...
1
vote
4answers
59 views

SharePoint 2013 - calculated columns

I want to know if there are any ressources from them I can take some functions for calculated columns in SharePoint. I found this article MS Site there are some functions, but not the functions NOW(), ...
2
votes
1answer
47 views

Create a hyperlink based on list columns in workflow

I have two lists: List B has two columns called [name] and [link] (both single line of text). E.g.: Name: Google Link: www.google.com In list A I want a look-up to the values in list B. So I added ...
0
votes
1answer
67 views

Calculated column to display the next 8 business hours

In one of the column I am having the current date and time based on that using calculated column I have to show the date and time of the next 8 business hours date and time. How can this be done?
0
votes
2answers
46 views

Calculated field formula IF statement between two values

Can someone please tell me what is wrong with this? =IF( [Hourly rate]>160 ,4 ,IF( AND[Hourly rate > 145,[Hourly rate] <160,3 ) ,IF( [Hourly rate]=145 ...