Formula HELP!! count the number of task assigned
Answers
-
Hi! It may be helpful to provide screenshots (with sensitive data blocked) so that we can see what your ranges refer to, etc.
Here's how I would set it up on my own sheet, though:
=COUNTIF({Contact},[Name]@row)
Where {contact} is the named range for the contact column in the source sheet, and [name] is the contact column in the summary sheet.
Hope this helps!
Best,
Heather
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!