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
0answers
16 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
1answer
31 views

Whats wrong with this calculation?

Hi I tried add a column via calculation, and it seems to not be correct because I keep getting a syntax error.. Can anyone tell me why or where I went wrong? This is a dropdown box when a certain ...
1
vote
1answer
21 views

2010 - Changing #VALUE! error in Calculated Column

I have a calculated column called SUID # that pulls the value from a single line text input called SUID. The formula in SUID # is: ...
0
votes
0answers
16 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 ...
2
votes
4answers
58 views

Calculated column that updates daily

Is there a way to make a column in a list that updates daily with the current date? If not what's the best way to do this? I was thinking of using the 'Lookup' field to link to the calendar that's on ...
0
votes
0answers
18 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
21 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
41 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 ...
1
vote
2answers
26 views

Hours and Minutes calculation in Dataview webpart

I have a DataView Webpart, to display XML data using XML File connection. I use the below formula to calculate the day difference between 2 dates: ...
0
votes
2answers
63 views

Set default date based on date other date column

I'm fairly new to SharePoint and I'm still learning the terminology so please excuse I have 2 Date Time columns in a SharePoint list, Date Received and Due Date. The Due Date is supposed to be 30 ...
0
votes
1answer
31 views

How do I have a workflow update a field/column in the current list(InfoPath created list)?

I have a column with this formula: =YEAR(Created)&"-"&(ID) , the YEAR(created) part works as intended but the ID part doesnt. It often shows only 2014- but it should show 2014-50, the 50 beign ...
0
votes
1answer
39 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
16 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
28 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
1answer
29 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
32 views

Calculated column colours

I have a list with a column called Client Satisfaction which is a choice field with the following 1 2 3 4 5 6 7 8 9 10 I would like a calculated column to make any number between 1,2,3,4,5,6 red, 7 ...
0
votes
0answers
19 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
41 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
19 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 ...
1
vote
0answers
28 views

Update SharePoint calculated column on Infopath form

I have an Infopath 2010 list form that displays a couple of calculated columns. My users have asked if I can make those fields update dynamically while the form is open. I have already tried moving ...
0
votes
0answers
39 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
33 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
166 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 ...
1
vote
0answers
24 views

Calculated Field formula for triggering the task 15 minutes before the starting time

I need to use a calculated field in order to trigger before 15mins of the task starting time. Please let me know what is the formula that I can use for this. Is it something like below? =[Start ...
0
votes
0answers
37 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 = ...
1
vote
4answers
138 views

How to update calculated column on a daily basis without admin rights?

I am running SharePoint 2013 and have a column that is supposed to determine whether or not each phase of a project is late. I am using the NOW() fucntion, which, of course, does not update ...
0
votes
3answers
30 views

How can I sort this by an actual DATE?

I have a calculated field in a document library that takes the "Modified" property makes a more readable date from it. The problem is, the column is now sorting alphabetically, even though the data ...
1
vote
1answer
45 views

Calculated Field to index a String

How do I get the substring ABC from following string Hello(ABC). I used right and left function with no success
0
votes
0answers
31 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
1answer
26 views

Validation Formula

I need help with a formula that will return true only when ( category <> "red" ) OR ( category = "red" AND EmployeeName - a people picker field - is not empty ) Thanks very much !
0
votes
0answers
11 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
158 views

Calculated Column with ISBLANK

I am trying to obtain a calculated column with ISBLANK =IF(ISBLANK(AuthorTxt) , Title , Title + " " + AuthorTxt) as suggested here but I get a syntax error or not supported formula message. Why ...
0
votes
1answer
95 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
11 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
2answers
46 views

Speedometer gauge using calculated columns?

My idea is implement a speedometer gauge at the top of my page that will change dynamically based on the average of a column, what i'm thinking is to use three speedometer images (low/med/high) and ...
0
votes
1answer
21 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
80 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
32 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 ...
1
vote
2answers
154 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 ...
2
votes
2answers
76 views

the IF(OR) statement

I am trying to nest 6 IF(OR) statements in SP 2007 for a calculated field in a list - But it seems as if it is getting too long, and I get the syntax error thrown at me. I tested half of the length ...
0
votes
0answers
95 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. ...
1
vote
2answers
114 views

Validate a Single line of text column type of list in sharepoint 2010 to accept only alphabets?

How to validate a Single line of text column type of list in SharePoint 2010 to enter accept only alphabets? no special character and no number should be allowed in that field.
0
votes
4answers
165 views

Calculated Column [Today] work around?

Ive been doing alot of reading into getting [Today] to work within a calculated column but im starting to wonder if theres a better solution staring me in the face Basically we have an asset register ...
0
votes
1answer
55 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?
2
votes
1answer
63 views

Duplicate filter values in a calculated column

I have a document library with a calculated column. This document library is populated from a windows service. Every time a new document is added, the calculated column has a formula to choose ...
0
votes
1answer
44 views

Count Column in SharePoint List

I am trying to add a column that counts every time a date column is amended past the current date stored by more than 7 days. Column A would be a Project Live Date which isn't a fixed date column so ...
1
vote
0answers
49 views

; or , in calculated columns

I can't understand the choice of the separators in calculated columns. I'm using SharePoint 2007 (MOSS), and I wrote a calculated column in order to extract the month name from a date. I used this ...
0
votes
1answer
25 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 ...
2
votes
1answer
247 views

Use calculated column to add target“_blank” at the end of a Web field URL

It appears I cannot configure a hyperlink column to open in a new window. I read in this post that you can concatenate a hard coded url with the title field of an item to achieve this. However, that ...
1
vote
1answer
425 views

How to fix [today] and [now] in a list

I have the following issue: we use a SP list to send information through the steps of the process. On each step somebody adds information into the list, next person receives it, adds his own part of ...