Can you create a report out based on a single row of data?
I am using a smartsheet form to collect location assessments and have the data plus additional fields for score calculations populating in a grid. The smartsheet will house multiple, on-going location assessments so that we can evaluate certain criteria overtime and compared to other locations. However, in addition to comparative data, I would like to be able to provide each location with a report out of their individual score with assessment questions, so only for that one row. Ideally this would look similar to the form but with content and add in the score calculations.
Is there a way to do this so that I don't have to manually pull data into a different format each time an assessment is completed? I know you can export a file and delete other rows, but would like this to be a little more user friendly looking. Is there a way to possibly have a dashboard auto created each time a new assessment is completed?
Any ideas or thoughts are welcome!