Change Dashboard/Report based on choosing a piece of information
I am a relatively new Smartsheet user. I started a new job a couple months ago and my office wants to start using Smartsheet more and I've been tasked with getting up to speed and finding ways to help make things run more efficiently using Smartsheet.
I currently have separate smartsheets for booked jobs, invoices, purchase orders, and equipment for all jobs we are currently working on. Each sheet has a parent row for each job with the children rows being the individual job booking/change order booking information, individual invoices, purchase orders, etc.
Is there a way to build a report or dashboard that would allow me to pull all information from each sheet or report to one centralized place based on the job number, if the job number were in the same format, etc. in each sheet?
If so, is there a way to add a dropdown box with each job number to change from job to job on the same dashboard?
Like I said, I am still fairly new to all of this, so I am still figuring out the capabilities and limits of Smartsheet.