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
918 views

Calculated Column Incorrect when All Day Event is selected

I've created a Calendar list. I've added a single calculated column ("Calculated Start Time") that simply references the "Start Time" column. It reports the correct date when the event is not an all ...
0
votes
1answer
68 views

How Create Decade Field Calculated

Hello I'm having trouble creating a calculated field I managed to create a field that takes the date of an event =YEAR([Event Date]) however I needed to create another calculated field, this needs ...
0
votes
1answer
332 views

How can I prevent a user from changing a formula in a calculated column?

I would like users to be unable to change formulas of some calculated columns, both from the list settings and from datasheet view. I am currently trying this via event receiver but I have went back ...
0
votes
2answers
3k views

Nested if statement in calculated list item

This should be easy but I have been beating my head against the wall on it. Here is my statement I'm using: =IF(AND([TODAY]>[Due In],[Comp Date]=""),"NO",IF(AND([TODAY]<[Due In],[Comp ...
0
votes
3answers
4k views

Display Calculated Field as link

in a custom ListDefinition I used a calculated field to format a Text into an URL. I'm developping in VisualStudio2010 for SP2010. Here is my ListDefinition: <Fields> <Field ...
0
votes
1answer
3k views

Use value of Hyperlink column in a calculated column

I want to create a calculated column, it should show the value of Title and the URL of a Hyperlink column called Main Website. But I get an error for my formula: =[Title]&" ("&[Main ...
0
votes
1answer
103 views

set several list columns based on portions of document name seperated by an underscore

If I have a docuent library that has a documents in it using the following format: Region_Division_Store.pdf ...notice the underscores. I also have three columns named Region, Division, Store. ...
0
votes
1answer
3k views

How to use the countif function of excel in calculated column of list?

I have a calculated column in my list where I want to apply the countif function available in excel. How can I do tht? Please guide.. Thanx in advance..
0
votes
1answer
783 views

Have an Association Column equal the field of another Column

I have created an association column as part of a reusable workflow in SharePoint designer. I am now trying to have this column equal the field of another column in Document Library. I have tried ...
0
votes
2answers
718 views

Trying to detect published documents

I have a site that has a document library and I made a calculated field for the content type called status that determines if a file is published or not. I used ...
0
votes
1answer
146 views

Sharepoint Column Totals to User - Value defined by status

So I have two list databases. User Points User Submissions These two databases work together. A user 'submits' for points in a status of 'submitted'/UserPoints[PendingPoints:Column] once 'approved' ...
0
votes
1answer
252 views

Calculated column to split the url Moss 2007

I have a link column eg: http://abcd/Shared%20Documents/test.doc. I need to create a calculated column to just get the name of the file..in this case "test.doc". Any help with the calculated column ...
0
votes
3answers
2k views

Calculated value column

In SharePoint foundation 2010 can i add a new calculated value column where the calculation are based on when another column is modified ?
0
votes
2answers
2k views

How to prevent #NAME? error in Calculated (Site)Columns

In SharePoint 2010 I've made a lot of Site Columns that I use in different content types. When I make a calculated column, that involves a calculation based on other columns, something goes wrong. ...
0
votes
1answer
376 views

Calculate Time Passed After Item Created Using Javascript (or other)

I have a list that tracks loaned equipment. I want a little icon that is a visual indication at how long the item has been on loan to help visually cue employees to follow-up. For example: 0-4 ...
0
votes
2answers
1k views

How do I set up a calculated column to reference itself?

I need to set up a column that will keep a running total of values. I have a program that automatically sets values for the columns in SharePoint. The program will overwrite the previous value ...
0
votes
0answers
18 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 ...
0
votes
1answer
36 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
31 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
32 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
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
2answers
47 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
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: ...
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
32 views

How to create a calculated field and use it in a list definition?

Here is my code: <?xml version="1.0" encoding="utf-8"?> <Elements xmlns="http://schemas.microsoft.com/sharepoint/"> <Field ID="{A57D77CA-9D80-458A-AB81-884C4F5A946D}" ...
0
votes
1answer
46 views

Calculated column with ID removes ID number on update

I'm using SharePoint 2013 and I have a calculated column in a custom list, called "Project ID" that has the following calculation: ="DS-000"&ID The first item in the list has the "Project ID": ...
0
votes
1answer
63 views

Using [Today] in calculated field results in “Cannot complete this action. Please try again.” error

As you can probably guess from the title, I am trying to use the formula =[Today] in a calculated field. I then use this field to compare two date fields. These represent start and end dates. Lastly, ...
0
votes
0answers
30 views

Calculated Issue

I'm getting syntax error with this formula can any point out what I'm missing or needed to be added. The results I'm looking for should be 1510AK15210#### =TEXT([Start Date],"YYMM") &[State or ...
0
votes
2answers
29 views

Capture Content Type selected at creation

I am trying to create a column that capture which content type a user selects to create an item in a list at the time of creation. I would also like to prevent that new column from changing regardless ...
0
votes
1answer
34 views

Combine value of a task list into hyperlink

in sharepoint 2007 I want to combine the number - value (of a task in another system) in to an hyperlink like this: "http://172.xxx/Iso/index.php?actie=cs&pt=ontwerp&volgnummer=" and "value of ...
0
votes
0answers
22 views

Add x number of calculated days excluding week ends [duplicate]

I want to create a calculated day with say 21 days from today.But it should exclude weekends from numbers. I was using [Today]+21 as formula but it does not exclude weekends count. Does anyone know ...
0
votes
2answers
38 views

Hyperlink for Workflow

I've made one calculated field and in there Hyperlink for workflow. =("<a ...
0
votes
1answer
86 views

Boolean field values differ between the InfoPath form and the SP view. Why?

I've got a 2010 SP list that tracks tickets about an application I own. It tracks various ticket attributes including'status' and 'type'. I want to create a view of 'open' tickets for my developers ...
0
votes
1answer
48 views

Display Sum of a calculated column

I have one calculated column and I want to display the sum of all its values but I know that's impossible in a OOTB way. How can I copy all the values to a new column (type number)? Do I need to use ...
0
votes
1answer
39 views

Calculated value field not the correct value in the main list view column [duplicate]

so I want to make a counter in my list that stars from a custom number. In the custom form I added a calculated value called CustomID and calculated the value for that field with: ID + 100 When I ...
0
votes
1answer
92 views

Calculated Column to extract text within file path

Due to SP limitations in workflows for extracting text strings, I'm looking for another way to skin the cat. If I have a single-line text column that has a file path like: ...
0
votes
1answer
45 views

Calculation for output that displays $1 per $1000 of amount from another column

I have a list that is a Sales Log. I have been tasked with creating a column that will look at a dollar amount and will give me a dollar amount based on that. Specifically, $1 per $1000. I am ...
0
votes
1answer
39 views

Issues with Color-Coded Calculated Columns

I have a list with a series of columns that all return percentages. I have done the stop light chart with status columns but not percentages. I have gone to 'Path to SharePoint' - the site everyone ...
0
votes
0answers
21 views

SharePoint LIst Calculation Date(s)

I am trying to create a column calculation that will return 2 different dates based on the Date / Time the Request was Received/Submitted during 5 day work week. Example: If submitted the day ...
0
votes
1answer
41 views

How to add a column which has auto increment value based on update of other column in a list

I have a list where in we are capturing Completion Month date. It can be updated by users if required. I need to have a record of number of times this value is updated for each individual row starting ...
0
votes
0answers
44 views

pop up info tab for custom list in sharepoint 2013

I am looking for a pop-up something like in the picture. (column info) Is it possible to use calculated column or Client Side Rendering for this kind of requirement. Anyone who have any idea ...
0
votes
1answer
96 views

Insert a break point in a column

Okay so I have a sharepoint list, and in this list is a Choice column where you can suggest multiple choices. I am exporting those choices to a calculated column. I want there to be a line break ...
0
votes
0answers
24 views

Calculated column used in reporting services shows #Error

I am using the following formula in a calculated column to extract the month from the "ResolvedDate" column. =""&MONTH(ResolvedDate) It works well, but now I intend to use it in reporting ...
0
votes
1answer
142 views

How do I sum a column in SharePoint 2013?

I have a requirement that I need to sum a column in my SharePoint page then send a email if its one or bigger. I have got the email part down and its working, the problem is everything that I can ...
0
votes
0answers
31 views

How do I add Date and Time together for a Calendar view, maybe in workflow

We need the user to be able to select a Time slot when creating a new item, from between a cycle of 6 hours, so 12pm - 6pm, 6pm - 12am, 12am - 6am, and 6am - 12pm. They would also pick a Date. ...
0
votes
0answers
41 views

calculated column get_item returning 0

Using a calculated column, I am trying to print the value of a column for the current selected row into the console LOG, but all it ever displays is 0. Can anyone see what the error might be? The ...
0
votes
1answer
282 views

Calculated column problem from Multiple lines of text

I need to add calculated column (or something else) to my list which can discover and write, if is something in column of "multiple lines of text" within the bounds of this list. I can do it with ...
0
votes
1answer
85 views

Updating Column Name using Calculated Columns

I want to update a Column Name using a Calculated Column. In my attempts below, I'm trying to rename the Column name from Col2change to NewName. None of the code snipperts work. I do not have access ...