Dynamic Cell Linking... maybe?
Hello all!
I have a template setup with various columns holding information that I pull from another sheet. The information is project specific and I currently copy/paste the information to the template and save it as the location name. My question is if there is a way to automate the creation/population of the template.
For example, I would like the information in the below columns;
To populate into the appropriate cells on my template;
Short of a vlookup, which wouldn't work for formatting I don't think. I've run out of ideas.
Thanks anyone for any ideas!
Answers
-
Mark;
Normally I would recommend researching INDEX and COLLECT.
I use them together to pull data from one source sheet into a target sheet based on a key value in a column in the target that is compared to the matching source column.
I'm not sure of the implications of trying to do so within a template. I suspect the formulae won't be able to discern sheet names properly.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives