Bring in data from multiple sheets

Hi, I'm fairly new to Smartsheet so apologies if this is obvious. I am essentially trying to bring information from 2 sheets which I can then edit or work on. Some background..

We have a sheet which details resourcing for ongoing projects (backlog) and another which contains information on the pipeline. The backlog gives resource days for the coming months whereas the pipeline has only the total project value, and the planned start date.

I would like to have one sheet which shows all projects (both ongoing and future) with resource days for coming months which either feeds through from the backlog or can be edited for the pipeline. I would also like to be able to add totals lines and formulas. I can produce a report, but I can't make any edits in the report but if I make a sheet, then the project names etc are not dynamic and new lines for new work would have to be manually added.

Is there any way to have a sort of combination of a report and a sheet to do what I need?

Find more posts tagged with

Project Management

Comments

p_bureau

Hi.

Short answer : no you can't!

If you want advanced manipulation and visualisation of your data you can connect your sheets to Excel (see http://smartsheet-platform.github.io/odbc-docs/). but then you want be able to send data back to SmartSheet...

Please let me know if you get better ideas!

Best Regards,

Paul.

Bladerunner

I'm not sure if this helps, but I have used the Kanban sheet to link through to multiple sheets which gives me view in either grid or card, then write a report against the Kanban sheet, the values in the sheet update whenever the source sheets do, so the report is always current. I have multiple sheets for costs, plans, checklist etc and then reference the relevant fields in the Kanban, I am also able to create a RAG status across multiple sheets.

Kind regard.. Ben.

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to prevent a shared user from seeing the data in the "View Detail" option?
Is there a way to prevent a shared user from seeing the data in the "View Detail" option? I'm trying to make sure that when a user is given access to view a report, they can only view the columns present in that report. The view might only show certain columns but the user can then click on the record as shown below and…
Gantt Chart Timescale not aligning with projects fiscal year and start/end dates
I have a project sheet with a Gantt chart where the timescale headings are not aligning with my project’s fiscal year and start/end dates. Configuration: - Primary heading: Quarters (displaying as Q4 2026) - Secondary heading: Months (MMM format) - Fiscal year start: February 2 - Week start: Sunday - Project start date:…
Changing how items are displayed on the calendar
Is there an overall calendar setting whereby I can choose a specific column to display in the calendar view? I have created an additional column that gives the task name (located in a child row) as well as the main task (in it's parent row). I want that to display in the calendar. Overall creating a content calendar and…