Creating dashboard chart using "Date Created" column?
Hey everyone.
Here is what I'm hoping to do. I have a single smart sheet containing containing about 4 months worth of lines. I essentially want to create a bar graph showing the number in lines created by month. (So how many were entered in June, July, August, September). I have an automated date created column to show/record date of entry.
Is there a simple way to do this?
Answers
-
Happy Friday there,
You can create a formula in sheet summary with the month June, July, August, September and create a graph via sheet summary.
=COUNTIF(Created1:Created260, MONTH(@cell) = 7)
=COUNTIF(Created1:Created260, MONTH(@cell) = 8)
=COUNTIF(Created1:Created260, MONTH(@cell) = 8)
=COUNTIF(Created1:Created260, MONTH(@cell) = 9)
Note that When the MONTH() function contains a blank cell within the range of dates it is reviewing, it will produce the error displayed in the “Result” for this row. This is expected behavior. To resolve this, you’ll want to utilize an IFERROR() function.
For more info, https://help.smartsheet.com/function/month?frame=0&nav=1
If you continue to have a new entry, I would suggest having a helper column with this formula to extract the month and do a count if
=MONTH(Created@row)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!