Using Calculated Field – Nested IF Statement in Sharepoint list

I was trying to convert this lookup table in the excel sheet to a SharePoint list. Basically, The column C1 (Choice of 1 to E) and C2 (A to E) together determine the value of Column C3 (Let’s say). The lookup table given below provides the reference for the Column C3. 

 

The nested IF statement using the calculated field did the trick.

 IF(OR(AND(C1=”A”,C2=”A”),AND(C1=”A”,C2=“B”), AND(C1=”A”,C2=“C”), AND(C1=“B”,C2=”A”), AND(C1=“B”,C2=“B”), AND(C1=“C”,C2=”A”), AND(C1=”A”,C2=“D”)),”High”,IF(OR(AND(C1=“E”,C2=“C”),AND(C1=“E”,C2=“D”),AND(C1=“E”,C2=“E”),AND(C1=“D”,C2=“D”), AND(C1=“D”,C2=“E”), AND(C1=“C”,C2=“D”), AND(C1=“C”,C2=“E”), AND(C1=“B”,C2=“E”)),”Low”,”Medium”))

Search Server 2008 Express

Microsoft has just released its free product – Search Server 2008 Express for Enterprise search. It is a search product in itself which combines all the desirable feature of MOSS enterprise search along with added configuration features, data Connector and Unified Administration Dashboard functionality.

 Search Centre 

Search centre provides the similar functionality as MOSS 2007 of :

1. Term Definition
2. Best Bets
3. Hit Highlighting
4. Alternative common search items when search word is misspelled
5. Alerts via RSS or email when new search results which meet your criteria are found

  Configuration 

A new Search Administration Dashboard provides a wide range of functionality from the dashboard. The Dashboard highlights most common search task, status and settings. Out of the Box search centre indexes File Shares, Web Site and Exchange Public Folders straight away using feature called content source under crawling.

 

You can configure key relevancy settings like authoritative pages, search scopes, keywords and synonyms.

 

Search Server supports many security features and authentication mechanisms. Helps secure access to critical business information and Services using NTLM, Kerberos, Form based or Cookie based authentication.

 

 

 No Limit 

The best feature incorporated is the no pre set limit on number of documents you can index. Search index allows you to scale your search centre infrastructure to meet your changing needs.

 Federated Search Connectors 

You can now index and search other key business systems at the same place. Connectors can be added that allow search server express to also index information stored in Lotus Notes, EMC Documentum, IBM filenet and other Repositories.

 Reporting 

Similar to MOSS search, Search server provides:

 

1. Graphical display of queries over a time period
2. Most common search items
3. Queries with no results
4. Top Destination pages
5. Query volume
6. Click through rates
7. Most Clicked best bets

Exporting to excel

Content query web part: customisation and adding custom fields

Don’t we all love Content Query Web Part in MOSS 2007. Its a powerful tool to display content from other sites.

We do come to a dead end when the requirement is to display fields other than the one’s available out of the box or to show context menu.

It is amazing to see how an ordinary user (doesn’t have to be a developer) can modify the .webpart file to customise it. follow the steps given on microsoft technet site:

http://msdn2.microsoft.com/en-us/library/ms497457.aspx

you will notice that CommonViewFields property can be changed easily. you will need to know the type of the column. The list is not given in the article. you can get it here:

Field Name	Description
AllDayEvent	Specifies an all day event.
Attachments	Contains attachments.
Boolean	Contains Boolean values that are stored in the database as 1 or 0.
Calculated	Contains calculated values.
Choice	Specifies a predetermined set of values that can be used to enter data into the field.
Computed	Specifies an abstract field type that depends on other fields for its content and definition.
ContentTypeId	Contains a content type ID.
Counter	Contains an integer used for internal ID fields.
CrossProjectLink	Specifies a link between projects in a Meetings Workspace site.
Currency	Contains currency values formatted based on a specific locale.
DateTime	Contains date and time values.
Error	Contains errors.
File	Contains files.
GridChoice	Specifies a Choice field for a data sheet.
Guid	Contains GUIDs.
Integer	Contains positive or negative integer values.
Invalid	Not used.
Lookup	Contains references to values in other lists.
MaxItems	Contains the maximum number of items.
ModStat	Specifies Content Approval status.
MultiChoice	Contains multiple values per list item.
Note	Specifies a field that can contain multiple lines of text.
Number	Contains floating point numbers.
PageSeparator	Inserts a page break in a survey list.
Recurrence	Specifies a field used in calendars for recurring events and, like computed fields, an abstract field type that depends on other fields for its content and definition.
Text	Contains a single line of text.
ThreadIndex	Contains the ID that indicates the relative position of a message within a conversation thread.
Threading	Specifies a field that is used in the creation and display of threaded Web discussions.
URL	Contains hyperlinks.
User	Specifies users of a SharePoint site.
WorkflowEventType	Specifies a workflow event type.
WorkflowStatus	Specifies workflow status.

Enhanced Content Query Web Part created by my colleague Ishai Sagi is an amazing web part: http://www.codeplex.com/ECQWP

Heather Solomon provides the easy approaches of not just customising the Web Part but to apply custom styles as well. Look for step by step details here: http://www.heathersolomon.com/blog/articles/customitemstyle.aspx