Calculated Field: How to display 'Approval Status'

Question

In a calculated field in SharePoint, how do I display the approval status?

I've tried =TEXT([Approval Status]) but it doesn't work.

Any Ideas? thanks.

Answer 1

If you want just the value of the Approval Status column just add that to the View, Why Calculated Field ?,Unless you want to Add Some Text or some other Operations based on the Field Value.

Answer 2

I don't get the connection between approval status and calculated field. To be able to approve or denier a list item you can activate the moderation option. You can do this in the menu "List settings" >> "Versioning settings" >> "Content Approval".

If you turn it on, the moderation column should be automatically added to you standard list view and displayed there.

To change the moderation status of a list item through code, you can simply set the Status property of the ModerationInformation property of the list item. It can be set to Approved, Denied, Scheduled, Draft or Pending.

listItem.ModerationInformation.Status = SPModerationStatusType.Approved;