Pulling specific data

damon.tackett

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

Andrée Starå

Hi @damon.tackett

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!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

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!

Darren Mullen

@damon.tackett You could use Index/Match, or you could just directly cell link the information in.

damon.tackett

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

Andrée Starå

Hi @damon.tackett

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!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

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!

damon.tackett

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

Andrée Starå

@damon.tackett

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!