Count the total number of task a member being assigned to when one task may assigned to two people

Hi All,

What formula can I use to consolidate the number of task assigned for each member? Because i unable to write a good formula, then I need to form all these possibility combination. I have more than 20 combination and it is difficult for the member to read in the chart.

Tags:

Best Answer

  • Ramzi K
    Ramzi K ✭✭✭✭✭
    Answer ✓

    @Lena Ho

    Lena, change @CELL to @cell (lower case).

    Cheers,

    Ramzi

    Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)

    Feel free to email me: ramzi@cedartreeconsulting.com

    💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!