Calculated Default Value
Common Use Cases
- Default dates: stamp a new item with today’s date at creation
- Due dates: set a deadline a fixed number of days after today
- Current user: capture who created the item with [Me]
- Starting text: prefill a title or reference stub users then complete
- Period labels: derive a quarter or year label from today’s date
- Sensible starters: give a numeric field a baseline value to edit
How It Works
- Calculated Value option: choose it in the column settings instead of a fixed default
- Written at creation: the formula runs once when a new item is made
- [Today] support: reference the current date in the formula
- [Me] support: reference the current user in the formula
- Excel-style syntax: use the same functions as calculated columns
- User can override: the default is a starting point, not a lock
Benefits
- No code: pure column configuration, no flow or script needed
- Faster entry: users begin from a meaningful value, not a blank
- Fewer mistakes: consistent starting dates and owners reduce typos
- Time-aware: [Today] keeps date defaults current without maintenance
- Personalized: [Me] tailors the default to whoever creates the item
- Still flexible: people can change the value when the default does not fit
Details
- Feature Category: Columns & Views
Settings
- Location: the Default value section of a column’s settings page
- Two modes: pick a fixed value or switch to Calculated Value
- Formula box: appears when Calculated Value is selected
- Supported types: single line of text, number, currency, and date and time
- Result must match: the formula output has to fit the column type
- Save to apply: new items created afterward pick up the default
Limits and Nuances
- No other columns: the formula cannot reference any other field in the item
- Creation only: the value is set once and not recalculated on edit
- No RAND or NOW: those volatile functions are not supported
- Not on every type: choice, yes/no, and lookup columns use fixed defaults instead
- Override is allowed: a default cannot force or guarantee a value
- Classic settings: the option lives on the full column settings page, not the quick modern panel
Common Questions About Calculated Default Values
What is a calculated default value in SharePoint?
It is a column setting that fills a new item with a formula-based result the moment the item is created, instead of leaving the field blank or using a fixed value. You choose Calculated Value in the column’s settings and enter an Excel-style formula. It is ideal for stamping a creation date, a due date, or the current user’s name, and the person entering the item can still change the result.
Can a default value formula use [Today] and [Me]?
Yes. This is a key difference from calculated columns, which do not support those tokens. In the default value setting, [Today] returns the current date and [Me] returns the current user, so you can default a date field to today, a due date to today plus seven, or a person field to whoever is creating the item. The volatile RAND and NOW functions, however, are not supported.
Can a default value formula reference another column?
No. A calculated default value cannot reference any other column in the same item. The default is applied at the instant a new item is created, and at that point the other columns do not yet have values to read. If you need a result that depends on other fields after they are filled in, use a calculated column or an automated flow instead of a default value.
When is the default value actually applied?
The formula runs one time, when a new item is first created. It sets the initial value and then steps out of the way, so editing the item later does not recalculate it, and items already created will not update. This makes calculated defaults great for capturing a point-in-time value like the creation date, but wrong for anything that must stay in sync as data changes.
Which column types support a calculated default value?
Calculated default values are available for single line of text, number, currency, and date and time columns. Choice, Yes/No, and lookup columns offer a fixed default selection rather than a formula. The option lives on the full column settings page, so you may need to open the column from the classic list settings rather than the quick modern edit-column panel to see the Calculated Value choice.
When should I use a calculated default instead of a calculated column?
Use a calculated default value when you want a smart starting value that users can still edit and that only needs to be right at creation, such as a due date or an owner. Use a calculated column when the result must always reflect other fields and update automatically. Greg Zelfond, the consultant behind LookBook 365, picks the default when the value is a helpful starting point and the calculated column when it must stay live.