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.
As one of the system admins, it is absurd to me that I cannot view or have access to all of the items created in my organization. We have over 11,000 reports, sheets, and dashboards and I can't see them. I have no visibility to if people are using our plan for their own personal use, or what kind of work is going on unless…
I noticed this the other day and tested Ctrl + M – it does not work. I submit ticket to Smartsheet support – they told me that’s expected behavior because it’s not currently available even though it still shows as keyboard shortcut in the menu🙄 and told me to submit new product idea. Please add this keyboard shortcut to…
Summary of Issue All team members work a standard 7.5‑hour day, but only a portion of that day is allocated for project work (e.g., 25%, 50%, etc.). In Resource Management, however, the system currently interprets allocations as a percentage of the full 7.5 hours, instead of the project‑eligible portion of a person’s day.…
