Count Number of Resources in Assigned To


I am having trouble creating a "count" formula for the following scenario (example):

  1. "Assigned To" [Contacts List] column is set to "Allow multiple contacts per cell"
  2. Four contacts are selected in "Assigned To"
  3. Allocation % is 20% (could be any percentage)
  4. Duration is 10 days
  5. Need a formula to provide a count total of the number of resources in the "Assigned To" column
  6. Need to calculate # hours
    1. total hours for task
    2. total hours by resource

Can anyone help? Please? Thank you so much.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!