Report Building with Dashboard Publishing

I have started developing a report.

Is it necessary to create the data sheet (which will drive the report) in a seperate smartsheet from where all my entries are or is it OK to build the data on the same smartsheet by adding columns and then hiding ?

Find more posts tagged with

Manufacturing

Comments

Andrée Starå

Hi Steve,

It depends!

There are many factors to weigh in what would work best.

What do you want to show?
How clean do you want the main sheet to be?
Will you add other sheets to the report later?
And more...

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Alejandra

Hi Steve,

It's not necessary to create a separate source sheet for your report —you can certainly report off hidden columns. However, keep in mind hiding is not a security feature. Collaborators with Editor and Viewer access won't be able to unhide the columns within Smartsheet, but they can export the sheet to Excel or send it as an Excel attachment and un-hide the columns from that program.

If needed, more information on this can be found in our help article: https://help.smartsheet.com/articles/504696-hiding-unhiding-columns

Sign in to join the conversation!

Quick Links

Trending discussions

Mr
hi would like to create a simple patient tracking system for our small clinic where i can record the time & duration a patient appeared in our establishment. Using a central sheet where it records all the data to be accessible by the admin. There will also be Four (4) forms to be accessible by the three department. Concept…
Forms
On the App - "In Smartsheet forms, is there a way to capture or upload an image directly into a specific column cell (per row) without using the Attachments field? I need each section of the form to have its own dedicated image, not just general attachments for the row."
Smartsheet Mobilizer Kit2/Best Practices
Hi - I am launching Smartsheet sessions at my organization for the next 3 months. The SS Mobilizer Kit2 Workspace I saved a few years back, the files are not loading. Is there a new resource kit? Also, I am writing up some best practices for our users: Examples: Names, separate first and last name into two columns. Email…