Question on auto-population between sheets
I am trying to setup some sheet automation as follows:
- Program Manager sheet: Tracking ID is auto-generated using auto-numbering
- When a new tracking ID is generated would like to populate that new ID into another Master worksheet into next available row
- Then that Tracking ID would be populate into individual program manager's worksheets if assigned to them in the next available row
- Also within these spreadsheets looking for data to flow between based on Cell Links, but can't find a way to copy cell links from an existing row to new row. Is there a way to setup cell links for all rows in a sheet and when a the primary key (Tracking ID) is entered in a new row all of the other cells with auto-populate without user intervention?
I have exhausted options from looking at different Community posts.
Any insight is appreciated.
Answers
-
Datamesh can do what you are describing. Its a premium app but maybe check out the link below and see if its a good fit.
https://www.smartsheet.com/marketplace/premium-apps/datamesh
0 -
It sounds like we could set something up with cross-sheet formulas and the automated copy/move row workflows.
What do you think?
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 help the Community by marking it as the accepted answer/helpful. 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: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
0 -
Depending on the exact needs, it almost sounds as if Reports could work as well.
thinkspi.com
0
