1
vote
2answers
36 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
54 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
0answers
34 views

Change calculated column to xsl:value-of select

I work with a calculated column which depends on the title column. Now i want to change the cascading title inot the filename. This should be done with the SP designer and a customization of the xslt ...
0
votes
0answers
37 views

Calculated field from Sharepoint to Infopath

I created a list in sharepoint with some calculated field. When i modify the form through Infopath the calculated field doesn't contain the formula that i wrote in Sharepoint. For example: In ...
0
votes
1answer
641 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
70 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 ...
0
votes
1answer
1k views

How can I use data from Managed Metadata Columns in Workflows and Calculated Fields?

It seems that sharepoint does not allow MM columns to be used in calculated fields, and I'm not sure how to use them in a workflow either. Can someone please inform me as to how I can use terms in the ...
1
vote
3answers
306 views

Auto-populate Sharepoint list based on most recent list item in another

Can anyone help? I want to be able to auto populate a field within a SharPoint list based on the most up-to-date field within another list. . List Details Projects List - List of projects. Fields ...
0
votes
1answer
44 views

Sharing a calculated value between lists

I have to create two separate lists. One list is an overall master table of data, the other is a list that shows the total for selections on the master. What I need to do is to calculate out the ...
0
votes
1answer
161 views

How to give autonumber to item list but every day start from 1

How to give autonumber to item list but every day start from 1? I would like to achieve that every day counter(or with out counter) of item list will be reset and first item in day will give 1 and ...
-1
votes
2answers
88 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
111 views

Calculated Column Formula

I have 2 Drop Downs Month Date In Month Column dropdown I am displaying Jan, Feb, March, April, May, June, July, August, Sep, Oct, Nov, Dec In Date Column dropdown I am Displaying 1, ...
0
votes
1answer
82 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 ...
0
votes
1answer
1k 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 ...
3
votes
4answers
5k views

How to resolve full names from a Person or Group column (that contains multiple entries) in a designer workflow

I have a custom list with a custom content type, with a workflow, on SharePoint 2007 as outlined in this other StackExchange question. I'm using a Person or Group typed column to contain a list of ...
2
votes
1answer
3k views

How to make SharePoint 2010 calendar view Time Sensitive!

I am trying to create Dataview Webpart for SharePoint Calendar Events to display [Today] items. I was sucessful on that, my next challenge is how to make it time sensitive. I want to display events ...
0
votes
1answer
627 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
1answer
819 views

Substring-after or similar to extract ID from a URL?

I'm using a script-based solution to add a Comment Box to dispform.aspx in a MOSS document library. The comments live in a separate list and I have a requirement to show the Name metadata from the ...
1
vote
1answer
804 views

How to Retrieve Numeric Column value from SharePoint List

In the SharePoint list I am having the numeric column and the value is like this 123,456,789,012,346,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000. I am using SPQuery to retrieve items ...
3
votes
1answer
1k views

Unescape HTML from list column

I've got a multiline column in a list that contains HTML. When trying to use the field in SharePoint Designer 2010, it shows it as raw HTML, instead of rendering it. So using this syntax: ...
2
votes
1answer
521 views

How do you insert a column using the column editor in sharepoint designer 2010?

I would like to create a new calculated column in Sharepoint Designer 2010. So, IN SPD 2010 / Site columns, I click New, Calculated column, fill in the details and click OK. Up comes the the Column ...