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
2answers
73 views

List Group By Week not working properly

I have a list grouped by the following formula. =CONCATENATE(TEXT([Effective Date]+(5-WEEKDAY([Effective Date])),"mm/dd/yyyy")," - ",TEXT([Effective Date]+(11-WEEKDAY([Effective ...
2
votes
3answers
38 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 ...
0
votes
1answer
15 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
2answers
15 views

Using a Calculated Column to show Images

Ok, I've been working on this most of yesterday and today. I am able to render an image with the following formula - ="<div><img src='/xx/xx/PublishingImages/"&IF([Employees ...
0
votes
2answers
543 views

Remove spaces from column

I am not sure if this is can be done with a calculated column or with a sharepoint designer workflow, therefore I used both tags. Basically I need a way to remove all spaces from an existing column. ...
2
votes
1answer
19 views

Will a calculated column formula interpret number strings as numbers?

This is my first time using calculated columns. I have a calculated column that is a number field, that is calculating it's value based on two other columns that are choice columns. I know that ...
0
votes
1answer
41 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 ...
6
votes
3answers
37k views

Column calculated value to get the current date time?

I have tried using =TEXT(Today,"mm-dd-yyyy hh:mm:ss") but that only returns the 5/5/55 00:00:00, it won't give the time. How do I get both the date and time with a calculated formula?
0
votes
1answer
25 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
2answers
1k views

Calculated column with today's date based on other columns

I've been struggling with the calculated column in SharePoint. I would like to have a column in which the date is calculated from the values in two other columns. I have one column named "Status", a ...
1
vote
1answer
591 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

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
24 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
1answer
797 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
2answers
43 views

conditional subtraction between 4 fields

I need to create a calculation that basically is a subtraction between two fields (2 date fields). However it should be done only if a 3rd field is equal to a value of 5 or 6 AND a fourth field less ...
1
vote
1answer
39 views

Conditional subtraction

I need to create a calculation that basically is a subtraction between two fields (2 date fields). However it should be done only if a 3rd field is equal to a value of 5 or 6. My first field is ...
1
vote
0answers
24 views

Cannot create site from template due to missing column

I have created a site template that contains a list with a calculated column. Here is the column formula: ="<DIV><img src='"&IF([Project Status]="On ...
0
votes
1answer
910 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 ...
0
votes
4answers
2k views

Trouble with IF formula

We have a task list with a column that categorizes tasks into one of 12 categories. We're trying to calculate a NEW column that will be populated with one of two values, "Technical" or "Procedural" ...
1
vote
1answer
27 views

Is there to have a parameter for an entire list?

Is it possible to have an attribute, like start date, where other columns would use it to calculate their value? For example the due date column would take the start date and then add the amount of ...
0
votes
2answers
50 views

How to remove Domain Name from [ME] Calculated field and show Display Name of User

I use [ME] in a calculated field it returns a username of \username. Customer wants to see the user name as display name not as login name. Would like to know whether a SharePoint formula I can use to ...
0
votes
0answers
13 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
20 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
1answer
1k 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
499 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
476 views

Calculated columns using ID field not showing all details

I am a Sharepoint site admin without any development tools, I'm solely battling on with the Sharepoint web front end. What I would like to do is to create list items and generate a unique reference ...
0
votes
0answers
23 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
2answers
26 views

Calculated column - All records from [today] and [today]+5 when comparing to Due Date

I am trying to create a view where Invoice Admin wants to see all the records where invoice due dates are within next 5 days. I added a calculated column and i have =[DueDate]-5 but this formula only ...
0
votes
1answer
54 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
1answer
83 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
1answer
38 views

Extract part character from a string using calculated column [duplicate]

I have the following string: XXXX.C.2.0.1 how do I extract just the "C"? thanks
0
votes
0answers
14 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
0answers
12 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
2answers
50 views

How to create calculated field column for sorting the numbers

I have three columns value1 value2 value3 (100 100 80) (100 100 100) (70 40 50) I want to sort this by concatenating all these and padding left 0 and then sort it. Can any ...
1
vote
1answer
423 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
1answer
27 views

Parsing multiple strings (numbers) from a single line of text column and adding them together

I have a user who has requested a way to track vendors and their price quotes for project work. The user would like to have the list automatically calculate the total of all quotes listed. There can ...
0
votes
1answer
83 views

Can anyone color code a column with an if statement?

Here is what I am trying to do. I have a SharePoint 2010 list that I want to color code dates based on that it expires 364 days after the date entered. Example: If the date is older then 334 ...
0
votes
0answers
31 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
47 views

Calculating Fiscal Year in YY format

I found this post and it worked for a 4-digit year but I am trying to use a 2-digit year Calculating Fiscal Year This will give you the format 2013-2014, 2014-2015: ...
0
votes
1answer
43 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
2answers
45 views

IP Address list sorting

I have a list that contains IP address and im unable to sort on them. I have a function that works in Excel ...
0
votes
1answer
23 views

How do I rename a calculated column using SharePoint 2010 list webservices

I'm having trouble figuring out how to rename a calculated column. The below code creates the 3 fields, and renames the first two but it won't rename the 3rd one. <UpdateList ...
0
votes
2answers
133 views

Using HTML to recalculate calculated column

I wish to create an auto incremented "TaskId" list field. I had intended to create a new value that padded out the [Id], but obviously [Id] cannot be used as it is not available until after the item ...
0
votes
1answer
60 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 ...
0
votes
1answer
3k views

How can I use data from Managed Metadata Columns in Workflows and Calculated Fields?

It seems that sharepoint does not allow MM columns to be used in calculated fields, and I'm not sure how to use them in a workflow either. Can someone please inform me as to how I can use terms in the ...
1
vote
3answers
42 views

SharePoint List Column Formula using YEAR and LOOKUP

I have created a column named Quarter (Type - Calculated) in my List that I want to calculated based on a Date column (ex. 01/26/15). My formula is as follows: ="FY"&YEAR([Date]+274)&" ...
0
votes
1answer
54 views

how do I add 90 days to a calculated column?

I have 3 columns, for simplicity we'll say column A, column B and Calc Column. In the Calc Column I need a formula for the following: If column A is blank, and column B is greater than 90 days from ...
0
votes
1answer
35 views

List item default value based on another item in the same list + value

How do I set the default value of a list item to be based on another item's value + value? For example: List A: duedate, reminderdate once the user enters a value in the list--> duedate = 1/1/2016 ...
1
vote
3answers
2k views

Calculated Column left align header

In my list, I want a column to have a custom hyperlink. I create a Calculated column that has the following formula. ="<a ...
1
vote
2answers
12k views

How can we create and calculate a ([Due Date]- [Today])/7 column in SP 2010?

How can we calculate ([Due Date]- [Today])/7 column that updates daily as value of Today changes and lets us calculate weeks left for due date ? Could create ([Due Date]- Today() )/7 and it worked ...