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

Calculate monthly occurance

I wanted to created a calculated SharePoint column which gives me a sum of the monthly occurrence. For example: During the month of July there were 7 occurrences so I wanted a calculated field to ...
0
votes
1answer
109 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
2answers
2k 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 ...
0
votes
2answers
50 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 ...
6
votes
3answers
186 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 ...
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 ...
1
vote
1answer
615 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
0answers
13 views

Map a calculated column to a managed property?

I'm trying to map a Calculated Column of the type Date and Time to a Managed Property of the type Date and Time and then use it in a display template. What i have done so far is: Created a ...
0
votes
1answer
841 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
36 views

calculated formule help

I have a field Title with value like below Title=3.10-gotomeeting I want a calculate formule to remove ("-")and (".") so that the output should be only a number i.e "310". Can any one help me on ...
2
votes
2answers
71 views

Can't get calculated column syntax right

This "ought" to be easy and yet as with so many things SharePoint, it isn't. I have a calculated column where I keep getting a syntax error. If the user sets a dropdown column value to x, then y ...
1
vote
3answers
63 views

Images in calculated columns

I have a calculated column, formatted as number which is showing and image. Everything works fine on list views and in the web parts. But when I view a specific item, the calculated column only shows ...
1
vote
2answers
514 views

Calculated column with link - remove space / whitespace / slash

=IF(Title<>"";"<a href='/test/"&SUBSTITUTE([Title]," ","")&SUBSTITUTE([Title],"/","")>Info</a>";"#") I'm trying to create a link based on two coloums. Is there a way to ...
0
votes
1answer
944 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
1answer
36 views

Update column using javascript

I'm somewhat new to SharePoint and I need help updating columns using javascript. I have a list that tracks expiration dates and shows traffic lights based on the days away from that expiration ...
1
vote
1answer
510 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
31 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
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 ...
0
votes
2answers
91 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 ...
0
votes
1answer
24 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
22 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
569 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
24 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
43 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
38k 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
33 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
26 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
2answers
44 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
40 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
27 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
4answers
3k 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
56 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
17 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
24 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
486 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
25 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
59 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
91 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
42 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
16 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
16 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
55 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
434 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
35 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
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
58 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
57 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
31 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 ...