Forum Discussion
ClaireMartinez
6 years agoQuickbase Alumni
Also this formula would work, replace
- with the name of your list user field
var UserList myUserList =
;
var Text users = SearchAndReplace(SearchAndReplace(Trim(ToText($myUserList))," ;", ";"),"; ",";");
Count(
Part($users,1,";"),
Part($users,2,";"),
Part($users,3,";"),
Part($users,4,";"),
Part($users,5,";"),
Part($users,6,";"),
Part($users,7,";"),
Part($users,8,";"),
Part($users,9,";"),
Part($users,10,";"),
Part($users,11,";"),
Part($users,12,";"),
Part($users,13,";"),
Part($users,14,";"),
Part($users,15,";"),
Part($users,16,";"),
Part($users,17,";"),
Part($users,18,";"),
Part($users,19,";"),
Part($users,20,";")
)