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

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 ...
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
44 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 ...
1
vote
1answer
645 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
0answers
29 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
18 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
26 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
695 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
63 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 ...
12
votes
4answers
14k 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
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
24 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
33 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
46 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
37 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
64 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
843 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 -...
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 ...
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
vote
1answer
36 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
38 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
48 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
38 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
37 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 ...
2
votes
2answers
1k 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 src='/_layouts/images/KPIDefault-"&IF(Completed="Yes",0,2)&".gif'/><...
0
votes
1answer
39 views

add 15 days to a date with different formating

I am trying to create a calculated column that adds 15 days to the EndDate field and then output it with a YYYY/MM/DD format, but I am not getting the desired results. Here is what my column looks ...
0
votes
1answer
24 views

Calculated field based on values in other columns

I have a new SP 2013 List that I would like to add a new field with a calculated 'score' based on the values of a few other columns. For example, The Choices for Col1, Col2, Col3 and Col4 are all ...
1
vote
2answers
32 views

“The formula refers to a column that does not exist. Check the formula for spelling mistakes or change the non-existing column to an existing column.”

I am trying to create calculated column using csom. var fieldXml="<Field Name='calctest' DisplayName='calctest' StaticName='calctest' Type='Calculated' Required='FALSE' ColName='sql_variant1' ...
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 ...
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 ...
1
vote
2answers
27 views

How to display text rather than a number in a Calculated Field?

I have a List containing a Calculated Field, "Risk Priority", which is calculated using the formula: =IF( ISBLANK([Internal Control Score]) ,Impact*Probability ,Impact*Probability*[Internal ...
0
votes
2answers
32 views

Error Column Formula

I would like to create a calculated column to return a text value based on a score in another column but I cant get the syntax correct. can someone help? Low = 0 - 35 Med = 36 - 70 High = 71- 105 V ...
0
votes
1answer
67 views

Calculate Totals of certain list items and display via custom view as a webpart for [me] users

I'd appreciate your advise on this. I've seen Java scripts for this, but I'm not sure if I need this. I hope not and I hope I can do something like this in a workflow. I have a list for staff to ...
0
votes
1answer
14 views

How to Get Workflow to Initiate based on a date in calculated column

I am new to workflows and am not a developer, BTW. I have a custom list with several workflows attached which is designed to send email notifications to many at various time intervals based on a date ...
1
vote
0answers
29 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
1answer
608 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
33 views

How to have number of chosen Lookup field in another list?

I am working on SharePoint 2013 Enterprise. I am looking for a functionality so I can sum item chosen in a list. As an example I have a list call Bus which is the parent list. The second list is the ...
0
votes
1answer
24 views

Javascript help with retrieving data from list SP2010

I would like to retrieve data from a list that has 2 columns but 4 fields. Ex. I need the calculation from monthly & yearly cost from group 1 and calculations for monthly cost & yearly cost ...
0
votes
1answer
16 views

workflow to show the amount of tree columns in one column

I have a list with tree columns that get year,month, day from user and I need to show the full date in another column. For example, if an user type 2 in day field, September in month field and 2004 in ...
0
votes
2answers
28 views

Help with calculated columns

I have two columns in my SharePoint list called name and email, So I want to have the name be the display name and have the value of the email. So when a users selects a name he or she won't see ...
-1
votes
3answers
30 views

Calculate recently modified Date Column [closed]

SharePoint Online. Date Column A - Date when the value changed to X, Date Column B - Date when the value changed to Y, How to create a calculated Date Column C = Recent Modification or latest ...
3
votes
1answer
29 views

SharePoint Online - Selecting most recent date column between two columns in a list

I have a SharePoint list in Office 365 environment that (among other columns) has two DATE columns, how would I create another calculated column that would have the most recent date from those two ...
0
votes
1answer
53 views

Time Difference in SP Calculated Column excluding weekends

I have two dates (Initial Date & End Date) both date and time format in a SP List. I need to calculate the amount of days between both of them excluding weekends. I already have the formula in a ...
1
vote
3answers
40 views

Calculated column for differences between two dates with blank check

I am trying to create a calculated column which shows the number of days' difference between two columns which have dates in them. I understand that I can get this with the following formula: =...
0
votes
1answer
28 views

Trying to make a difference between two dates, with days, hours and minutes

I try to make a difference between two dates, but displaying the days and hours. So I found a good idea on this website : https://sharepointonline.wordpress.com/2012/03/02/date-time-duration-using-...
1
vote
2answers
21 views

Calculated field for difference between two times

I have a list with a "Start" field and "End" field. I'm using a calculated field to determine the difference in hours and minutes between the two. Start - 9:00 am End - 10:30 am =TEXT(End-Start,"h:mm")...
1
vote
1answer
41 views

sharepoint formula to send email to user

Can anyone help me with sharepoint formula? What I am trying to do is I have a list column and it has list item Column Name: user Type: Choice Type of Choice: List of names (Eg jack, bob, ...
2
votes
4answers
2k views

How to show two dates in one calculated column

I'm using Sharepoint Foundation 2010. I have two columns, start date and ending date. I want to make calculated column which shows both of them in the same column. Everything is okay till I add both ...