Tagged Questions

2
votes
1answer
39 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 ...
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
140 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 ...
0
votes
1answer
88 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
124 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 ...
1
vote
1answer
121 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 ...
1
vote
1answer
284 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 ...
1
vote
1answer
661 views

Conditional Sum of Data in Another List

I have two lists 'Projects' and 'Tasks' where 'Tasks' are associated with 'Projects' with a lookup column. On the Projects list I would like to display the sum of all of the 'Actual Time' values (a ...
3
votes
2answers
2k views

How to set the Default value of a Date/Time column to next Friday?

I did some poking around in the documentation for Calculated field formulas, but I don't see anything that would help me do this. Does anyone know if it can be done? Can you point me in the right ...
0
votes
1answer
73 views

set several list columns based on portions of document name seperated by an underscore

If I have a docuent library that has a documents in it using the following format: Region_Division_Store.pdf ...notice the underscores. I also have three columns named Region, Division, Store. ...
1
vote
1answer
3k views

Using an Additional Lookup Column Value in a Calculated Column

I have a lookup column based on another list's description (a 'Category' list) and have ticked the other list's 'Category ID' column to be shown at the same time (I note that this is a manually ...
3
votes
2answers
978 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
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 ...
5
votes
4answers
2k views

calculated field - formula for ageing

Again a calculated field question, How can I create a calculated field to find out, what is the age of the entry. In the list I will have a created date field, from that I would like to create a ...
3
votes
1answer
2k views

Calculated field Date formula

I have a date field, and it has the date in the format - 11/2/2011 11:40 AM How ever my requirement is to get the date in the format - 02 Nov 2011 11:40 AM For that I created a calculated field for ...
2
votes
3answers
3k views

Creating CASE statement with Calculated Column

I am using SharePoint 2010. I added a new Column and made it a Calculated Column. Now I need to place a CASE statement in my Formula. Something like this... CASE when [Region1] = 'A' and [Region2] ...
1
vote
1answer
2k views

Reference a hidden column in a calculated column

In SharePoint 2010, I have a document library in which I want to add a calculated column, which references the Name of the document. Entering the following formula works fine: =[Title] But I can't ...
3
votes
2answers
3k views

How to find out the number of the week in a calculated field?

How can I calculate the number of the week based on a date in a list? I tried several examples I found on the internet, but none worked correctly? The formula should comply with the ISO standard ...