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

1
vote
0answers
83 views

Sum and then divide columns

So I have a list in which a column needs to be summed up, then grouped so I can create another column that allows me to do division off of the summed total. So for instance John Doe 1 - 0 - 1 John ...
0
votes
2answers
956 views

Using a calculated column from a lookup list

I am working with SharePoint 2013 at a hosted site (not Office 365). Most of the questions I see when I search relate to including a lookup field in a calculated column. That is not my issue (but it ...
1
vote
2answers
108 views

Combining two column conditions in calculated column

I have a task list which has color coding for Progress Bar and Task Status based on % Complete and Status column values. I have one more additional condition for: IF status=Blocked then whatever the % ...
0
votes
1answer
350 views

SharePoint 2010 - Calculated Column w/ Hyperlink & IF Statement

I am having some trouble getting this to work. I need to create a hyperlink in a column and learned that if you put some html into a calculated field and format it as a number then it works. For ...
0
votes
1answer
121 views

Change HTML page title to calculated column for custom list

I have a custom list called Customers which contains, columns First Name, Last Name and Full Name. Full Name is a calculated column which concatenates the first and last name values. Currently, when ...
0
votes
3answers
153 views

2010: Calculated column multiple if statements

Currently, I have a formula to execute some number stripping for a column. When the user uses a card swipe, it outputs something like: ;502780133=0444? The formula strips the semicolon and removes ...
2
votes
2answers
915 views

Sharepoint KPI using calculated columns

I am trying to create a KPI for the tasks schedule we have on a calendar. The formula I have is: "<div><img ...
2
votes
2answers
1k views

Calculate Field with a Lookup Additional Column

Would like to ask some suggestion if i have 2 lists (Vendor List & Order List). Where Vendor List is contain with name & discount fields And i create new list "Order List" with field Items, ...
0
votes
2answers
205 views

Calculate 90 Days

I am using Sharepoint 2010. I have a list, I will like to I.D. all files passed 90 days. What is the formula for this action?
0
votes
3answers
346 views

Single calculated Site Column for multiple content types

I have a list with three content types. I need to have a calculated status column in items for all three content types. The status calculation formula is different for all the content types. Since ...
0
votes
2answers
134 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
67 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
343 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 ...
3
votes
2answers
3k views

lookup column in calculated column formula

I have a Lookup column(Discountfirst) which has Number. I also have another Calculated column(Finaldate) with Resulttype DateTime. One more column(DateofReceipt) in Date. My Calculated column formula ...
0
votes
1answer
454 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 ...
1
vote
1answer
53 views

Searching between two separate lists for matches

I have two SharePoint Lists each with a column called Unique Key, what I need to do is search list B for matches in List A. List B is the larger of the two and each List contains only unique entries ...
2
votes
1answer
30 views

Calculated column on SharePoint List

I use SharePoint 2013 FDN List for a basic IT Helpdesk - I'm looking to created a calculated column that can measure time it takes for a case to be closed. Date Created and Status = Not Started TO ...
0
votes
0answers
144 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
48 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
301 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: ...
2
votes
4answers
2k 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
49 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
39 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
56 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
110 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
1k 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
255 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
81 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
2answers
76 views

Average of columns where number is not null

I am completely stuck on pretty trivial matter. I have columns [ResponseTimeNumber],[CommunicationNumber],[PriceQualityNumber],[ResponsivenessNumber], ...
1
vote
2answers
9k 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
51 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
30 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
57 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
110 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
107 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 ...
1
vote
0answers
42 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
97 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
361 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
182 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
72 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
1answer
34 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
2answers
3k 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
2answers
634 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
2answers
117 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
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
800 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.
1
vote
2answers
754 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
660 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 ...
1
vote
2answers
509 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
2k 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 ...