Comments for ShareMyPoint

Comment on SharePoint Planning and Architecture Resources : Visio Diagrams by Daniel

Daniel — Tue, 29 Nov 2011 18:56:49 +0000

Those Visio diagram are excellent,

Please microsoft provide the visio diagram for Team Foundation Intergration with SharePoint 2007

Comment on SharePoint Calculated Columns Formulas by Betty

Betty — Thu, 03 Nov 2011 17:01:55 +0000

Hi -

I am trying to build a calculated column in a slide library, but having trouble. I have one field called [Required Update] that is a drop down containing three options – weekly, monthy, quarterly. I have another field called Aging that is a calculated field that counts the days since a slide was updated.

I am trying to have a column that indicates whether the slide is complete or not based on a calculation using those two fields. Here is the formula I have that isn’t working.

If(or(and[Required Update]=”Weekly”,[Aging]<=7) (AND([Required Update]="Monthly",[Aging]<=30) (AND([Required Update]="Quarterly", [Aging]<=120), "Complete", "Not Complete")

Any ideas?

Comment on SharePoint Calculated Columns Formulas by Jed

Jed — Wed, 02 Nov 2011 23:32:59 +0000

Hi, I am trying to have a self defining ticket number. We are looking at getting Date created plus ID number. Does anyone know how to write the formula for this? For example we are looking at date created in the format of mm/dd/yy + ID field =mmddyyID.

Comment on SharePoint Calculated Columns Formulas by Bernard

Bernard — Wed, 02 Nov 2011 21:32:44 +0000

why is if statement not working? I have a column with text. I create a column with calculated value: =if([subject]=\nothing\,\empty\,\full\)
should be simple but it still gives me an error.
I’m runnin WSS 3.0
thanks for helping me out

Comment on Excel 2007 creating Hyperlinks programmatically by Mark Mandel

Mark Mandel — Thu, 27 Oct 2011 02:53:46 +0000

Thank you, Ram. This is it.

Why didn’t the others find it?

Why didn’t MS make it easy to find?

Comment on SharePoint Calculated Columns Formulas by Anil

Anil — Sun, 23 Oct 2011 23:59:05 +0000

I have a calculated field

=[Created] which is only used as a pointer for a JavaScript, but it comes out as ##,#####. I have it as a number but what I want is the format of that field to just display the number and eliminate the comma.

Any suggestions on what formula I can use?

Comment on SharePoint Calculated Columns Formulas by edna

edna — Mon, 03 Oct 2011 15:43:11 +0000

I am traying to make one drop down to have Low=1 ,Mediem=3, hight =9
=IF(OR(AND([Cost Savings]=”Low”,”Medium”,” High”1)),1,3,9)

Comment on Excel 2007 creating Hyperlinks programmatically by mell

mell — Tue, 27 Sep 2011 08:45:17 +0000

can you explain, how make hyperlink when we used vlookup formula? ive made table, which is link of data was put into.

Comment on SharePoint Calculated Columns Formulas by laxmi

laxmi — Wed, 21 Sep 2011 10:05:21 +0000

my current project is leave management system i worked it entirely with sharepoint designer workflows my requirement is at the end of every month i need to add 2 days to the available leaves of the employee. can i do it by using workflow actions . please let me know.Thanks in advance

Comment on SharePoint Calculated Columns Formulas by Saaraa

Saaraa — Wed, 17 Aug 2011 04:22:17 +0000

I am trying to create a column to flag when it has been over 2 years from last major revision. I tried modifying the below but it didn’t work. Can anyone help.

=TEXT(MONTH([PublishDate]),”00″)

Comment on SharePoint Calculated Columns Formulas by Saaraa

Saaraa — Wed, 17 Aug 2011 04:19:46 +0000

I want to create a column which shows if there has been over 2 years since the last major version was published. I tried to modify this formula to do this but it didn’t work. Any suggestions?

=TEXT(MONTH([PublishDate]),”00″)

Comment on SharePoint Calculated Columns Formulas by Susanne Fahlén Hörnberg

Susanne Fahlén Hörnberg — Fri, 12 Aug 2011 06:54:42 +0000

Extracting Year from any date field in SharePoint 2010

When writing this:

=YEAR([PublishDate])

You’ll get the output: 2 009, 2 008 and like wise…at least I get it like that.

The formula that I use to fixed it is:

=TRIM(YEAR([PublishDate]))

Just make sure the type of column is Single line of text.

Comment on Boot From VHD – Replacing Vista or Windows 2008 Bootloader with Windows 7 Bootloader by Ruslan

Ruslan — Tue, 02 Aug 2011 15:05:31 +0000

Thanks! Good article.
You can skip a couple of steps using Shift + F10 to get a command prompt beginning from “Installation screen” (step 3)

Comment on Installing a language pack for SharePoint (MOSS SP1 and WSS 3.0 SP1) by Aryan

Aryan — Thu, 21 Jul 2011 18:19:00 +0000

Step by Step instruction to install and configure language pack for SharePoint 2010
http://virtualizesharepoint.com/2011/07/21/installing-language-packs-for-sharepoint-2010/

Comment on SharePoint 2010 Language Pack Installing Support for East Asian Languages by Aryan

Aryan — Thu, 21 Jul 2011 18:18:22 +0000

Step by Step instruction to install and configure language pack for SharePoint 2010
http://virtualizesharepoint.com/2011/07/21/installing-language-packs-for-sharepoint-2010/

Comment on SharePoint 2010 Error Changing Variation Label Display Name by Amit

Amit — Thu, 30 Jun 2011 06:54:29 +0000

We are getting one error on $varList.Items | % { 05 $curListItem = $_ and this powershell is not working after this line.

Comment on SharePoint 2010 Error Changing Variation Label Display Name by Sameer Dhoot

Sameer Dhoot — Wed, 15 Jun 2011 19:07:36 +0000

Jamie,
I haven’t experienced any cascading issue. But i am not sure if this wil lbe officially supported by Microsoft. It has to be as they dont have any other way to change it. There are some blog posts which also shows to create the variation hirearchy using the scripts which i am sure is not supported.

Sameer Dhoot.

Comment on SharePoint 2010 Error Changing Variation Label Display Name by Jamie

Jamie — Wed, 15 Jun 2011 17:38:51 +0000

Great article Sameer!

I’m running into the same issue today. After performing this change, have you experienced any related issues? Or does the “display name” have minimal / no cascading issues?

We didn’t realize the issue until we wanted to expose the variation language control in the ribbon as indicated in posts such as the following;

http://mindsharpblogs.com/daniel/archive/2006/11/29/1396.html

Comment on Configuring SharePoint 2010 Document Libraries with Exchange Server 2010 to receive mails from internal/external world by Ratul Dutta

Ratul Dutta — Fri, 03 Jun 2011 17:37:07 +0000

Thanks Sameer… today your document help me a lot …:)

Comment on PowerShell Script to check SQL server connectivity, version, custering status, user permissions by Eric Schrader

Eric Schrader — Thu, 26 May 2011 18:21:16 +0000

Why do you check if it is clustered? Does this change the way you do the installation?

Comment on SharePoint Calculated Columns Formulas by Karyn

Karyn — Thu, 14 Apr 2011 14:39:42 +0000

Hi there,

I’m trying to create a calculated field where I take another column (DATE: Attended Demo). I want to add 30 “business days” to the date in the other column and have the calculated column present as a date (which is in essence 6 weeks after the “DATE: Attended Demo” field.

I’m lost…anyone have any suggestions?

Comment on SharePoint Calculated Columns Formulas by Gwen Demulder » Blog Archive » Playing with Sharepoint on SBS 2011

Gwen Demulder » Blog Archive » Playing with Sharepoint on SBS 2011 — Sun, 10 Apr 2011 07:40:21 +0000

[...] From])-FIND(“<”,[E-Mail From])-1) I found the formula to do this on this blog. This is basically an excel formula. I copy the value of this field to a field in the new list item [...]

Comment on Running CQWP on Team Site without publishing infrastructure feature enabled (MOSS 2007) by EJR

EJR — Wed, 23 Mar 2011 15:39:27 +0000

Very helpful thanks. Is there a way to remove the references to the publishing namespace in the webpart file by either
a) substituting a different property definition (there must be a common non-publishing namespace for field operators for instance)
b) creating the equivalent lists in line in the webpart for these selections (e.g. operators, sort direction, etc.)
c) calling them text and making sure we enter valid values when using the webpart on a page.

The Style Library will cause more than a few problems with inquisitive users, so I am trying to get the cqwp without the Style Library.

Comment on Installation Issue SharePoint Server 2010 Release Candidate on Domain Controller by tousma

tousma — Sat, 29 Jan 2011 23:09:49 +0000

Thanks God you solve my problem!!! I pass one day to try install standalone server and is dosen’t work. Your article is only one I found to solve my problem!

Comment on SharePoint Calculated Columns Formulas by Chris Warner

Chris Warner — Tue, 16 Nov 2010 19:17:23 +0000

This helped me!