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.
Tags:
0
Answers
Hi @Jonathan Kearns
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
Matt Johnson
Sevan Technology
Smartsheet PLATINUM Partner
Hi @Jonathan Kearns
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 PARTNER & CONSULTANT / EXPERT
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.
Depending on the exact needs, it almost sounds as if Reports could work as well.
thinkspi.com