Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
Count number of NonBlank cells for each name that appears on a sheet
SadieW
✭✭✭
Hello!
I have a large list of repeating names (for our purposes let's say Susan, Jake, and Katie) that are assigned multiple Projects. For each of these projects, there may or may not be a note. I am trying to figure out how to count the number of times there is a nonblank cell for each person based on this dataset. Thanks in advance!
Best Answer
-
Hi @SadieW,
You can use the following.
=COUNTIFS(Note:Note, "", Name:Name, "Katie")
Substitute the name for each count needed.
Hope this helps,
Dave
Answers
-
Hi @SadieW,
You can use the following.
=COUNTIFS(Note:Note, "", Name:Name, "Katie")
Substitute the name for each count needed.
Hope this helps,
Dave
-
Thank you for the help!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.5K Get Help
- 466 Global Discussions
- 156 Industry Talk
- 510 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 520 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Hi Smartsheet superusers! Ok, so I used Smartsheet with a previous employer for a few years and it's been about two years since I was really working in the system. My potential new employer uses it an…
- I have data on a "copy of construction checklist" that has been shared to me. I am an admin to the shared copy of construction checklist. If the owner of the sheet, cycles data off the sheet due to co…
