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,";"))