Can I partially mirror a sheet?

Hi, I hope someone can help me with this.

What I'm trying to do is find a way to automatically share some information from a sheet into another. For instance, I want to have a sheet with all the relevant information for the company's projects, including financial information. Then have another sheet mirror most of it except the financial part. I would need both sheets to update automatically when the other is modified. As I understand it, simply sharing the sheet with the financial columns hidden would be an option, but the problem I see with that is that both sheets would often need to have someone working on them simultaneously, and that would expose the financial info frequently.

Is there another way to do this?

Thanks

Find more posts tagged with

Finance

Sharing and Collaboration

Project Management

Cell linking

Enhancement Request

Account and User Management

Comments

steven.reed14881

Ernesto,

If I am understanding your question properly, that is very simple to do in Smartsheet. Your first sheet would contain all project information, including the financial data. That would be shared with anyone required to update/maintain the data contained within that sheet.

The easiest way to present the second part of your request--the limited data set with no financials--would be to create a report pulling from the first sheet those elements that you want to share more widely. That report would be shared with the others that only need the smaller subset of data.

You could also present that report on a dashboard, if there were other Smartsheet elements that you want to share in a single view. Both the report and dashboard dynamically update when the underlying data is revised and saved.

Hope that helps. Let me know if there are other questions.

Steve

MichelleMWatkins

In addition to what Steve outlined, you can also cell link from one sheet to another.

https://help.smartsheet.com/articles/861579-cell-linking?frame=0&nav=1

Ernesto Tapia

Hi Steve, thanks for the reply,

I thought about that, but there's a problem with that. Both the full sheet and the smaller sheet need to be edited. If I do it through a report, this report cannot be modified, only the full sheet with the financial data. I understand that once the full sheet is modified, the report is automatically updated, but there will be instances when the smaller sheet will need to be edited for the info to appear in the full one, and that can't be done with a report.

jasonz

Hi Steve,

I tried to build report as you suggested, but it seems like if the financial data is a subset of the sheet, the sheet needs to be shared with the viewer first, otherwise the report will be blank. But if the entire sheet has been shared with the user, it will not make any sense to hide any financial data. Is that correct?

https://help.smartsheet.com/articles/520104-share-sheets-reports-dashboards

FireShot Pro Screen Capture #093 - 'New Blank Report - Smartsheet_com' - app_smartsheet_com_b_home.png

FireShot Pro Screen Capture #094 - 'Share Sheets, Reports, and Dashboards I Smartsheet Help Articles' - help_smartsheet_com_articles_520104-share-shee.png

Sign in to join the conversation!

Quick Links

Trending discussions

Sheet -Ganhtt Chart
Is it possible to display both the planned and actual duration for a single task on a Smartsheet Gantt chart? I would like the Gantt bar to show the planned duration (e.g., in blue) based on a Planned End Date column, and then show the actual duration (e.g., in green) based on an Actual End Date column. Can the Gantt view…
Color-Coded Tags in Board View
I noticed in the Board View tags are grey by default but in the how to videos, in the Board View some of the tags are colorful. I'd like to leverage that same functionality as I'm building a research repository with many different types of research in it and a visual cue would be lovely. Can anyone assist? I attached a…
Can we run the request for update to include all the rows that applied to one condition?
We want to know if it is possible to send request for update in one email, but with multiple rows at the same time. For example, staff A has 4 open referrals, I want to send one request for update automatically to them where they will receive only one email without having to overload them daily with all the open referrals…