Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
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.