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
1k 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 src='/_layouts/images/KPIDefault-"&IF(Completed="Yes",0,2)&".gif'/><...
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
291 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
410 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
152 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
79 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
468 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
4k 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
492 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
55 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
34 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
185 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 field,...
0
votes
1answer
49 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
456 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: =RIGHT(LEFT(SUID,INT(FIND("=",SUID)-1)),LEN(LEFT(SUID,INT(FIND("=",...
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
58 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
129 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: "(number(ddwrt:DateTimeTick(ddwrt:GenDisplayName(...
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
305 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
82 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
85 views

Average of columns where number is not null

I am completely stuck on pretty trivial matter. I have columns [ResponseTimeNumber],[CommunicationNumber],[PriceQualityNumber],[ResponsivenessNumber], [CompetenceNumber],[CommunicationNumber],[...
1
vote
2answers
11k 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
54 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
59 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
123 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
115 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
3answers
3k views

Calculated Column to change text color in a custom list

I have created a custom list and with a column called Account, the column is a dropdown list and with following options Hourly Silver Gold I would like the options above to be bold and be certain ...
1
vote
0answers
44 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 Time]...
0
votes
0answers
114 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
453 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
253 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
80 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
36 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
735 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
129 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
25 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
889 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
875 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
767 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
598 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
3k 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
67 views

Calculated 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?
3
votes
1answer
209 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
240 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
76 views

; or , in calculated columns

The separator is related to the language settings. Rule of thumb: of the decimal separator is a . (dot) then the parameter separator is a , (comma) So most non-english languages have the , (comma) ...
0
votes
1answer
36 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 ...