Counting open and pending items in another column.
I downloaded the weekly task list template and love how it calculates how many pending items I have open per parent grouping (navy rows). The "Pending" column on the right calculates any symbol that is not green. I want to calculate in the column to the left, the status symbols that are green in the "Pending column" and do it by parent grouping grouping (navy headers). Does anyone know how?
My goal is to have a count that is pending and a count that is completed.
Answers
-
Try this...
=COUNTIFS(CHILDREN([RYGB Column Name]@row), @cell = "Green")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!