It would be so nice to use a VLOOKUP to reference a report and pull what I need back to my sheet. Unfortunately, sheets can only pull from sheets.
Sign in to see the current vote count, add your own vote, or leave a comment.
Would be very helpful to create a formula range from a report, and not just from a sheet. This is helpful to pull in data that is organized in a different way in reports vs sheets.
Index & Match to report would be helpful as well. I have a report that pulls together data from 200+ sheets.
This would be helpful for compiling data from multiple sheets to a report. Then allow you to access the counts from a simple crosssheet formula. Currently if you have a report combining sheets but need cross sheets formula to reference the data you have to create it going across each sheet that' has already been consolidated to a report.
I have several projects that utilize a standard set of sheets that I have created. One of those is a sheet that tracks the overall KPI's. I then have a summary sheet that references each of the KPI sheets that shows totals for each region and office of the projects. The problem I have is that I have to link each cell in each sheet individually to get the data I need. I have tried using a report for this, but the column summaries don't offer the types of calculations that I need for rolling up. Therefore, the easiest solution I could think of would be to create a report to which I can add each project and then reference the report via a formula in my summary sheet. The only problem is that is not currently a feature offered. I hope this is a feature that will be considered in the near future!
This would be GREAT. Having a way to reference a report, which aggregates data from multiple sheets, would be optimal for various tasks.
I recently submitted an idea asking for a way to compile multiple sheet's into one compiled sheet. But having the ability to reference a report essentially does the same thing.
Fully support this idea.
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…
There is currently a Hubspot integration readily available to connect data into Smartsheet.com We have received an increased need to be able to also connect Hubspot data into smartsheet.eu Is this on the roadmap? If not this would be a great enhancements for many customers.
