Assigned to Count
Please I need help with the formula to count the total number of tasks assigned to each contact on my sheet.
Answers
-
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.
-
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?
-
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"
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!