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.
Dashboard widgets are currently mostly static. I can display counts and charts, but I cannot click into a specific part of a widget to drill into the underlying records. It would be a big usability improvement if widgets supported interactive drill-down. For example: Click a bar segment (or stacked segment) to open the…
I had Technical Support Case #09045069 in relation to this issue. I was told to get the API documents corrected, I needed to post to here. Update API Documentation Some (all?) of the API calls related to Alternate Email Addresses require both an Enterprise Account and to be manually activated by Smartsheet Support. The API…
Dear Smartsheet, You really need to add an administrator-controlled option to manage the license banner display for free users. The banner not being able to be removed by the administrators presupposes that the administrator wants the free users to have licenses. One of the main reasons we love Smartsheet is the ability to…
