I am using smartsheet to collect problems and ideas coming from various areas of our company.
As a result I have a large sheet in smartsheet where all the data is being collected and then I am using sights to display an overview of problems and ideas.
My query is where is the best place or method to gather all the information I want to display in the sights dashboard. Currently my sheet has about 30 rows at the top of the sheet that are locked where all the formulas are calculating the information I want to display in my sight sheet, but they are not very good looking and get in the way when users want to filter the sheet.
My questions is can this be done in a better way where the correlation of the information I want in my sight is not displayed at the top of the sheet my users are using to enter information.
Hope that makes sense.
Thanks
Jon
