count non-blanks in 3 columns based on a specific name in another column
Column A has a mix of 18 individuals in it.
Column B-D have lists of actions they have/have not completed.
I want to count the non-blank (meaning they did an activity) in column B-D only for rows that match a specific name from column A.
Best Answer
-
Are you able to provide some screenshots for context?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Are you able to provide some screenshots for context?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
private info so I can't show, but here is what I'm trying to do with Dummy data. The real data is in Smartsheet.
-
You would need to insert a helper column (text/number) with the following column formula:
=COUNTIFS([Task A]@row:[Task C]@row, @cell = "")
Then you would use a SUMIFS to get your total for each person.
=SUMIFS([Helper Column]:[Helper Column], Name:Name, @cell = "Sample 1")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
let me try it.... thank you.
I know I can do it by converting the data into a separate pivot file as well.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!