Forum Discussion

RyanRyan3's avatar
RyanRyan3
Qrew Member
11 years ago

How to use a formula field to count number of users selected in a list user field?

I'm trying to figure out if there is a way to count the number of users in a list user field to help calculate and determine a projected completion date based on the number of user assigned to a task...
Formulas and functions
Tables and fields
User and group management
DanLadner1's avatar
DanLadner1
Qrew Trainee
11 years ago
This is working for me--just replace [User List] with the field in question, and you'll need to add conditions for 6-10.

If(

not IsNull(ToUser(Part(ToText([User List]),5,";"))), 5,

not IsNull(ToUser(Part(ToText([User List]),4,";"))), 4,

not IsNull(ToUser(Part(ToText([User List]),3,";"))), 3,

not IsNull(ToUser(Part(ToText([User List]),2,";"))), 2,

not IsNull(ToUser(Part(ToText([User List]),1,";"))), 1

)