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?

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

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?

J_V

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.

Paul Newcome

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.