Creating monthly reports and accessing via dashboard
![K.Nixon](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
We use a sheet to track our monthly WIP (work in progress). How do I create a report for each month so that, if needed, we can go back to look at previous months to see the trend? I'll post a screenshot of a sample. We did this previously in Excel, had tabs for each month and the Prior Change column would populate from the Trending Change column in the previous month's sheet. I believe once the information is cleared in the sheet, it will clear the report as well, correct? We need to see everything as is but not be able to change any information once the next month comes around.
Answers
-
You could replicate your existing Excel progress in Smartsheet. Think of each Excel tab as a separate sheet in Smartsheet. You can create links between two Smartsheet sheets just like you can between Excel tabs. At the end of each month you could lock all of the previous month's sheet columns to prevent future changes.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives