Search: | |||||

| ||||

Home » Forum » Sharepoint | RSS Feeds |

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?

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.

Related Topics:

- Problems searching in a calculated column in a data view web part
- Calculated column - problem with formula
- Excel Formula in SharePoint Calculated Field/Column
- Calculated Counter column in sharepoint list
- Calculated Column for DIF
- Calculated columns
- Calculated Column - Need to increment a counter
- InfoPath and Calculated Columns
- Calculated Column - Count Text
- SPD Workflow - getting calculated value back into list column
- Calculated Column using =LEFT() formula
- Calculating column values from choice field
- Calculated Column question
- Calculated Column issue
- Sum for Calculated Column
- Calculated column formula
- System generated columns are not seen while creating calculated
- Calculating average from column of multiple list
- Calculate column misssing in Total category
- More on calculated columns
- How do I calculate column averages?
- Calculated Fields and the ID Column
- Item ID in Calculated Columns
- Trying to create a sign-up list using calculated columns
- Calculated Column Formatting