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…
Currently, when using Automation to send Update Requests, there is no way to enforce mandatory (required) fields for users completing the request. This creates data quality issues, as users can submit incomplete updates, even when certain fields are critical. Proposed Enhancement Add the ability to mark specific fields as…
