Calc column - Lists
Hi Looking at multiple checks in a list calc column and the following works fine: =IF([Course Name]=Course 1,COM1732,NA) Now I want to do multiple checks in this column and can't seem to get the formula right( IF course * give it correct course code) - any ideas? ie. =IF([Course Name]=Course 1,COM1732,NA ,IF[Course Name]=Corse 2,COM1722,NA ,IF[Course Name]=Course 3,COM1705,NA ,IF[Course Name]=Course 4,CSK17118,NA) Searching for a while now and trying different formatting etc. with no results - except for the single check formula above I get the following error The formula contains a syntax error or is not supported. Links or tips appreciated! Cheers Disclaimer: Unless explicitly attributed, the opinions expressed in this email are those of the author only and do not represent the official view of Northern Sydney Central Coast Health nor the New South Wales Government. ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
RE: Content Deployment / Replication options - In particular opinions / experiences with DOCAVE Replicator
DocAve is top of the pops (and for the price it should be!!) but I'd also recommend taking a look at ROSShttp://www.repliweb.com/ross which is built on the uber-reliable RepliWeb R1 engine. If they've got 0 budget then you can always script something up using stsadm and xcopy. I'm curious as to why the blank site starting point is an issue though. Regards, Paul Online Developer, ICT CEO Sydney From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Trevor Andrew Sent: Wednesday, 16 December 2009 10:53 AM To: 'ozMOSS' Subject: Content Deployment / Replication options - In particular opinions / experiences with DOCAVE Replicator Hi All, Just wanted to get some feedback on what others are using for Content Deployment / Replication. For a number of reasons it looks like the client site I'm at can't use standard SharePoint Content Deployment (i.e. requirement for blank site as the starting point at destination), plus we need quite granular control. There's a strong preference not to roll-our-own replication solution, rather to use a tried and proven product in this space. The product that I've been taking a look at most closely is DOCAVE replicator. I'd be interested in people's experiences / war stories with this product. Regards, Trevor Andrew ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
RE: Calc column - Lists
Looks like you're missing AND statement in thereI'd look at dropping the NA (except the last one) and put in a few AND statements... -Original Message- From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Chris Denniss Sent: Wednesday, 16 December 2009 11:01 AM To: ozMOSS Subject: Calc column - Lists Hi Looking at multiple checks in a list calc column and the following works fine: =IF([Course Name]=Course 1,COM1732,NA) Now I want to do multiple checks in this column and can't seem to get the formula right( IF course * give it correct course code) - any ideas? ie. =IF([Course Name]=Course 1,COM1732,NA ,IF[Course Name]=Corse 2,COM1722,NA ,IF[Course Name]=Course 3,COM1705,NA ,IF[Course Name]=Course 4,CSK17118,NA) Searching for a while now and trying different formatting etc. with no results - except for the single check formula above I get the following error The formula contains a syntax error or is not supported. Links or tips appreciated! Cheers Disclaimer: Unless explicitly attributed, the opinions expressed in this email are those of the author only and do not represent the official view of Northern Sydney Central Coast Health nor the New South Wales Government. ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
RE: Calc column - Lists
Thanks All Did track down exactly what I was after (thought I had done this tho!) from http://office.microsoft.com/en-us/sharepointtechnology/HA011610101033.aspx Example set 3 Correct formula; =IF([Course Name]=Course 1,COM1732 ,IF([Course Name]=Course 2,COM1722 ,IF([Course Name]=Course 3,COM1705 ,IF([Course Name]=Course 4,CSK17118,NA Easy when it all lines up! Cheers Paul Noone paul.no...@ceosyd.catholic.edu.au 16/12/2009 11:09 am You've got a type in there but I don't think that's your problem. I believe multiple IF statements require declaration and nesting where appropriate. e.g. =IF([Probability]=[Impact],[Probability],IF(OR(AND([Probability]=Low,[Impact]=Medium),AND([Probability]=Medium,[Impact]=Low),AND([Probability]=Low,[Impact]=High),AND([Probability]=High,[Impact]=Low)),Medium,IF(OR(AND([Probability]=Medium,[Impact]=High),AND([Probability]=High,[Impact]=Medium)),High))) The best resource I've ever found - and the genius of HTML calc columns - is here: http://pathtosharepoint.wordpress.com/2008/08/07/calculated-columns/ Regards, Paul Online Developer, ICT CEO Sydney -Original Message- From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Chris Denniss Sent: Wednesday, 16 December 2009 11:01 AM To: ozMOSS Subject: Calc column - Lists Hi Looking at multiple checks in a list calc column and the following works fine: =IF([Course Name]=Course 1,COM1732,NA) Now I want to do multiple checks in this column and can't seem to get the formula right( IF course * give it correct course code) - any ideas? ie. =IF([Course Name]=Course 1,COM1732,NA ,IF[Course Name]=Corse 2,COM1722,NA ,IF[Course Name]=Course 3,COM1705,NA ,IF[Course Name]=Course 4,CSK17118,NA) Searching for a while now and trying different formatting etc. with no results - except for the single check formula above I get the following error The formula contains a syntax error or is not supported. Links or tips appreciated! Cheers Disclaimer: Unless explicitly attributed, the opinions expressed in this email are those of the author only and do not represent the official view of Northern Sydney Central Coast Health nor the New South Wales Government. ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss Disclaimer: Unless explicitly attributed, the opinions expressed in this email are those of the author only and do not represent the official view of Northern Sydney Central Coast Health nor the New South Wales Government. ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
FW: Announcing the release of the December 2009 Cumulative Update for Project, Project Server and SharePoint 2007
December CU is out! Regards, Paul Turner Senior Solutions Specialist M: 0412 748 168 P: 08 8238 0912 F: 08 8234 5966 A: 66 Henley Beach Road, Mile End SA 5031 E: paul.tur...@dws.com.aumailto:paul.tur...@dws.com.au W: www.dws.com.au [cid:image001.jpg@01CA7E44.4BB83600] ADVANCED BUSINESS SOLUTIONS LTD This email and any files transmitted with it are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient you have received this email in error and are requested to delete it immediately. Any opinion expressed in this e-mail may not necessarily be that of DWS Pty Ltd. Please consider the environment before printing this email. Feed: MSDN Blogs Posted on: Wednesday, 16 December 2009 11:19 AM Author: chrisfie Subject: Announcing the release of the December 2009 Cumulative Update for Project, Project Server and SharePoint 2007 The December 2009 Cumulative Update was released today: * Project Server 2007 - KB 977028http://support.microsoft.com/kb/977028 - http://support.microsoft.com/kb/977028 * Project Professional 2007 – KB 977266http://support.microsoft.com/kb/977266 - http://support.microsoft.com/kb/977266 * SharePoint Server 2007 – KB 977023http://support.microsoft.com/kb/977023 - http://support.microsoft.com/kb/977023 * Windows SharePoint Services 3.0 – KB 977022http://support.microsoft.com/kb/977022 - http://support.microsoft.com/kb/977022 Check out the following TechNet resources for deployment guidance: Deploy cumulative updates (Project Server 2007)http://technet.microsoft.com/en-us/library/dd239177.aspx View article...http://blogs.msdn.com/chrisfie/archive/2009/12/16/announcing-the-release-of-the-december-2009-cumulative-update-for-project-project-server-and-sharepoint-2007.aspx inline: image001.jpg___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
Free web part for the Copenhagen conference
Hiya I hope the list won't mind this small plug.. we have been doing some interesting work lately in a non SharePoint (but related) collaboration discipline and through that, embarked in a new initiative that includes releasing a free web part for any organisations who might be interested in following what's happening. http://www.copenhagensummitmap.org/ The above site was the brainchild of my colleague Chris Tomich, who would be known to some as an occasional contributor to this list. He recognised the importance of the Copenhagen summit in terms of a massive worldwide collaboration event on a very complex problem, and hit upon the idea of pooling the expertise of some sense-making practitioners around the world to create a living view of the conference as it unfolds. The intention is to build a rich map of information taken from a variety of sources including live/delayed web casts of the conference and any other materials made available from the conference. The process of building the maps aims to be unbiased and all information is considered suitable content for the maps. This is essentially a wiki on steroids crossed between a debate tool. It allows people to rapidly understand the issues of the debate via visual exploration, as opposed to viewing a bunch of web casts or reading 50-100 page discussion papers. By placing this webpart somewhere on your SharePonint portals, you offer your colleagues a different glimpse of what is going on in Denmark. I also blogged http://www.cleverworkarounds.com/2009/12/14/sharepoint-debategraph-and-cope nhagen-2009-collaboration-on-a-global-scale/ about it the other day, with more detail and some screencasts to further convey the idea. Thanks Paul Culmsee http://www.cleverworkarounds.com/2009/12/14/sharepoint-debategraph-and-copen hagen-2009-collaboration-on-a-global-scale/ ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss