Pull Data for Current Month
We are a construction contractor that uses smartsheet to track all of our projects. I am trying to set up a dashboard to show the current months quotes and current months jobs sold.
In the past I have just run a report and then put the date between (1st and last of the month). This gets me the data I am looking for.
But I am wanting this to auto generate and constantly have the current month on the dash board without me having to update it.
I would also like to have this in a chart on the dashboard.
I also was able to pull my totals for amounts quoted as a metric on the top of my sheet using (sumif), but can not figure out how to do that for the current month as well.
Does anyone have any idea how to do this?
Thanks
Comments
-
There are a few ways to do this. Most of them involve the TODAY() function though. How often does the data sheet get opened/activated?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives