I have a master file where it is multiple rows, what I need is make each row as individual smartsheet and whenever I update the Row in a master file the changes should also reflect in the respective individual smartsheet. Please assist me.
I hope you're well and safe!
You could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
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.
Hi @Andrée Starå - Thank you for reviewing.
If in case I add the attachments to the rows in the source sheet will it get added to the destination sheet when I use the cross sheet function. Please assist.
Please someone help me on this request.
Happy to help!
Unfortunately, no the attachments aren't synced. You'd need to use a 3rd party integration or the Smartsheet API. Another option could be to copy over the row when attachments are added.
Would that work/help?
@Andrée Starå - yes when ever the data changed or attached/comments added in to the row, the entire row can be copied automatically to the respective destination sheet by replacing the old row. Please assist me how to do that
It will not "replace" the old row, but it would add a new row to the sheet.
@Andrée Starå - thats fine. please let me know how we can add the row to respective destination sheet.
You'd use a copy row workflow.
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Hello! I created two sheets with separate forms and when I checked to see if anyone had submitted the forms yet, I didn't see anything on either sheet but when I click on "manage forms" it says that there are 62 submissions for one and 18 for the other. How can I fix this so I can see what people are submitting?! Thank…
I have a Smartsheet tracker that has been tied to one report. I recently created a second report that pulls similar information from the same Smartsheet tracker and that is working fine. However, the other report no longer shows any data in it for me or others. I have verified that we have admin access on the original…
we are looking to migrate out of smartsheet and are needing to export all of our sheets out and store them in onedrive. what is the best way to preform this?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.