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?