Using Data uploader and Hierarchical sheets

Matt Gratton

I have a project schedule sheet, within it i have parent/child rows outlining each workstream (parent) and associated tasks (Child rows). There may be up to 10 parent rows and up to 20 child rows per parent.

I am looking to use the data uploader to bring in detail to the child rows, for the most part our resource planning is done on a 3rd party solution. I can export that out to xlsx and use the data uploader to bring in this detail.

However, i can only get the imported data to appear at the bottom of my worksheet, is there any option to match to the child rows? Or perhaps an alternative solution?

JeremiahHorstick

@Matt Gratton

Shooting in the dark here. Maybe VLOOKUP the data on a separate sheet where you are using Data Uploader.

Matt Gratton

Thanks for the reply @JeremiahHorstick - i was considering something along those lines but i havent tried as yet. Will try and mock something up soon.

Matt