Adding fake user in a multiple contacts per cell field configuration
I have a sheet set up using the Contact List field to hold my Assigned To information.
I have a set of named resources and associated email addresses for some individuals , which works fine in a multiple contacts per cell configuration. These real users are Users under User Management/saved in the sheet Contact List.
I also have 3rd parties assigned to tasks. I tend to add these as company names and without an email address. This could equally apply to internal teams where I know the role but not the named resource. This is not a problem when there is just one contact in the field, however I typically have tasks that are being worked on by multiple contacts.
Ideally I don't want to have to
- duplicate tasks so I can have the same task assigned to each party
- set up fake googlemail, or other, accounts to back the 3rd part/role name
- muddy user management with fake users (even if they are not licenced and so cost no money)
Has anyone got a solution they use for this situation?
Help Article Resources
Check out the Formula Handbook template!