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

Calculated fields

I'm working on a SharePoint 2010 solution and I am trying to add a calculated column to an existing list. The column should display rendered html, but displays html encoded html. This problem occur ...
0
votes
1answer
46 views

Creating a KPI based upon multiple variables in a list

I have a list with the following dimensions that I am interested in developing a KPI for each user. For example, I have User1, User2,...User(n). Each of these users will have to develop certain ...
0
votes
1answer
80 views

Unique Validation on Calculated Column

I have 2 columns (first name and last name) in a SharePoint custom list. I have a calculated column called "full name" just concatenates the first and last name columns. Due to requirements, I need ...
0
votes
1answer
139 views

Calculated Field from another Sharepoint List

Relative newbie to Sharepoint Lists so please bear with me. I have 2 Lists that I need to work together to provide a bit of help to my Service Desk colleagues. List A (Tickets) FIELDS: Ticket ...
0
votes
0answers
62 views

Copy calculated column to another column in same list

I have a list with the columns rID, requestID and some other columns. Here rID column is type number and it will set the value from workflow. requestID is type calculated column and starts with some ...
0
votes
0answers
78 views

Calculated Field with Multiple Columns

Thanks for providing this website as a resource. I am needing some help with coding a Calculated Field. I have 4 columns that all have an answer of Displayed or Not Displayed. In my calculated ...
0
votes
0answers
23 views

SharePoint 2007 - column behaviour

There are few columns in task content type which are calculated, the hyperlinks to edit these columns are disabled, and hence cannot go to managecontenttype.aspx by clicking on the colmumn names in ...
0
votes
0answers
44 views

How to add a Sum, Avarage to Calculated Column

I must add an Avarage field to Calculated Column. How could I add an Avarage sum to Calculated column. When I tried to add by the View, the View doesn't see calculated Column.
0
votes
0answers
36 views

SP 2010 TEXT Function Subtracting 1 hour

I have a calculated column on a calendar that just formats the start time of an event. I am just using the TEXT function to format the time as hh:mm but for some reason the output of the function is ...
0
votes
1answer
54 views

How do i Generate different calculations depending on what item is selected in drop down box?

Hi guys I am making a SP 2013 site and am currently creating columns... I have a drop down column (Circuit Type) , four text fields (Num1, Num2, Num3, Num 4) and a calculated column (Loss). The ...
0
votes
1answer
59 views

Calculated date column not working

I have a list that show all our clients and a date column called 'Last Visit' and another date column called 'Next Visit' I then have a calculated column to work out how many days it's been since we ...
0
votes
0answers
40 views

SharePoint Designer workflow: Interval between the days is -0.7

My library having StartDate and DueDate columns, with one reusable workflow is associated. Using workflow Find Interval between days action, DueDate is updating with (days between Today and StartDate ...
0
votes
2answers
49 views

Average of columns where number is not null

I am completely stuck on pretty trivial matter. I have columns [ResponseTimeNumber],[CommunicationNumber],[PriceQualityNumber],[ResponsivenessNumber], ...
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 ...
0
votes
0answers
26 views

Passing Parameter to Site Page or Webpart or Solution of some sort on SP10

I have a Windows Application in Java that i would love to connect to a Mind(Application of some sort) in SharePoint. I need to pass some number-parameters to it and it then has to give me also a ...
0
votes
2answers
52 views

Lookup in SharePoint

I'm using Sharepoint 2010. I have a List "Discipline" with 3 columns Discipline Code Discipline Des.-Site 1 Discipline Des.-Site 2 A A1 ...
0
votes
0answers
47 views

Function to update date not working properly in list

I have a sharepoint list that calculates the expiration dates of items and does so by subtracting Todays date from the expiration date. In order for it to work properly, Today's date needs to update ...
0
votes
0answers
59 views

Can I create a list which counts the number of documents of a specific metadata type by the folder they are stored within?

Running SP2013 Foundation. My users interact by uploading documents to personal folders within a document library, selecting the type of document they have uploaded via a lookup column and SP list. I ...
0
votes
0answers
46 views

Calculated Colum to pull Image filename and add Network Path

I am working on a project that will have nice Web ready images in our SharePoint (online) site. Each one of the images also has a hi-res counterpart that is on a network drive. The filename is the ...
0
votes
0answers
273 views

SharePoint 2010 - Custom List - Sum of Group and display in Chart web part

I hope anyone out there will be able to help me :) I have to create monthly reports on SharePoint that show a count of something. The reports must include a grand total (corporate level) and sub ...
0
votes
0answers
71 views

Creating a Calculated Date Field with embedded double quotes

I have been provisioning a load of Site Colummns with PowerShell . I am however, having a lot grief with a calculated field spField.Formula = "=TEXT(DATE([Created],"mmyyyy"))" spField.OutputType = ...
0
votes
0answers
55 views

How to copy calculated field formula client-side?

I am trying to copy a calculated field value from SharePoint (using web services) Paste the field value to another field Problem is this: SharePoint seems to give me two wrong versions of the ...
0
votes
0answers
16 views

Can you have a seperate indicator field that lists columns when data is entered?

Is this even possible? I have a list for used for new employees to track what training they have completed. The list has the following columns; First name, last name, when they joined and the dates ...
0
votes
1answer
417 views

Calendar Overlay in sharepoint2013 programatically

I want to create calendar overlay in sharepoint2013 programatically using visual studio2012. Please help how to start with that. Happy Sharepoint!!! Regards, Aisha.
0
votes
0answers
15 views

Problem with filtering in a calculated value

I have a calculated value field, named Year1 = TEXT(mydate"yyyy") In allitems.aspx, if I select one year, it doesn't show anything. If I select two years, it show the results of the first year that I ...
0
votes
1answer
23 views

Display the column IDs for a column having same dates

I have a list with date column. Items having the same dates should store the IDs together. For eg: Item ID 1,12,15,etc. has the same date,then a column in these items should store all these IDs. ...
0
votes
0answers
392 views

how can we get the Current UserName instead of LoginName using calculated column in SharePoint 2013?

using [Me] as formula in column gives me current user login name. help me out if we can get the user name instead of login name.
0
votes
0answers
33 views

Calculated column help

I have a Column with Title like below "sharepoint Documents(sp2010)". Now i want to have a calculated coulmn that will have sp2010. I have tried like this it is working but it has the value like ...
0
votes
0answers
122 views

Updating a (calculated) field based on lookup field :: Workarounds

I am a site owner in SP2010 impl., at work. Not a farm admin / super admin. For one of my needs, I am designing a list using Datasheet View. I have columns of People, Lookup and Choice datatypes. ...
0
votes
1answer
59 views

Calaculated column to display the next 8 business hours

In one of the column I am having the current date and time based on that using calculated column I have to show the date and time of the next 8 business hours date and time. How can this be done?
0
votes
1answer
28 views

Display an image based on date range

I have a SharePoint list of devices that are checked out or reserved by a personnel. We check them out or reserve them based on the requested dates that has a start date to finish date column. How ...
0
votes
1answer
104 views

Can MIN and ISBLANK be used together in a calculated column?

I have a custom list that displays the expiry date of Certificate 1 and Certificate 2. Candidates must have both to be considered Certified. The Certification expiry date is the earlier of the two ...
0
votes
1answer
64 views

Display image based on task completion

I am trying to display a 'progress bar' on a page which includes 5 different images. I would like to create a workflow where the image would change based on the completion of tasks in a task list. The ...
0
votes
1answer
90 views

formula to select a choice column

I have two choice columns in a list : choice column 1: values 1 posible 2 unlikely choice column 2: values A bad B very bad and I want to select another choice column based on the previous selected ...
0
votes
1answer
28 views

Is it possible to report an activity date and calculate which pay period it falls under in a bi-weekly schedule

I really have no idea how to address this. I am tasked with marking and developing a way to track late entries based on the created date of a list item, the reported activity date(date selector), and ...
0
votes
1answer
222 views

How to render HTML/Plain Text to the filtering drop-down columns

I have a custom list, with some columns. In order to design my list with colors, I used calculated columns with a Content Editor Web Part which contains my script (JavaScript). I used this script : ...
0
votes
1answer
726 views

Folder name as calculated field

I've created a Library which consists of two Folder Content-types. Customer Prequalfication I'm looking to create a calculated column in the Prequalfication folder content-type which fetches the ...
0
votes
0answers
172 views

Content Type IDs help

I have 2 Content Types, A and B. I am trying to create Content Type ID's(not proper ID's) and completely separate from the ID already in the list. I am creating them as a calculated field but I cannot ...
0
votes
1answer
33 views

creating an ID using calculated value

I have 2 content types which I want an individual ID(unique for each item) for both, how would I go about creating an ID's for this. So each Content type has IDs 1,2,3,... etc. I am thinking the way ...
0
votes
1answer
48 views

SP2010: Help with calculated column for multiple columns

Sharepoint 2010 Looking for some help here as I'm sure its a simple solution. I have: 2 Yes/No Columns: DivisionA, DivisionB (I will have a total of 15 divisions but using 2 for an example) 1 ...
0
votes
1answer
24 views

Getting Calculated Filed Data into Links

I know I can make links with calculated fields; however, I am having a hard time getting the value of a column I need within the URL. Here is my code. I think I am close here but still having ...
0
votes
0answers
45 views

Calculated field from Sharepoint to Infopath

I created a list in sharepoint with some calculated field. When i modify the form through Infopath the calculated field doesn't contain the formula that i wrote in Sharepoint. For example: In ...
0
votes
1answer
47 views

Calculated column shows the value of another column, how in SP2013?

I have sharepoint 2013 portal. I have a list with some columns. Now I would like to add a new calculated column. In this column I would like to show the selected item in another column. This other ...
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. ...
0
votes
1answer
25 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 ...
0
votes
1answer
238 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
2answers
37 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
118 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, ...
0
votes
1answer
60 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
383 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. ...