Current user + formula in Contact List?
I'm trying to auto-assign an owner to a task based on the task type:
The Owner column is a Contact List Column and the email addresses specified in the formula are associated with current user accounts (one being myself).
But when I use a Current User filter, nothing shows!
I can only assume that using a formula to fill a contact list isn't compatible with the Current User value?
I have tried using First Last name, and I've also tried the format straight from a Contact cell with no luck--that would be the full:
And that did not work either.
Thoughts? Is this simply not an option? I'd love to be proved wrong!
Thanks fellow Smartsheet-ers!