Translating Data from One Sheet to Another
I am looking for any method that could help me obtain the desired results. I have a tracking sheet titled “PM Sales Tracking” and within the tracking sheet there is a column that is called “Design Request” I have edited the column properties(design request) to a “dropdown list” with values of “yes and no” depending on the project managers needs they might need the Design Dept they might not.
If
Someone is to choose “yes” then I would like the following columns to import over to another smartsheet titled “Design Project Tracker”(or might change title) in the Design Project Tracker we only need certain columns to auto populate with the information for our design team.
If someone is to choose "no" then no information would import over, thus the Design team will know their services aren't needed.
I sort of played around with the Reporting function and it appears that it brings all the information over from the columns you designate however what I am looking for is an option that auto populates when the initiator hits the “Design Request Column” in the 1st smartsheet titled “PM Sales Tracking” I have also used "Cell Linking" however it doesn't produce the results desired.
Comments
-
Hi Marisa,
There are a few different ways this could probably be set up.
Can you maybe share the sheet(s) or some screenshots? That would make it easier to help. (Share it to, andree@getdone.se)
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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.
-
Hi Marisa,
How did it go? Did you manage to get something set up?
Happy Holidays & Happy New Year!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives