Why does Smartsheet only allow you to make a report with columns and not rows? I'm using my sheet to coordinate data for events. Each row has a specific event, each column has different details for the events (date, location, hotel, meals, etc) and I need to take information from only certain rows to create a report for each event, not have columns with every event's information for the whole year. Is there a way to do that?
I can kind of do what I'm wanting to do with the report using a dashboard instead. If I use the metric dashboard widget, can select it to display data from certain cells. However, when I add a form to my master smartsheet for my client to enter information, it creates a new row for the event with the information they entered. Is there a way to automatically add the new row's data to the dashboard so that I can see all of my information for one event that automatically populates? Or do I have to manually enter information from the new row?