Dashboard - Roll Forward
DanniB
✭
Hey there!
I have a dashboard that monitors the status of tasks for Financial Quarterly reporting.
To start a new Quarter, I have to manually change the reference sheet from Q1 to Q2 for all the formulas in the sheet as I have to set up a new plan to reference. Is there an easier way of doing this? Would it be just to use the original sheet and change the name?
Many thanks in advance!
DB
Answers
-
-
Im using several chart widgets and some metrics too :)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives