-1
votes
0answers
25 views

Calculated Field - Based on Drop-Down Field, Populate Multiple Lines of Text Field

We have a list that looks like this: **ID # File Name Confidential Redact** 001 XXX_SOC Confidential We need to have the redacted multiple lines of text field auto-populate ...
0
votes
1answer
43 views

Conditional Formatting using Calculated Column as Condition (SharePoint Designer 2010)

I want to use conditional formatting to change the color of a row based on a Calculated Column. I know I could do this with a CEWP but I would prefer to do it in SPD 2010 because I am new to ...
1
vote
1answer
53 views

Example of a workflow pulling lookup column data for use in a calculated value column

I'm looking for an example of a workflow using SharePoint Designer 2010 that pulls information from a lookup list or via a lookup column and places it within a hidden field for use in a calculated ...
1
vote
1answer
33 views

How exactly does =[Me] work?

I've read that in 2010, using 'volatile columns', like [Me], isn't encouraged. Though this functionality is needed as a default value for a column separate of Created By or Modified By. However, when ...
0
votes
0answers
21 views

Calculated Column display formatting html in display form and in excel [duplicate]

I am struggling a little with calculated column. i have put the following formula with html in Calculated column. =IF([Gross Impact]*[Gross probability]<=3,CONCATENATE("<DIV ...
0
votes
1answer
99 views

How to set a column value based on another column value

I have a sharepoint list which contains a drop down of the values , Immediate , Hire , Specific I have another column Grace Period which is a numeric When the drop down column Immediate is selected ...
1
vote
1answer
104 views

SP2010 Javascript Object Model: programmactially add calculated column to list

I am building lists and adding fields via the following. I am wondering if I can add a calculated field and how you set the formula in this (or another method): function onCreateRootCause() { var ...
0
votes
0answers
45 views

Conditional formatting not updating on calculated field

I have a calculated field with the following formula: =WENN(Fälligkeitsdatum<=HEUTE();"RED";WENN(Fälligkeitsdatum<=HEUTE()+4;"ORANGE";"GREEN")) For understanding purposes: Fälligkeitsdatum = ...
0
votes
1answer
72 views

Calculated field with images and multi-value column

Say I have this list that looks like this: Title Link ----- ----- Cat /animals/cats.aspx Dog /animals/dogs.aspx Duck ...
0
votes
1answer
152 views

How to add a calculated column which shows the modified date/time of an attachment?

I have a list where each item has an attachment (or in some cases 2 attachments). I would like to add a "Last modified" column in a view which shows the date/time of the last attachment modification. ...
1
vote
1answer
69 views

Calculated Column - # of Unique Values Within Column

I have a time off calendar. What I would like for a column to do is count and update the number of unique values for that day. Here is an example: Day Off ||||| # of Values 12/1/13 ...
1
vote
1answer
122 views

Have calculated column return boolean

I have a calculated column which I have set to check if another column is blank or not. I have a webservice which looks into this list and should return true or false if the column is empty or not. ...
0
votes
1answer
245 views

Why can't I get this calculated field to work?

I'm trying to create a calculated column (text) which contains a combination of 3 other columns. I've asked another similar question but that was a different subject - now I'm trying to do this in a ...
0
votes
4answers
239 views

Cascading Dropdown / Combo box in SharePoint List

I want to create a custom drop down combo box, which should show information based on selection of previous combo box. Just like we can do it in Excel. However, I do not want to do any coding in the ...
0
votes
1answer
144 views

Programatically populate custom list column

I have a list definition project (schema.xml, etc.). I would like to create a computed column that's available for grouping, but not have the computed value from a CAML query, as it's going to be ...
-1
votes
2answers
65 views

Add calculated column data with decimals

Is there any way to sum all values in one calculated column without losing decimal data? We're using an XPath expression and it loses all decimal information. Where @myField is one calculated column ...
0
votes
2answers
70 views

Calculated Column name of company

I've a little problem. We've a document library and in this library every subcompany can upload their documents. Now I want a column where the name of the subcompany is displayed after the document ...
0
votes
2answers
409 views

Sharepoint Document Library - Choice Column Default Value Calculation

I have a Shared Document Library with a choice column with 3 choices: Test1, Test2, Test3...now I also have 3 views, one for Test1, Test2, Test3, this is because I have three pages where I want to ...
2
votes
1answer
190 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
617 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
57 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
265 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
328 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
771 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
236 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
904 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
953 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 ...
4
votes
3answers
4k 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
89 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
4k 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
1k 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
2k 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
3k 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
4k 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 ...
3
votes
3answers
6k 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
3k 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
5k 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 ...