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

Calculated column: Lookup

Say I have a Date/Time [Date] column and a numerical [Value] column. I am creating a calculated column. I need a formula that will find the row with the most recent date in the [Date] column, then ...
0
votes
1answer
70 views

Sharepoint List auto ppulate

Team, I have 2 Lists. In first list i have 2 columns called ProjectID,project title In second list i have same 2 columns Requirement: When i select project title in second list,The projetc ID ...
0
votes
1answer
50 views

Manually Refresh All Items for Calculated Field

Using SharePoint 2010. Currently I have a column that is calculating the "Days left to respond" using the formula below. =IF(IssueDate>0,IF(CurrentSPIResponseDate="",ResponseDueDate-NOW(),""),"") ...
0
votes
0answers
23 views

Calculated Column display formatting html in display form and in excel [duplicate]

I am struggling a little with calculated column. i have put the following formula with html in Calculated column. =IF([Gross Impact]*[Gross probability]<=3,CONCATENATE("<DIV ...
0
votes
2answers
218 views

Calculated column issue with if statement and yes/no field

I have seen other similar questions about calculated fields/columns and Yes/No fields, but only regarding syntax. I don't have an issue with the syntax (I think) but I can't get an IF statement to ...
2
votes
1answer
179 views

Calculated field shows seemingly random number when set to be empty

I'm trying to set up this solution for creating a filtered lookup: How to make a filtered lookup field I have set up an ItemAvailable column like this: The column "Availability" is a choice ...
0
votes
2answers
25 views

Is this possible with calculated column?

Here is what I am trying to achieve: I have a column with this 2014-NNNN/XXT I need to extact the number part (NNNN) and increment with nearest multiple of 10. So for instance if the number is 5010, ...
0
votes
1answer
198 views

How to set a column value based on another column value

I have a sharepoint list which contains a drop down of the values , Immediate , Hire , Specific I have another column Grace Period which is a numeric When the drop down column Immediate is selected ...
1
vote
1answer
127 views

Help with 'IF' Statement for Calculated Column

I need help writing an IF statement for a SP calculated column. I have it working right now to display the green indicator, but need to add the clauses for it to display the yellow and red indicators ...
1
vote
2answers
290 views

How could I have a custom task list update all start dates if an item is changed?

I'm not exactly sure how to approach this problem. I am hoping it can be solved with calculated columns or thru a workflow. If it can only be accomplished with some advanced technique beyond the ...
3
votes
3answers
153 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 ...
0
votes
0answers
65 views

SharePoint 2013 Online - Calculated field/Metadata email issue

When parsing out a section of text to be sent in an email I keep receiving error;#256 in place of the text. The column in the list looks good, but it's when sending out the data in an email is when I ...
1
vote
1answer
128 views

SP2010 Javascript Object Model: programmactially add calculated column to list

I am building lists and adding fields via the following. I am wondering if I can add a calculated field and how you set the formula in this (or another method): function onCreateRootCause() { var ...
0
votes
0answers
75 views

Conditional formatting not updating on calculated field

I have a calculated field with the following formula: =WENN(Fälligkeitsdatum<=HEUTE();"RED";WENN(Fälligkeitsdatum<=HEUTE()+4;"ORANGE";"GREEN")) For understanding purposes: Fälligkeitsdatum = ...
1
vote
1answer
151 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
2answers
384 views

Calculated column value for Yes/No field in sharepoint

I am developing a KPi, where am using a column named Complete which contains Yes/No field in it. For this if i write a calculated value for yes/no field: =IF(CompletedTask=1,"Yes","No") its not ...
0
votes
1answer
104 views

Calculated field with images and multi-value column

Say I have this list that looks like this: Title Link ----- ----- Cat /animals/cats.aspx Dog /animals/dogs.aspx Duck ...
0
votes
1answer
796 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 ...
0
votes
0answers
23 views

calculated column based on a view

I have a created a calendar with 5 views to make it seem there are 5 separate calendars to the users. ( I cannot use 5 separate calendars due to workflows ) When they book an appointment on the ...
0
votes
1answer
52 views

Extract data between parenthesis in calculated value field

I'm using SharePoint 2007 and I would like to extract data from parenthesis from another column to a calculated field in the same list. For example: Column named "Team", value "RED (Mark, John, ...
1
vote
1answer
83 views

Calculated value formula

I need help with the formula for the following problem. I have a list where you fill in a number of ordered items, and another column where you fill in how many of the items that are receieved. Lets ...
1
vote
2answers
432 views

Calculated column, when does it recalculate?

A calculated column refreshes its content when an item is created or edited, so far so good. However, when an item is displayed in a list view, is the result of the calculation updated or not? I have ...
1
vote
1answer
402 views

SharePoint 2013 calculated column not refresh data in ListView

Scenario: I have a list of controller the assets the enterprise. In this list I have a column with the warranty date. A calculated column verifies if the date already expired. When I add or edit an ...
1
vote
1answer
58 views

Workflow Instance Blocking Calculated Field Update

Is it possible that an instance of a workflow can prevent a calculated field from being updated? My scenario: SharePoint 2013 Workflow 2010 Calculated field: (=IF([Dt Prox Contato]<Now(),"Old", ...
0
votes
1answer
34 views

New Item Fields Automatic Population

I sure this is possible to do in SharePoint, however, I am not 100% sure on how it's to be done. My objective is to 2 fields to automatically populate when adding a 'New Item' to an List Library. ...
0
votes
1answer
222 views

How to add a calculated column which shows the modified date/time of an attachment?

I have a list where each item has an attachment (or in some cases 2 attachments). I would like to add a "Last modified" column in a view which shows the date/time of the last attachment modification. ...
1
vote
1answer
111 views

Calculated Column - # of Unique Values Within Column

I have a time off calendar. What I would like for a column to do is count and update the number of unique values for that day. Here is an example: Day Off ||||| # of Values 12/1/13 ...
0
votes
3answers
262 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
1answer
88 views

Add additional user information to SPList as list column

I have a List Tickets with a field Client. This is a user from our AD and displays the name of the user. We now need to display the country and the location the user resides in to additional fields. ...
1
vote
1answer
177 views

Have calculated column return boolean

I have a calculated column which I have set to check if another column is blank or not. I have a webservice which looks into this list and should return true or false if the column is empty or not. ...
2
votes
1answer
224 views

Calculated Column - Calculate Date based on other column value

I'm looking for a solution that I'm really struggling to find the answer to (I have searched, plenty!), or more specifically, find an answer that suits my needs. I've read plenty of help including ...
0
votes
2answers
221 views

Set current date i.e [Today] in a list column

I have a requirement where in user wants a column to be populated with Current date i.e Today. I went through many posts and found it is not possible to use Today() in list columns. The reason why ...
0
votes
0answers
35 views

Script File and Calculated Column Format/Data Types

This may be a bit of a best practices question, but today I made a few changes to the site/lists I'm developing to facilitate development and data rendering. In CEWPs I've begun using .aspx files ...
0
votes
1answer
152 views

Padding a numeric string in a calculated column

I need to pad a numeric string using a SharePoint calculated column. I have two fields, Sectiontxt and calcPadNum. For example, if a user enters 1.12.1 into Sectiontxt, I want calcPadNum to be 011201. ...
0
votes
1answer
174 views

Calculated Column formula returns syntax error

Found this one that seems to be the solution needed but i cant get it to work: Column1 has the value of BD122 Formula: =EXACT([Column1], "BD122") Expected result: Compares contents of Column1 and ...
0
votes
2answers
68 views

Writing an expandable conditional column formula

ModuleNum&"."&SectionNum&"."&Sub1_SectionNum&"."&Sub2_SectionNum&"."&Sub3_SectionNum&"."&Sub4_SectionNum&"."&Sub5_SectionNum&"."&Sub6_SectionNum ...
0
votes
1answer
761 views

Why can't I get this calculated field to work?

I'm trying to create a calculated column (text) which contains a combination of 3 other columns. I've asked another similar question but that was a different subject - now I'm trying to do this in a ...
1
vote
0answers
62 views

Calculated Fields and language packs

We are programmatically deploying a calculated field in a Sharepoint 2010 website using a site collection feature. Now we need to add localization support for a number of diff languages, so we had to ...
0
votes
1answer
310 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
48 views

Need help with a formula

I need some help. I have created a pretty extensive list at work for my colleagues to use to track financials on some of our projects, I am using a formula one of the project managers had established ...
1
vote
0answers
209 views

Calendar Start and End Dates not correct

I am having trouble with out SharePoint calendar. I have some calculated columns set up to display start and end times for anything that is not an all day event (based off the guide here), but some ...
0
votes
0answers
119 views

Calculated column with formule in visual studio

I am creating calculated column through content type in visula studio.But the Formule is empty when i check in the calculated Column. Can any one help me .Below is the scenario which i have tried. ...
0
votes
0answers
46 views

Calculated Column returns excessive amount of zeros

In a Purchase Order form I'm putting together, I have line amount and total amount as calculated columns. However, when displayed in the InfoPath form, they show with a ridiculous amount of zeros at ...
1
vote
0answers
60 views

Display number of events per day in SharePoint 2007 Calendar

I have a SharePoint list which contains project name, start date, and due date. I have created a SharePoint calendar based on this list that displays the contents of this list in a calendar format. ...
0
votes
2answers
847 views

Autoincrement a field based on ID

So I'm trying to autoincrement a field on a list item. First i tried using a calculated value field "=[ID]" which works the first time, but after saving a new item to the list the "[]" are gone and, ...
0
votes
0answers
138 views

Displaying Calculated Form in EditForm

I have a calculated form that concatenates 3 fields. These fields are editable in the new form but in the edit form I've used Javascript to set them as readonly. What I'm hoping to achieve is to ...
1
vote
4answers
607 views

Duplicate Groups Showing when grouping a calculated column

I have recently upgraded our 2007 envrioment to 2013 and afterwards a few of our libraries are having trouble grouping on a calculated column. The year column is calculated using the following formula ...
0
votes
2answers
332 views

Get Elapse time from Created and Modified Columns

I'd like to created a calculated column which subtracts the modified date/time from the creation date/time, is this possible? EDIT: This worked for me - =TEXT(B2-A2,"h:mm:ss") replace the cell ...
0
votes
3answers
339 views

Automatically add value to column of new list item?

How can I automatically add a value to a column when making a new list item? Like, if I make a new item in a list named "Announcements", and I want the "Expires" column to automatically get a date 3 ...
0
votes
4answers
3k views

get the month from a date column with the calculated column

I am trying to get the month from a date field with the help of calculated column. However I get this syntax error whenever I want to submit the formula: Error The formula contains a syntax error or ...