Combine User and User list

Question

I don't know why I can't get this one. I have multiple user fields, and a userlist field. I simply want to make one formula userlist field from all.

I know with just users it's

ToUserList([user1],[user2]....)

How to I add the userlist into this?

------------------------------
Mike Tamoush
------------------------------

MarkShnierYou · Answer

You can combine apples, and you can combine oranges, but not apples and oranges together.
Similarly, you can combine users and userlists, but not users and userlists.

So we need to make the users into small userlists.

ToUserList(ToUserlist([user1]), ToUserlist[user2]...., [My Userlist field])

Now all of the comma separated elements are all apples.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community