SPFieldCalculated.Formula Property

Gets or sets the formula that is used for calculation in the field.

Namespace:  Microsoft.SharePoint
Assembly:  Microsoft.SharePoint (in Microsoft.SharePoint.dll)
Available in Sandboxed Solutions: Yes
Available in SharePoint Online


<ClientCallableAttribute> _
<ClientCallableConstraintAttribute(FixedId := "1", Type := ClientCallableConstraintType.NotEmpty)> _
Public Property Formula As String
Dim instance As SPFieldCalculated
Dim value As String

value = instance.Formula

instance.Formula = value
[ClientCallableConstraintAttribute(FixedId = "1", Type = ClientCallableConstraintType.NotEmpty)]
public string Formula { get; set; }

Property Value

Type: System.String
The formula.


Formulas are in the format of Microsoft Excel, but there are some limitations on the functions you can use and some subtleties in the syntax. Before using this property consult Calculated Field Formulas.

See Also


SPFieldCalculated Class

SPFieldCalculated Members

Microsoft.SharePoint Namespace