Filters for Smartsheet Documents
I am looking to add filters for Smartsheet documents. I am relatively new with Smartsheet and have been tasked with creating some documents and reports. We are attempting to model one of our documents after the picture attached (the first one). Here is a synopsis of several goals we are working on:
1.) One of our goals is to create a giant document with budgeted and actual numbers compiled together, and a detailed breakdown for each month (target numbers, variances, etc.). The data would be embedded and only appears if the user specified the month from a drop-down list (see the second picture). We don't wish to have a plethora of columns flooding the document at any one time.
2.) Another goal is to seamlessly extract data from Excel and cloud-based servers like Spectrum and have that data compiled into a single document. For example, one of our goals is to create a compilation sheet of actual costs that spans all of our departments. This document is envisioned as a "data dump" that would update automatically, or with minimal input.
3.) Lastly, we are looking to create a year-to-date (YTD) filter. In addition to viewing the data for a single month (i.e. July), we would also like to see all of our data from the beginning of the year up until the last full month (i.e. January to July).
Above all else, we value ease-of-use and simplicity. We would much rather have something that is too simple and functional than something overly complex.
Any helpful tips, answers, clarification, etc. is all greatly appreciated.
Thanks a bunch!