In this example we are able to show how to select the
calculated value property using PowerShell, as per our requirement we have to
show the X years date while creating a new item using the calculated formula we are unable to the field in NewForm.aspx, but using the Calculated value option we can show the
filed in the NewForm.aspx Page.
Import Data from excel to SharePoint List using PowerShell
How to add fields to list in sharepoint using powershell
How to add fields to list in sharepoint using powershell
Copy value from one filed to another field using PowerShell - See more at: http://www.dotnetsharepoint.com/2015/07/copy-value-from-one-filed-to-another.html#sthash.QPHZ7Tjz.dpuf
Copy value from one filed to another field using PowerShell
Date formula in SharePoint calculated value
Date formula in SharePoint calculated value
Add-PSSnapin Microsoft.SharePoint.PowerShell
$web = Get-SPWeb
"http://dotnetsharepoint.com/sites/sharepoint/enableformula"
$list = $web.lists["ListName"]
if($list.Fields.ContainsField("Date") -eq $true)
{
Write-Host "Field Date already avilable in the
list"
}
else
{
$list.Fields.Add("Date","Date",$false)
$list.Fields["Date"].DisplayFormat =
"DateOnly"
$DateField =
$list.Fields.GetField("Date") #Get the field
$DateField.DefaultFormula = "=DATE(YEAR(Today)+3,MONTH(Today),DAY(Today))"
$DateField.update();
}
Once this PowerShell is completed we can able to see the
Date field Calculated Value as shown below.
