How can I count by date?
I attached a screenshot of my sheet. I want to count the number of Block ID instance per date. Any tips?
The end result would be a count of Block IDs in each cell that has a "Hierarchy Translation" == Date
Best Answer
-
On your Date row (top hierarchy level):
COUNTIF(DESCENDANTS([Hierarchy Translation]@row), "Block ID")
This will count any rows which are descendants (not just child rows, but also children of child rows) of the Date row, where the Hierarchy Translation cell contains "Block ID".
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
On your Date row (top hierarchy level):
COUNTIF(DESCENDANTS([Hierarchy Translation]@row), "Block ID")
This will count any rows which are descendants (not just child rows, but also children of child rows) of the Date row, where the Hierarchy Translation cell contains "Block ID".
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 439 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives