Discussions

Expand all | Collapse all

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

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

    Posted 01-27-2015 21:30

    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.



  • 2.  RE: How to use a formula field to count number of users selected in a list user field?

    Posted 01-27-2015 23:02
    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

    )


  • 3.  RE: How to use a formula field to count number of users selected in a list user field?

    Posted 01-27-2015 23:52
    That did it. Thank you for your help! Much appreciated!


  • 4.  RE: How to use a formula field to count number of users selected in a list user field?

     
    Posted 06-26-2017 22:00
    Awesome, exactly what I was looking for. Thanks!