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.