Default to the Current User
This calculated default value uses a SharePoint formula to pre-fill the field with the current user. Set as a calculated default value, it pre-fills the column when a new item is created, and users can still change it.
How It Works
- What it does: Pre-fills the person field with whoever is creating the item.
- What you get: New items open with the creator already selected, and it can be changed.
- Good to know: It’s set once, at creation – it won’t change if someone else edits the item later.
Common Use Cases
- Auto-fill the requester or owner
- Submitted-by fields
- Assignment defaults
- Accountability tracking
Details
- Formula Type: Calculated Default Value
- Formula Category: People & Users
Required Columns
| Display name | Column type |
|---|---|
| Assigned To | Person or Group |
How to Apply the Formula
- Open the column settings (or create the column)
- Under Default value, choose the calculated value (formula) option
- Paste the formula below
- Save. New items will be pre-filled, and users can still change the value
Formula
=ME()Common Questions About Default to the Current User Formula
What does this formula do?
Pre-fill created-by style field. It runs as a default value, pre-filling the column on new items.
Which columns do I need to set this up?
No other columns are required – the formula uses today’s date, the current user, or a constant, and applies to the column you set it on.
Will the default value update later?
No. It is calculated once when the item is created. After that it stays put unless someone changes it.
If LookBook 365 is code-free and out-of-the-box, why does this example use a formula?
A SharePoint formula is native, declarative configuration, not custom development. It only works with the item’s own fields and simple logic – it cannot run scripts, reach external services, or change other data, and nothing is deployed to your tenant. It keeps working through Microsoft updates. If you would rather not set this up yourself, this is exactly the kind of thing I configure for clients.
