Scroll To Top
Blog

Programmatically get the calculated field formula in SharePoint 2010

By Vijai Anand Ramalingam Dec 03, 2012
In this blog you will see how to get the calculated field formula in SharePoint 2010 using SharePoint Object Model.

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();
                    }
                }
            }
        }
    }
}