Active Reports

Gary Webster

Has anyone out there been able to achieve this?

 

What I would call an Active Report is as follows.

A visually formatted report page that is interactive with a master sheet. The report sheet would be formatted to display a ascetically pleasing presentation of data select from the master sheet by selecting a row. 

This could be easily done by a formula that selects only columns entered into the desired cells of the presentation sheet. Once a row is highlighted on the main sheet or even a check box on the row wanted, the desired cells from each relevant column would display. You would now have a visually pleasing page to present data to customers. 

 

 

Seems simple enough but is it possible?

 

Please do not tell me to use Google docs, far too time consuming. I am currently using excel to achieve this but cannot get the same functionality on smart sheets.

Rachel Ambler

Unsure if this is the sort of thing you're looking for, but I found it on my travels just a few minutes ago when looking for something else

 

http://www.smartsheet.com/blog/calendar-dashboard-7-steps#

Travis

Rachels suggestion of creating a master timeline using cell linking would work great to gather data from multiple sheets into a live summery sheet. You can view the calendar, Gantt chart, and use this tool to export your sheet to a visually pleasing PowerPoint visual. Another option is to use the reporting tool which will pull in data from multiple sheets based on criteria you specify. While Gantt charts and Calendars are not available in reports yet, this feature is currently in development.