DefaultColumnValue resource type

The defaultColumnValue on a columnDefinition resource specifies the default value for this column. The default value can either be specified directly or as a formula.

JSON representation

Here is a JSON representation of a defaultColumnValue resource.

{
  "formula": "=[Column1]+[Column2]+[Column3]",
  "value": "defaultValueString"
}

Properties

Property name Type Description
formula string The formula used to compute the default value for this column.
value string The direct value to use as the default value for this column.

Only one of formula or value may be specified at a time.

SharePoint formulas use a syntax similar to Excel formulas. See Examples of common formulas in SharePoint Lists for more information.