I have a custom list named “Employees' which has the following columns.

  • FirstName – Single line of text
  • LastName – Single line of text
  • FullName – Calculated Field

In this blog you will see how to get the calculated field formula using SharePoint Object Model.

Formula for FullName

=[LastName]&","&[FirstName]

Code Snippet:


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint;

namespace CalculatedField
{
 class Program
 {
 static void Main(string[] args)
 {
 using (SPSite site = new SPSite("http://shashankpc:2012/sites/test"))
 {
 using (SPWeb web = site.OpenWeb())
 {
 SPList list = web.Lists.TryGetList("Employees");
 if (list != null)
 {
 SPFieldCalculated calculatedField = list.Fields.GetFieldByInternalName("FullName") as SPFieldCalculated;
 Console.WriteLine(calculatedField.Formula);
 Console.ReadLine();
 }
 }
 }
 }
 }
}