Formula field to Convert a Muti-Select Text field to a User List field

if you make a formula field on the child table for the text value of the userid (or email) like this

ToText([My userid field])

Then you can roll that up to a combined text summary field and then convert it to a formula List User field.

var text value = ToText([Combined Text List-User(text format)]);

ToUserList(
ToUser(Trim(Part($value,1,";"))),
ToUser(Trim(Part($value,2,";"))),
ToUser(Trim(Part($value,3,";"))),
ToUser(Trim(Part($value,4,";"))),
ToUser(Trim(Part($value,5,";"))),
ToUser(Trim(Part($value,6,";"))),
ToUser(Trim(Part($value,7,";"))),
ToUser(Trim(Part($value,8,";"))),
ToUser(Trim(Part($value,9,";"))),
ToUser(Trim(Part($value,10,";"))),
ToUser(Trim(Part($value,11,";"))),
ToUser(Trim(Part($value,12,";"))),
ToUser(Trim(Part($value,13,";"))),
ToUser(Trim(Part($value,14,";"))),
ToUser(Trim(Part($value,15,";"))),
ToUser(Trim(Part($value,16,";"))),
ToUser(Trim(Part($value,17,";"))),
ToUser(Trim(Part($value,18,";"))),
ToUser(Trim(Part($value,19,";"))),
ToUser(Trim(Part($value,20,";"))))

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------