Dashboard with Set Time Frame Options
NOTE: I am a Smartsheet novice.
I need to set a formula I can use for setting up a dashboard that counts specifics within set date ranges and enables users to see data sets within specific time frames. For example, 14 days ahead, 30 days behind.
Can please someone assist?
Answers
-
Are you able to provide more context? Are you looking for the date ranges to be dynamic? Would they be based on today's date? Are you wanting to give users the ability to adjust the date(s) without having to edit the formula?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Ideally I'd like them to have flexibility to pick their own date ranges. If that flexibility isn't possible, perhaps have charts that show from today 7 days out, then 14, 21, 30 and retro 7-14-21-30.
-
The flexibility is technically there, but it does not scale well beyond a single user making selections.
Providing charts that are based off of today's dates and go out a set amount of time in either direction is definitely very doable, but to give a more specific response on how, I would need more details on what we are working with.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!