Summary
I am trying to find a way to do a monthly summary of the number items each month in Published, and Expired Alert Status.
Does anyone know what would be the best way to complete this?
Thanks!
Kristie Diersen 😀
Best Answer
-
Try something like this...
To get Published:
=COUNTIFS(CHILDREN(), @cell = "Published")
To get Expired:
=COUNTIFS(CHILDREN(), @cell = "Published")
To have them both displayed in an easy to read format within the same cell (enable text wrapping)...
="Published: " + COUNTIFS(CHILDREN(), @cell = "Published") + CHAR(10) + "Expired: " + COUNTIFS(CHILDREN(), @cell = "Published")
This will display it as
Published: #
Expired: #
within the same cell once you enable text wrap.
Answers
-
Try something like this...
To get Published:
=COUNTIFS(CHILDREN(), @cell = "Published")
To get Expired:
=COUNTIFS(CHILDREN(), @cell = "Published")
To have them both displayed in an easy to read format within the same cell (enable text wrapping)...
="Published: " + COUNTIFS(CHILDREN(), @cell = "Published") + CHAR(10) + "Expired: " + COUNTIFS(CHILDREN(), @cell = "Published")
This will display it as
Published: #
Expired: #
within the same cell once you enable text wrap.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!