Report based on specific text in a cell

Devan Hutchens
Devan Hutchens ✭✭✭
edited 12/09/19 in Smartsheet Basics


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.