Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

Calculated column problem

  Asked By: Grace Lewis         Date: Jan 13, 2006      Category: Sharepoint      Views: 365
 

V2 question:

I created a calculated column in a custom list with this formula:
="XXX/.../EditForm.aspx?ID="&[ID]

When I first created the column, it worked. I had to manually type
the [ID] because it wasn't one of my column options to add to the
formula.

Later, I created a new list item and realized the calculated column
was just showing as
"XXX/.../EditForm.aspx?ID="
w/out the item ID # at the end.

I went back in to modify the column, and I noticed that my brackets
had been removed. When I put them back in and saved again, the
latest list item was updated and now showed both the URL and the
correct ID # at the end. I tested 3 more times, and the same thing
happened each time.

Is there any way to make sure my brackets don't get stripped? The ID
column is a legit column, so I don't see why I can't use it in a
calculated column. Why isn't it one of my default options to add to
the formula?

Tagged:      

 

1 Answer Found

 
Answer #1       Answered By: Katy Patton          Answered On: Jan 13, 2006       

Don't know why Microsoft prevents us from using the ID column. IIRC, the
brackets are always removed  from all formulas.

 
Didn't find what you were looking for? Find more on Calculated column problem Or get search suggestion and latest updates.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].