I am attempting to set the default value of the Title item in a list so that it is more informative -- I have the Title field "hidden" from the user, but my company's workflow utilizes Title in workflow emails.
I want the title to contain the submitter's Display Name. I have seen the =[Me]
function but that returns the entire DOMAIN\username
which is really ugly in my case.
If the Display Name isn't possible am I able to use something like a REPLACE
function to at least remove the DOMAIN\
from the string (so that just the user name remains)?
I've tried to do simply:
=REPLACE([Me],"DOMAIN\","")
But I get a syntax error.
Any ideas?