Edit

Share via

calculatedColumn resource type

  • Article

Namespace: microsoft.graph

The calculatedColumn on a columnDefinition resource indicates that the data of the column is calculated based on other columns in the site.

Properties

Property Type Description
format String For dateTime output types, the format of the value. Possible values are: dateOnly or dateTime.
formula String The formula used to compute the value for this column.
outputType String The output type used to format values in this column. Possible values are: boolean, currency, dateTime, number, or text.

SharePoint formulas use a syntax similar to Excel formulas. For more information, see Examples of common formulas in SharePoint Lists.

JSON representation

The following JSON representation shows the resource type.

{
  "format": "String",
  "formula": "String",
  "outputType": "String"
}