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?



  • Paul Newcome
    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?

  • 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
    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!