Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Calculated column problem

  Asked By: Grace    Date: Jan 13    Category: Sharepoint    Views: 2224

V2 question:

I created a calculated column in a custom list with this formula:

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

Later, I created a new list item and realized the calculated column
was just showing as
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?



1 Answer Found

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

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.