SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to create a calculated field that will add the text [PEN] to the beginning of the displayed text on my Calendar when the event is still "Pending" according to its "Approval Status".

If it is approved or rejected I don't want any additional text.

I thought I could accomplish this easily enough by creating a calculated field like so:

=IF([Approval Status]="Pending","[PEN] ","")&[Title]

However, I get an error.

One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas.

I found a similar question here but no answer.

Any ideas about how I can add [PEN] to the title of my calendar items?


share|improve this question
That should work...what's the field/column type of "Approval Status"? – Rob D'Oria Aug 23 '11 at 15:45
I am not sure where to find its type -- it is added by the Workflow (Approval Workflow). It doesn't show up in my list of Columns ... – thornomad Aug 23 '11 at 16:00
up vote 3 down vote accepted

According to this, the Approval Status field is a lookup field and not applicable for calculated fields. My approach to the issue would be to create a separate calendar view of items with a filter of Approval Status = Pending. This way, approvers can toggle between the approved and pending data and easily distiguish what needs to be approved.

share|improve this answer
That's not a bad idea - if there isn't a solution to the calculated field quandary I am going to have to think outside the box. – thornomad Aug 23 '11 at 16:24

You might try this: Create a text column and make it "hidden". Use a Designer workflow to set the value of the text column. The workflow would run both when an item is created and when it has changed. Using the workflow, you can set the text of the text column and can reference the approval status column as well as the title column.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.