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
votes
3answers
23 views

Calculate recently modified Date Column [on hold]

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
16 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
32 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 ...
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
3answers
19 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
26 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 : ...
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
2answers
15 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 ...
1
vote
1answer
26 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 ...
0
votes
2answers
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
23 views

Calculate lines (elements) and set a value to a field with calculated column

I have a list with some columns, among these columns there is one named "palette". I would like to count the number of elements in the list, and put the value "1" for the ten first elements at the ...
1
vote
1answer
620 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
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
54 views

How to have string between “:” calculate column?

I'm working on SharePoint Enterprise 2013. I have a column call "CountryWF" wich shows Country:state:city. I need a calculate column to shows between ":" which is State. I made some columns and each ...
-2
votes
0answers
34 views

Calculated Formula in SharePointList

How to write this formula in Calculated column? If ColumnA matches ColumnB where ColumnC is Blank then background color of ColumnA is Green
1
vote
1answer
571 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 ...
1
vote
4answers
59 views

SP07 - Auto_Increment Column

I have a column with name "Title " and want to make my column be a auto increment (1, 1) with Calculated column option. How to do it ?
2
votes
0answers
33 views

Filtering Lookup Column By Expiration Date [duplicate]

Scenario: I have created a lookup column with two columns. A department column and Expiration Date column. Each Department has a Expiration Date. For example see the image. When the Department ...
0
votes
0answers
16 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
1answer
25 views

calculated formula help

I am creating a site column of type "CALCULATED" through visual studio. Here is my scehma . when i try to deploy it gives the below exception <?xml version="1.0" encoding="utf-8"?> <Elements ...
2
votes
1answer
25 views

Create a Condition and calculate working days

I have a list with several dates' columns. I need to calculate working days I am using the following formula: ...
2
votes
2answers
28 views

Calculate time including IF column value

I have the basic time value formula, but I am having two problems; The first is with this Total Comp Time formula: =TEXT([Start Time]-[End Time],"h:mm") It does display the difference in time as ...
2
votes
2answers
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
25 views

Finding Column Average

Created a custom list in SharePoint 2013. I have a column that is full of numbers. I would like to find the average per column. To solve this issue I created a calculated column and applied this ...
1
vote
1answer
25 views

Formula Syntax/Logic help

I am trying to compare text in two columns to auto calculate a result in a third calculated column (represented by an image). The logic is as follows. If column1 value is Green and Column2 is ...
0
votes
2answers
634 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.
2
votes
1answer
27 views

Make a column mandatory based on value of another column

I have created an action list and when the status column is set to 'closed', I would like the 'date closed' column to automatically populate with the current date. If this is not possible, it would ...
0
votes
1answer
23 views

SharePoint calculated column IF statement w/ colour indicator

Any hints/idea why the following formula shows no result, empty column? Rating Graph Column ="<span style='height:1ex,width:"&(10*1)&"px,border:1px green ...
0
votes
2answers
41 views

Convert Choice field value into Date format using Calculated column

I have a choice column in which choices are name of months. I want a calculated column which returns me the date format data. Choice Column | Calculated Column ----------------------------------- ...
4
votes
4answers
3k views

Get difference in Minutes for DateTime format column

I have a formula for calculated column which gets the date difference in hh:mm format. =TEXT([COLUMN2]-[COLUMN1],"h:mm") But I want to get the difference in just minutes. I created very complex ...
1
vote
3answers
54 views

How add a anchor link in document library site column?

I want to add an anchor link in a document library to redirect to another page. How can I do this? The anchor link is: <a onclick="javascript:location.href='UploadDocuments.aspx' + ...
1
vote
1answer
812 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
1answer
33 views

Calculated Field with formula DATEDIF

Im working with a calculated field and using a formula to retrieve the difference of the days between two dates, DATE1 and DATE2, my simple formula is: =DATEDIF([DATE1], [DATE2],"d") It works fine ...
10
votes
4answers
9k 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
197 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
0answers
26 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
24 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
28 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 ...
1
vote
3answers
56 views

Make dynamic calculated column Formula URL open as modal

Created a dynamic URL within a calculated column ="a href='/.../Test Doc Library/"&Title&"'>LINK</a> which works fine, but I need it to open as a modal and cannot get it to work. ...
0
votes
1answer
29 views

Column validation accept a specific character and numbers only

So far I manage to make a validation that makes the column only accept numbers: =ISNUMBER([Column_Name]+0) But I want users to be able to type ";" inside as column value so only numbers and ...
1
vote
1answer
16 views

return blank if field is blank

I have the following calculated column that returns the "Max End Date" field using the following format YYYY/MM/DD. =YEAR([Max End Date])&"/"&MONTH([Max End Date])&"/"&DAY([Max End ...
1
vote
1answer
34 views

Calculated Column based on two others - Is there a limit on nested IF statements?

I'm trying to set up an automated column based on two others. Likelihood + Consequence = Calc Column 1 - Rare 1 - Minimal = 1 - Low 1 - Rare 5 - Severe = 10 - Medium 1 - Rare 2 - Minor = 3 - ...
5
votes
3answers
11k 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
1answer
319 views

Sum Calculated Column (SP 2013)

There is a very nice solution below from ViewMaster (http://www.viewmaster365.com/#/Create/Sum) that involves some scripting within the formula of a calculated column itself. However, the Sum will be ...
1
vote
2answers
21 views

Calculating a fiscal quarter from a date

I'm using the following formula to find the fiscal quarter (where the year starts in April) from a date in a list: ="Q"&INT((MONTH([Date of inspection])-1)/3) HOWEVER -instead of displaying ...
0
votes
1answer
39 views

Highlight upcoming/overdue calculated column dates in a training list

I have a list to track customer training. Two of the trainig items are recurring; Ethics - annual and GPC Refresher - biannual (every two years). The due dates for each training requirement were ...
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
45 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 ...
0
votes
0answers
18 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 ...