How to Add Calculated Column to SharePoint List using PowerShell?
Requirement: Add a new calculated field to SharePoint list programmatically using PowerShell script.
PowerShell to add a calculated column in SharePoint list or library:
Here is how to add a calculated column to your SharePoint list using PowerShell.
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
#Variables
$WebURL="https://projects.crescent.com"
$ListName="Proposal Documents"
$CalculatedColumnName="Created Month-Year"
#Get the Web
$web = Get-SPWeb $WebURL
#Get the List
$list = $web.Lists.TryGetList($ListName)
#Add new calculated column
$list.Fields.Add($CalculatedColumnName, "Calculated", $false)
#Get the column
$CalculatedCol = $List.Fields.GetField($CalculatedColumnName)
#Set Formula for calculated column
$CalculatedCol.Formula='=TEXT(Created,"mmm-YYYY")'
$CalculatedCol.OutputType="Text"
$CalculatedCol.Update()
$web.Dispose()
Script in action: Create calculated column in SharePoint 2013 using PowerShell
Good work mate …