Build a report that includes user input
I have a smartsheet with approx 30 parent rows and anywhere from 30-65 child rows per parent.
I need to provide numerous individuals with reports for individual parent rows. Can a report be 'dynamic'? i.e., report requires input from user (preferrably by selecting from a dropdown) and then the report is generated.
I realize that I can accomplish this by using 'filters', however, the individuals requiring the data are not normally Smartsheet users and so my hope was to make this as simple and quick as possible.