Someone on the Internets was asking about how to create a calculated column on a list that would show a value formatted as "[User] – [Status] – [Location]" as in "Paul Galvin – Drinking [free] Beer – The Beach".
Paul would go in and update his entry in the list and the calculated column would update appropriately. The [User] should default to the the user entering/updating the list.
A calculated column cannot use "volatile" functions such as [Me] or [Today]. I solved it in a test environment with these steps:
- Create a text column named "Current User".
- Set its default value to [Me]
- Create a calculated column called "Calc Test".
- Set its value = [Current User]
I went in, added an item to the list and it worked.