Pulling specific data
I would like to be able to pull data into a helper/report sheet (H/R) from an original sheet (OS) that follows this criteria
On the report or helper sheet it would be pulling data from a specific cell on a specific row into a column....so...example
becomes
Best Answer
-
I hope you're well and safe!
Unfortunately, it's not possible now to link or use formulas with a report, but it's an excellent idea!
Here's a possible workaround or workarounds
- Export the report to Excel and have an import structure
- Copy the data and paste into an import structure sheet
- Premium App, Data Mesh, or Data Shuttle (Do you have access to these?)
Would any of those options work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
@damon.tackett You could use Index/Match, or you could just directly cell link the information in.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
Thank you @Darren Mullen . So to modify my question a bit....is it possible to index/match or directly cell link from a Report?
Essentially what is happening is I have a comprehensive spreadsheet that I pull a report (OS above) from monthly. It is the refined information on the report that I am trying move to my H/R sheet
-
I hope you're well and safe!
Unfortunately, it's not possible now to link or use formulas with a report, but it's an excellent idea!
Here's a possible workaround or workarounds
- Export the report to Excel and have an import structure
- Copy the data and paste into an import structure sheet
- Premium App, Data Mesh, or Data Shuttle (Do you have access to these?)
Would any of those options work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
thank you @Andrée Starå I will look at those options. I am not sure I have access to those apps.
I will look at submitting it to Product Feedback
-
Excellent!
You're more than welcome!
✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives