in

SharePoint University

Clean slate. Nothing but SharePoint.
Go, SharePoint!

Calculated column in Wiki list

Last post 10-28-2007 6:25 PM by NZFlavad. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 10-12-2007 10:36 PM

    • NZFlavad
    • Not Ranked
    • Joined on 10-12-2007
    • New Zealand

    Calculated column in Wiki list

    HELP PLEASE!

    I am not a developer :) however I have been put in charge of creating a wiki site for all Help info for the business, starting with our financial application.  I have migrated our current help content to Wiki pages.  I have then created a web part page that works like a preview glossary page.

     I am trying to add a calculated column to the wiki document list that is an index using the LEFT functionality - in this column I want to automatically get the first letter of the page...however, I try to use the [Name] field (=LEFT([Name],1)) and I get the following error:

    The formula refers to a column that does not exist.  Check the formula for spelling mistakes or change the non-existing column to an existing column.

    Any ideas??

    Filed under: ,
  • 10-16-2007 8:43 AM In reply to

    Re: Calculated column in Wiki list

    Instead of using Name, see if [Title] will work. It's possible this is a renamed column derived from the base column [Title].

  • 10-18-2007 2:22 AM In reply to

    • NZFlavad
    • Not Ranked
    • Joined on 10-12-2007
    • New Zealand

    Re: Calculated column in Wiki list

    Hi Chris, thanks for the reply.  I am able to create a calculated column with [Title], however it doesn't pick up any info...Sad

  • 10-18-2007 2:21 PM In reply to

    Re: Calculated column in Wiki list

    Strange, I'm not sure why you can't see that column (name). I noticed that it doesn't even show up when you choose to edit the list. Have you investigated the Content Type for a wiki item? It might give you a clue to the column name as they can often be different than the display name.

  • 10-28-2007 6:25 PM In reply to

    • NZFlavad
    • Not Ranked
    • Joined on 10-12-2007
    • New Zealand

    Re: Calculated column in Wiki list

    Thanks again Chris - I'm going to try today to see how I go. Smile

Page 1 of 1 (5 items)

Need SharePoint Training? Attend a SharePoint Bootcamp!
Forum content (c) original posters. Everything else (c) 2008 SharePoint Experts, Inc.