Hello,
I have a data sheet used for a call log for project issues. I'd like to be able to run a report that displays all calls for a specific serial number based on which serial number is entered into a cell, a variable search value. Ideally, I would have a dashboard with a web content widget that would be looking at a sheet. The user would be able to input the project serial number, save and refresh the dashboard. A report would be below the web content widget with all entries for that serial number. I realize the user could go directly to the sheet and filter the project number, however, I don't want multiple users filtering and sorting data at the same time to avoid potential issues.