Creating different sheets based on one main sheet.

Hi everybody,

I need to create separate sheets containing different information from one master sheet. But I also need to configure this in a way that if a new row is added to the master sheet, it will automatically be added in all other sheets that I created based on the master sheet.

Any help is appreciated!

Find more posts tagged with

Sheets

Comments

Mike Wilday

Hi Refael,

Smartsheet Reports will be your best friend in this instance. You can create a report that pulls only certain information from one master sheet into a report that allows users to view and edit specific rows that apply to whatever criteria you deem should be in the report. Reports are not smartsheets, but an aggregated collection of data from your master sheet. PLUS: if you give someone editing access to the report, they can make changes in their report that will feed back into the master sheet.

Creating Reports in Smartsheet

Fabian.Murcia

Hi, I would also like to accomplish something like this but with the addition that I would like to use the info generated on those reports to create dashboards and use them in formulas in other sheets, however, I can't reference reports in formulas. Is there a way to do this?.

Thank you.

Mike Wilday

Can you provide a clearer example of what type of formulas/generated info you are wanting to capture? If you're wanting to provide counts of items that are in a report, you can easily create a countifs statement that is measuring against the same criteria that your report is using to pull the data and count those items.

Fabian.Murcia

Thanks for your reply Mike, the problem I am facing when trying to do that is that even though I can reference other sheets to perform "COUNTIFS", a report I created can't be selected as a reference for me to get the counts from it.

Mike Wilday

Correct. That feature is not available. But you should be able to use a COUNTIFS to pull the same data/numbers that you have in your report, using the same criteria that you used to create your report.

On a side note: Please submit an enhancement request for the ability to do COUNTIFS on report data. A number of us in the community have requested this, your vote being added would be helpful.

Sign in to join the conversation!

Quick Links

Trending discussions

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…