SP 2007, calendar list. Want to add a column that gets its default value from "Created By" but then allows that to be edited. This is what I tried:
- Create column
- Give it a name
- Leave type set to Single line of text
- Change Default value to Calculated Value
- Enter =[Created By]
- Click OK
SP throws this error:
One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas.
Is there another way to do what I need?