Sign in to submit new ideas and vote

Reference Reports in Formulas (e.g. VLOOKUP) to sheets

Options

Alex Carter

Alex Carter ✭✭

07/08/22 edited 07/14/22 in Smartsheet Product Feedback & Ideas

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.

Tags:

8

8

8 votes

Idea Submitted · Last Updated 07/08/22

Comments

ker9 ✭✭✭✭✭✭

01/08/24
Options
Index & Match to report would be helpful as well. I have a report that pulls together data from 200+ sheets.

0 · Share on Facebook Share on Twitter

FAQs and Guidelines for posting Product Feedback Ideas
Hi Community, Welcome to the Product Feedback and Ideas space where you can help shape the future of Smartsheet! We really appreciate your feedback and will take all posts into consideration. Our product team will review top ideas and requests monthly and we'll share updates as soon as we get them. Remember: if you have a…

Categories

Trending Ideas

Gantt View Duration Zoom Levels
Now that we can add sub-second durations, please allow a zoom level that can view such durations. I need to visualize processes that are on the order of milliseconds.
Data Mesh: Stop feeding Deleted Rows to Data Mesh sheet
I was told that once rows from a source sheet make their way to the Data Mesh sheet, there is no way to remove them. Even though the rows may no longer exist in the source sheet, you can't prevent them from showing up again in the Data Mesh sheet. My source sheet (report) is pulling from multiple projects so it's not…
More Robust Backup Platform
There have been many requests for a more robust Data Backup/offload system because the existing system is inadequate. Smartsheet is simply not a viable option for data management in regulated spaces until: 1. Backups are more easily automated (Can't you just make a Data Shuttle checkbox to prevent replacement of previous…