.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Sharepoint calculated fields?

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :SharePoint

Hi all,


I have a quick question for you in relation to sharepoint calculated fields.


I am trying to set up a method in calculated fields, using the task list

to enter in the status (not started, In progress, Completed, Deferred, Waiting on someone else)


Basically when the user selects t

View Complete Post

More Related Resource Links

Importing SharePoint List Data into Project Server 2007 Custom Fields

Learn how to use the programmability features of Project Server 2007 and Windows SharePoint Services 3.0 to import SharePoint list data into an enterprise custom field.

SharePoint makes Office Document custom fields unreadable


We're using WSS 3.0SP2 with a Document Library that has document-level columns (fields) added. The columns (fields) are defined as single-line text; nothing fancy. In SharePoint we can set the field values no problem. When we pull the documents back out of SharePoint to the file systsem, and look at the Custom Fields, the values are unreadable gibberish. They look like graphics lines and boxes and the Type is set to Unknown.

Any ideas why this is happening and how to fix it?

Calculated Date Fields

I'm trying to calculate whether a delivery is on time or late and by how many days. Is there a way to format the column so it show's the result in the number format as opposed to showing up as a date? Negative numbers don't export into excel well.

Cross list query for two sharepoint lists and a join between the fields

Hello All, I have a requirement where i need to query the data from two  sharepoint lists  on a same site by doing a join between those lists and get the result into datatable.I am doing this using sharepoint object model.Is there any possibility to do this. Any pointers in the right direction are greatly appreciated. Thank you Smith   smith

Is it possible to use multiple date fields to have an event show more than once on a Sharepoint 2007

Hello, Is it possible to use multiple sets of start and end times to have events display multiple times in a sharepoint calendar? To clarify: - I have the standard fields of "Start Time" and "End Time" in my calendar list. - Events show on the calendar just fine. - Would like to create additional fields called "Start Time 2" and "End Time 2" within the same record and have the event show multiple times on the calendar. - The recurrence functionality of sharepoint will not meet my needs because the pattern I need to use is not in one of the allowed choices. Thanks in advance, John

Sharepoint: In Calculated Column, Code with multiple "IF" condition does not work.

Implemantation:  Calculate expected resolve date exclude "Saturday" and "Sunday"  based on Priority and Severity.Columns are:1. Priority:2. Severity:3. Raised on: Date record createdCode: Below is the code which contains multiple "If" conditions. For quick undersatnding, i separated major If condition. Below code does not work and sharepoint gives me Sytax error message. =IF(OR(Priority="Critical",Severity="Critical"),IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+3,[Raised on]+1),     IF(OR(Priority="HIGH",Severity="HIGH"), IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+4, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+4,[Raised on]+2)) ,   IF(OR(Priority="MEDIUM",Severity="MEDIUM"), IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+5, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+5, IF(TEXT(WEEKDAY([Raised on]+3),"dddd")="Saturday",[Raised on]+5,[Raised on]+3)) ) ,   IF(OR(Priority="LOW",Severity="LOW"), IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+6, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+6, IF(TEXT

Use Sharepoint Calendar Start Time field in calculated column

I'm trying to limit the calendar view to current week using the Sharepoint defined field Start Time. However, when I display the serial number behind the Start Time it looks like it is actually giving me the serial number for the Created Date field. I believe it is because the appointment is reoccurring but I'm hoping there is a way around it. I created a new testdate field and manually entered the date and set those appointments as all day events however they are not reocurring appointments. The testdate returns the correct serial number however the start time returns an incorrect serial number. SerialNumber1=DATE(YEAR([Start Time]),MONTH([Start Time]),DAY([Start Time])) SerialNumber2=DATE(YEAR([testdate]),MONTH([testdate]),DAY([testdate])) Start Time  SerialNumber1 Testdate  SerialNumber2 8/31/2010 40420 8/31/2010 40421 8/31/2010* 40405    9/1/2010* 40405    9/2/2010* 40405    9/7/2010 40427 9/7/2010 40428 9/13/2010* 40405    9/14/2010 40434 9/14/2010 40435 9/14/2010* 40405    9/15/2010* 40405    *These are reoccurring appointments scheduled as all day events. The others were entered as one time appointments scheduled as all day events.

Changing fields while updating an InfoPath Form to a SharePoint 2010 Document library

My document library has following EventReceiver: <?xml version="1.0" encoding="utf-8"?> <Elements xmlns="http://schemas.microsoft.com/sharepoint/"> <Receivers ListTemplateId="101"> <Receiver> <Name>EventReceiverDocumentLibraryItemUpdating</Name> <Type>ItemUpdating</Type> <Assembly>$SharePoint.Project.AssemblyFullName$</Assembly> <Class>EventHandling.EventReceiverDocumentLibrary</Class> <SequenceNumber>10000</SequenceNumber> </Receiver> </Receivers> </Elements> Updating a browser enabled InfoPath form in the document library fires following event: Public Overrides Sub ItemUpdated(ByVal properties As SPItemEventProperties) Try Me.EventFiringEnabled = False properties.ListItem("Lastname") = "Testperson" properties.ListItem.ParentList.ParentWeb.AllowUnsafeUpdates = True properties.ListItem.SystemUpdate(False) ' solution 1 properties.ListItem.Update() ' solution 2 properties.ListItem.UpdateOverwriteVersion() ' solution 3 properties.ListItem.ParentList.ParentWeb.AllowUnsafeUpdates = False Me.EventFiringEnabled = True MyBase.ItemUpdated(properties) Catch ex As Exception Me.EventFiringEnabled = True E

Calculated Fields and Lists.. do tell!

Ok, so I have a massive Excel Spreadsheet with some lookups and calculated fields.  I need to port this over to a SharePoint list.   I'm guessing for something like this the Import Spreadsheet function won't cut it.. and that I have to rebuild the spreadsheet essentially from scratch and start from there. Is this the case? Once I create the columns as I want them, can I still port over the information (data) in the spreadsheet or am I essentially pooched when it comes to porting that data over?    Thanks!   J

Adding custom fields into the sharepoint

Hi, As i am not aware of adding custom fields into sharepoint i have followed as per the link http://www.sharepointkings.com/2010/06/creating-custom-field-in-sharepoint.html but i couldn't integrate the custom field so if you have any step by step process of creating and adding custom fields in sharepoint link please let me know Thanks & Regards, Sudheer

Types of calculated fields in a query

Hello, I have a question about how the SQL server engine determines the types of calculated fields. For simple calculations I assume it's based on the types of the fields composing the query as they are defined in their tables, but what about a calculated field in this form, for example: isnull(field-name,-99)? Is there a way I can change the engine's selection in the query? Thanks.

Types of calculated fields in a query

Hello, I have a question about how the SQL server engine determines the types of calculated fields. For simple calculations I assume it's based on the types of the fields composing the query as they are defined in their tables, but what about a calculated field in this form, for example: isnull(field-name,-99)? Is there a way I can change the engine's selection in the query? Thanks.

How to submit my form to Sharepoint Library as well as Sharepoint List with specific Fields only.

Hello ,   I have a Infopath form that contain 50 of fields. i want to submit those form into sharepoint library as well as Sharepoint Custom List(Specific Fields). Please suggest best practice to develop such a functionality.   Thank you.

How to sum up InfoPath calculated fields

I have a repeating table with calculated fields on each row.  At the end, I need to sum up all these calculated fields into total.  Which total is also a calculated field to sum up 2 calculated fields in the repeating table.  The total never show anything after data entry.  How can I sum up total from the calculated fields?  For example: QTY 1 of a Computer would cost $1000.  In the repeating row, I will allow customer to fill in multiple rows.  A field named line item total is a calculated field named EXTCOST which is set to QTY X Computer = $1000.  At the bottom of the form, I would like to sum up EXTCOST to get the Grand Total Cost.  The Grand Total Cost is fomat as SUM(EXTCOST) which is zero at all time. Please advise. Brian.

Get ID's of reference fields with sharepoint .net object model?

Greetings. My overall goal is to bulk copy sharepoint (moss2007) site's lists into sql database (to later query them etc). I gave up trying to use web services sharepoint offers because Query() service does not return ID's of fields that are actually referencing something (like users) and GetListItems only returns limited amount of rows and does not provide a schema, means that for russian sharepoint, all column names are total rubbish and there is no way (programmatically, from web service reply) to know which one is which actual column. Right now i am trying to write a web service that will return all kind of stuff i need - schema of the list, and rows of the list. In rows, i need to return ID's of the fields where the field is a reference kind, like User, because, we have serious sized lists (>20000 items grown in less than a year) and we cannot afford truncate/insert, we need to only query for changes and insert/update them. So, if i store for ex. username (not domain name but full name) as string, and user changes his surname, it wont get updated and queries would fail. I need to store an ID. I currently use this code sample:   string const_sitelink = "http://moss2k7-2/sites/test/"; SPSite testsite = new SPSite(const_sitelink); SPWeb testweb = testsite.AllWebs[""]; SPList list =testweb.GetList("/sites/test/Lists/List1&q

Problem with Update of Sharepoint Taxonomy Fields in custom developed Content Types

Dear all, we developed an solution on sharepoint 2010 for one of our customers with custom lists and content types with fields from the managed meta data store. As recommended we developed everything in features & solutions so that easy deployment is possible. Adding metadata to the termstore seems to work without problems, but today we stepped over an confusing issue: Our customer changed the default label of an term in the metadata term store, but the label did not change in listviews and detailviews of items in the specific sitecollection. In editview we see the correct label. After searching a while we discovered the connection between the sitecollection and the term store, the hidden Taxonomylist (/Lists/TaxonomyHiddenList/AllItems.aspx) in the sitecollection, which seems to map the terms. After testing we discovered that the term/label did also not change in the hidden taxonomy list. The Timerjob “Taxonomy Update Scheduler“ is running hourly with success and we also tried to start the job manually, but the label did not change in the hidden list. Also there are no errors in the logfiles in verbose mode. We also tested to create a managed metadata field manually, put it in a list and after that, changed the label. For whatever reason the update of labels on manually created fields works without a problem. Our lists, content types etc get created pr

Filter and Sort on fields in a joined dataview in SharePoint Designer


I need to create a data view that joins and displays data from two lists, and to sort and group on all of the fields displayed, not just fields from the main list.

I created linked datasource from two of my lists, joined them on a common field, and first inserted fields from the main list. Then I inserted fields from the other list as a Joined Subview,  which worked just fine, but now I need to be able to sort and filter on fields in that joined list, for which there doesn't seem to be an option.

Does anybody know whether it's possible and/or any workarounds/solutions for this? Basically, Is there a way to create a joined view of two lists where all fields are displayed in separate columns, and not in a table within a cell as in a case with joined subview?

Any comments are highly appreciated.


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend