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

0
votes
1answer
28 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
56 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 ...
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
0answers
20 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 ...
2
votes
0answers
34 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
1answer
29 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
30 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: =DATEDIF([Fecha01],[Fecha02],"D")-IF(WEEKDAY([Fecha02])=7,FLOOR((DATEDIF([Fecha01],[...
2
votes
2answers
32 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 ...
0
votes
1answer
42 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 ...
0
votes
1answer
27 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 green,background-color:"&IF(...
2
votes
1answer
128 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
2answers
62 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 ----------------------------------- ...
1
vote
1answer
28 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 ...
1
vote
3answers
66 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' + location.search"...
1
vote
4answers
65 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 ?
0
votes
1answer
71 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 ...
0
votes
0answers
30 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
32 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
31 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
81 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. I'...
0
votes
1answer
46 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
17 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
45 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 - ...
1
vote
2answers
49 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
71 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
25 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
48 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
24 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 ...
0
votes
0answers
62 views

Negative DateDif Result

I'm trying to calculate the difference between 2 dates, (Starting Date) and Today. If the result is negative (IE: Starting Date is in the future) it means we still have that number of days before we ...
0
votes
0answers
47 views

SharePoint Tasks Outlook Categories Color Codes

I'm trying to get Tasks created in SharePoint to show in Outlook with a color category based on Priority. As of now, I can add existing site column Categories and manually type in "Red Category" and ...
0
votes
1answer
19 views

I want the Left 10 characters of the name column calculated in another column

A lot our names on SP are real long names; I would like to get say the left 10 (or any number of characters I put in the formula) characters of the name to calculate into a column. This would make ...
1
vote
0answers
25 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
3answers
144 views

Count not updating in calculated column

I am getting number of days between Created & Now in SharePoint 2010 list using calculated column by below mentioned formula. =IF(ISERROR(DATEDIF(NOW(),Created,"d")),DATEDIF(Created,NOW(),"d")) ...
1
vote
1answer
25 views

Using more than 9 row colours in a SharePoint 2013 task list

On a task list, I want all 17 staff members of a team to have their own colour. I made a calculated column with this script found on the web, and it works fine for member 1 to 9. Unfortunately, member ...
0
votes
0answers
40 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
3answers
82 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 ...
2
votes
0answers
19 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
1answer
47 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
45 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, "DD/MM/...
0
votes
1answer
16 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 ...
0
votes
1answer
45 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 ...
0
votes
2answers
65 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
51 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 ...
1
vote
2answers
63 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 ...
2
votes
3answers
46 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 ...
0
votes
0answers
34 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: 55555|...
0
votes
1answer
28 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 =IF(AND([Status]="...
0
votes
1answer
167 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
588 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 ...
5
votes
1answer
58 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 ...