Workflow Automation - update copied rows

My colleague and I are coordinating a client referral project and have each created a sheet to manage different parts of the process. Since the two sheets include overlapping data (client name, status, referral date, etc) we need to automate a workflow to push information from her sheet to mine. The workflow to copy new entry rows to mine works fine but we are struggling with automatic updates to rows that have already been pushed over. Ideally, we would like updates in existing rows such as status and call dates to also update in my sheet when changed in hers. We’ve tried adding conditions to the trigger but end up creating duplicate client rows instead of updating one that has already been pushed over. Can you offer a suggestion on how to properly define a workflow automation to update existing rows in another sheet? Or perhaps there is a better method of accomplishing this?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!