I have a master project tracker sheet with a workflow to copy rows per division to it's own sub sheet. Updates will be made to the master sheet and need to be auto updated in the sub sheet too. Is there a way for updates to occur in both sheets?
Depending on the specifics, it might work with cross-sheet formulas and VLOOKUP or a combination of INDEX/MATCH.
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])
I hope that helps!
Have a fantastic weekend!
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help 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 for help with Smartsheet, integrations, general workflow advice, or anything else.
Thank you for the reply
The master sheet lists all global projects our team is working on, I've set up a condition to copy a new row into a separate division sheet (if A division is chosen in the master, then that row copies to A division's sheet) Then the division sheets are shared with division contacts that need access but don't need access to all divisions.
But we'd like to update the projects in the main sheet vs. in 2 places. I'd like to avoid a report since we may give divisions access to edit. thanks for any insight
Happy to help!
Is there something unique that identifies the projects?
Yes, I have an auto-number column to assign a number to each project as they are entered
Then we can probably structure it with cross-sheet formulas and VLOOKUP or INDEX/MATCH.
Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
I'm working on a compensation request form that follows these steps: An HR Business Partner completes the Compensation Request Smartsheet Form that then triggers an alert to our Compensation Manager. Our Compensation Manager will insert the requested information. The HR Business Partner will be alerted when the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.