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.


Best Answer

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

    @Lena Ho

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



    Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (

    Feel free to email me:

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!