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?