Assigned to Count

Please I need help with the formula to count the total number of tasks assigned to each contact on my sheet.

• ✭✭✭✭✭✭

Hi @Lilian Odobor

Hope you are fine, could you please supply a screenshot for your sheet ( remove any sensitive data ) so i can write the exact formula for your sheet.

bassam.khalil2009@gmail.com

☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

• Please see a sample below. In the Assigned to column, we have three contacts Olayinka, Lilian O. and Lilian E. I would love to count the total number of task assigned to Lilian O, then Olayinka then Lilian E. I used this formula =countif([Assigned to], "Olayinka") but doesn't work.

• Hello @Bassam.M Khalil Please see a sample below. In the Assigned to column, we have three contacts Olayinka, Lilian O. and Lilian E. I would love to count the total number of the task assigned to Lilian O, then Olayinka then Lilian E. I used this formula =countif([Assigned to], "Olayinka") but doesn't work.

• ✭✭✭✭✭✭
edited 02/08/21

Hi @Lilian Odobor,

Please try the following formulas:

=COUNTIFS([Assigned to]:[Assigned to], CONTAINS(Contact@row, @cell))

the following is a link to a sample sheet

bassam.khalil2009@gmail.com

☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

• @Bassam.M Khalil Thank you. I only understand this formula =COUNTIFS([Assigned to]:[Assigned to], CONTAINS(Contact@row, @cell)), from the countif. Contact@row, @cell standard for what?

• edited 02/08/21

The result came out as zero.

• ✭✭✭✭✭✭

Hi @Lilian Odobor

Contact@row is to change the contact name in the contact column if you have more contacts to count, so the formula will read the contact whatsoever you write and count the number.

for example, in the future, you add new contact let use say "Bassam K", then you just write this on the cell and the formula will count it directly.

try this in the following sample sheet i created for you please.

bassam.khalil2009@gmail.com

☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

• edited 02/09/21

Thank you, @Bassam.M Khalil, however, the "Assigned to" Column contain email addresses. Does this apply?

• ✭✭✭✭✭✭

Yes @Lilian Odobor

bassam.khalil2009@gmail.com

☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!