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

  • 2
  • 2
  • Question
  • Updated 2 years ago
  • Answered

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 tasks and the total number of hours estimated for a job.

Photo of Ryan

Ryan

  • 0 Points

Posted 5 years ago

  • 2
  • 2
Photo of Dan

Dan

  • 1,590 Points 1k badge 2x thumb
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

)
Photo of Ryan

Ryan

  • 0 Points
That did it. Thank you for your help! Much appreciated!
Photo of Ben L

Ben L

  • 130 Points 100 badge 2x thumb
Awesome, exactly what I was looking for. Thanks!