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.
0
votes
1answer
317 views
Can sharepoint calculate the number of “business hours” for a list item to be completed?
I work in financial institution and we want a column in a case management database to show the number of "Buinsess hours" from start to finish of a case.
Business Hours
Monday to Friday 5am - 8pm
...
0
votes
1answer
748 views
How to match current user to a username column with Calculated Columns?
I have a list view that should only show when an admin adds the person's username to an "allowed viewers" username column. So, I am thinking to create a calculated column that compares the ...
0
votes
1answer
32 views
Calculated columns, columns names and localization
I provision a list in SharePoint 2010 with two date fields: one for a start date and one for an end date. I would like to add a third column for the duration.
Naturally, I could add a calculated ...
2
votes
1answer
34 views
Color coded background on calculated column using Designer
I am aware of the various methods to colorcode columns (jquery, formula) I choose here to use designer on allitems.aspx on a list (im lazy and its easy).
I have given various columns background ...
1
vote
1answer
31 views
Calculated column is not being crawled
I have a calculated site column AlertSortOrder, which I added to a list. I created a managed property nvAlertSortOrder (sortable, searchable, queryable, retrievable) mapped to the corresponding ...
2
votes
1answer
37 views
Calculated Value of “Start Time” in a calendar is not working
I am having a problem with a content type-specific, Reusable workflow. I use it for a calendar. When ever an event is created, I send an email to the approver with Name of the event, start time and ...
0
votes
1answer
389 views
Have an Association Column equal the field of another Column
I have created an association column as part of a reusable workflow in SharePoint designer. I am now trying to have this column equal the field of another column in Document Library.
I have tried ...
1
vote
5answers
4k views
how to show HTML code in column?
how can i force sharepoint2007 (MOSS) to interpret HTML code instead of showing it?
I have a column which calculates a yes or no (depending on other columns) within a HTML (i want to show images ...
0
votes
0answers
11 views
SharePoint 2007: Calculated column - formula for calculation based on column containing NA
In a SharePoint list, I have 6 numeric columns that can contain numbers in the range (1,4). However, one or all of these columns may contain "NA" value.
There is a separate calculated column which ...
1
vote
1answer
528 views
How to convert date field in single line of text using Calculated columns
I have created a calculated field for a content type in my Sharepoint 2010 and I want to return a date in the TEXT format because I am returning some text with it. The condition I have put in the ...
1
vote
2answers
1k views
How to apply CAML query on the Calculated Column of the list?
I have a calculated column that stores the calculated date value.
When I apply the CAML query, it does not return any row even if the record exists.
Can any one please guide me on this topic>
...
3
votes
2answers
967 views
How to calculate business days excluding Thursdays and Fridays given between two dates?
How to get the business days excluding the weekends (Thursdays and Fridays) in between two given dates? Given dates are two list columns (Start Date & End Date) and business days is a calculated ...
1
vote
3answers
42 views
Calculate the difference between system columns Created on and Modified on
I'm trying to create a new column in a shp list that contains the difference in days between two other columns in that list. These two columns are the custom list columns that contain the date Created ...
0
votes
1answer
37 views
Making a Request form that pulls from Calculated Columns of other list
I'm new here (first post).
I have already read the great articles on this page but never posted until now.
I am looking for some guidance on this and hope you experts can help me.
Overview: I want ...
1
vote
1answer
25 views
Is there a way to determine if there is an attachment in a calculated column?
I'd like to have a column display "Yes" if there is an attachment to the sharepoint list item, or "No" if there isn't one. Default would be no, but then if they edit the item to add an attachment, I ...
0
votes
1answer
18 views
Calculated Columns: Returning a value depending on parent curency column value
Morning all,
Here's what I'd like to achieve and I'm hoping that you fine folk can help me with this.
I have a currency column in a customised list, with values ranging from £1k - £20k. I'd like to ...
0
votes
1answer
19 views
Summing up the numbers based on a particular column value in a list
I have a list which displays the leave history of the users in a department.
Now, I want to consolidate the data in this list in such a way that I want to calculate the total number of leaves availed ...
0
votes
0answers
18 views
Calculated column formula to exclude business days but is dependent on priority level
I have a calculated column titled Due Date that pulls from 2 columns: 'Priority' and 'Date added'.
Formula:
=[Date added]+[Priority]
FYI, the priority column is populated with days allowed for ...
2
votes
3answers
77 views
How do I apply a calculated column to new items only?
I have a formula in a column that calculates the target date of + 3 months. I want to change the formula to +9 months but only for new items. How do I add this to the formula?
=IF([Type of ...
0
votes
0answers
62 views
Designer Workflow: “Find Interval Between Dates” action not working
I am testing a default SP Designer 2010 workflow action called "Find Interval Between Dates" located under the "Utility Actions" category. I need to compare the amount of time passed between the ...
1
vote
1answer
134 views
sharepoint date column calculation
This is my first day using SharePoint and I was lost in trying to figure out how or if it can be done, custom column calculations, and if code is allowed in SharePoint? I am using SharePoint 2010. I ...
3
votes
5answers
8k views
How do you Sum a Calculated Column?
I have a calculated column in a list and I would like to get a sum of that column in the view. I can't use datasheet view, and I don't like the idea of a workflow because the user only sees a few ...
1
vote
1answer
36 views
Getting Null Value with two statements in additional column settings
I am trying to subtract column "Previous Spend" from column "Current Spend" and put the balance in new calculated column named "Incremental Spend". Easy enough right. But if "Previous Spend" is left ...
1
vote
0answers
136 views
Calculated columns supporting all column types
I would like to develop a column which will allow the end user to do the calculations based on values of other columns of the same item (SharePoint 2010). I need it to work also with people, look up ...
1
vote
2answers
258 views
Sharepoint list If formula
I have a column that needs to return the value of another column based on if the value in a third column = S
1
vote
2answers
183 views
Issue with a Calculated column
I have in a list with multiple content types calculated column with this formula :
=if(
...
1
vote
2answers
105 views
Sum of a column by month using a Calculated Column
Here is the background to my question. We are uploading field data about various moth species caught by trap. These traps are checked every month, but not always on the same day of the month.The ...
0
votes
1answer
43 views
How can I get a daily hour value from a date/time field?
I am trying to calculate the amount of time on a daily basis.
Currently I have calculated "[total hours per diem]", "[total days]" and the time values (if not split over multiple days).
Where I am ...
0
votes
1answer
135 views
Calculated date column to take into account working days
In my SharePoint list I have a default due date of
=Today+10
How can I get this default date to be 10 working days from today?
I'm not too worried about taking into account public holidays etc, ...
6
votes
2answers
10k views
Using calculated field to retrieve substring of another field
Suppose I have a field that contain the following data:
==========================
| Email Address |
==========================
| Jack@wonderland.com |
| Peter@nobodyland.com |
| ...
0
votes
1answer
86 views
Running Retention Policy from Custom Calculated Column
I have a calendar list in which to post deadlines. I need a reminder to be sent out two weeks before the deadline, so I am trying to put in a retention policy.
To measure the date to activate this ...
1
vote
1answer
118 views
Calculated Column to Calculate Date
I need a column that contains the "Warning Date", which is two weeks prior to the expiry date. I am new to calculated columns so am not quite sure how to go about this.
Any help is greatly ...
0
votes
3answers
63 views
Modifying a calculated column gives different errors
I have site column with the following formula:
[AmountLeftToPay]/([AmountAssigned]-[AmountReleased])
The problem is the division by zero, sometimes it shows on list items #DIV/0!
So I wanted to do ...
0
votes
0answers
145 views
Sharepoint 2007 DATEDIF error on negative numbers
I am creating a list to determine how long it is taking to review a document. I have a column named Due Date and a Column named Review Complete.
I want to calculate the difference between the two. ...
0
votes
4answers
793 views
Trouble with IF formula
We have a task list with a column that categorizes tasks into one of 12 categories. We're trying to calculate a NEW column that will be populated with one of two values, "Technical" or "Procedural" ...
0
votes
1answer
44 views
How to use percent in calculated column over another calculated column
I want to create a calculated column which will calculate percentage over another calculated column. E.g.:
I have three columns: ColA, ColB (=ColA-12%), ColC(=ColB-10%).
The problem is, that ColC is ...
2
votes
1answer
113 views
Calculated datetime column returns string;# in search index
We have a calculated column, that results in a date. It's output type is set to DateTime - Date only. When we run the search indexer, it shows up in "crawled properties" as a Text-column, and in the ...
1
vote
3answers
1k views
Calculated field - Get Modify Date when a Particular Column is get Changed
How to get a calculated field with modify date, when one field or column changes in the share point list.
For example, If I have a field status, i should get a modify field populated with today's ...
0
votes
1answer
127 views
Calculated Column Incorrect when All Day Event is selected
I've created a Calendar list. I've added a single calculated column ("Calculated Start Time") that simply references the "Start Time" column. It reports the correct date when the event is not an all ...
1
vote
1answer
87 views
SP2013 : Generate an autoincrement identifier (YYYYMMDD9999) based on creation date for a document
I need to generate a record id for a document, with format YYYYMMDD9999 where 9999 is a autoincrement number per day. This id must of course be unique, but i have no idea how to be sure to avoid ...
0
votes
0answers
46 views
2 variables = 1 Calculated Column
I have 2 list columns developed in my SharePoint form; country origin (CO) & country destination (CD) for the form requester to radio button (CO) and pull down and pick (CD). CD has two options: ...
1
vote
1answer
119 views
Error with special characters in site column names referenced by a calculated column
I have a site column Construction - Complete Date which is used by my calculated column Construction - Is Complete?. Whenever a date is entered for the Construction - Complete Date then Construction ...
2
votes
2answers
260 views
Calculated column to Split text
I need to split column into two columns
Column1: SHPS011SSAD
Column2: SH
Column3: PS
What would be the calculated formula for this?
2
votes
3answers
2k views
Calculated Column colour coded result
I have created a list on our new company sharepoint to track monthly sales orders, a kind of very basic sales pipeline if you will.
In our list we have "Sales Price" and "Cost Price" columns and from ...
1
vote
1answer
106 views
Document Path as View Column
I have a library that contains documents and folder. I would like to have a view on this library that shows every document and includes the path to that document.
For instance the following:
Folder1
...
1
vote
1answer
51 views
Calculation field randomly forgets ID
I have a calculation column that I use to display some HTML code that provides a hyperlink in a List view. The user clicks on the hyperlink to jump to another page which will generate a report based ...
2
votes
1answer
505 views
Calculated Hyperlink Column - Lost ID-Field Value Upon Editing
I created a calculated column with the following formula:
="<a href='../X_C03 Staff Members/DispForm.aspx?ID="&ID&"'>View</a>"
and included this into a view. The column works ...
1
vote
1answer
274 views
Calculated Column left align header
In my list, I want a column to have a custom hyperlink.
I create a Calculated column that has the following formula.
="<a ...
0
votes
1answer
179 views
How to create a Project Tasks List view for Overdue tasks?
How do I create a dedicated view to display only the Overdue tasks based on three columns. Start Date and End Date (Actual End Date) and Target Date (projected completion date)
Target Date - Start ...
1
vote
1answer
144 views
Adding nested IF statements
We have a company page to track mileage on company vehicles, and at the end of every month the driver enters the ending odometer reading. I wrote a formula to figure out the mileage for the year by ...
