I am trying to create small chart for dashboard
I have a master sheet that has 100 projects all different end dates. Trying to find a formula or method create small chart like a sample
Jan 2022 - 4
Feb 2022 - 3
Mar 2022 - 4
Etc...
Answers
-
You would need to create a table in a sheet and have each label in a single column. From there you can use COUNTIFS formulas to get your counts.
=COUNTIFS({Source Sheet End Date Column}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2022))
-
I get unparsable can you give me an example if I ask kindly?
-
My last post is the example. Are you able to provide some screenshots for reference?
-
A bit more cleanup
-
Is there a way to filter out a third, ie I don't want completed projects.
-
To include another range/criteria set in a COUNTIFS, you would follow the same syntax of range comma criteria.
=COUNTIFS({Source Sheet End Date Column}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2022), {Range 2}, criteria 2)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!