Update a copy row

Hello,

I have a form that is feeding a master sheet, with an automation to copy rows to separate sheets assigned by state.

I'm looking for a way to update the information so that it stays consistent on the master sheet and the separated sheet where the row was copied to.

The only solution I can think of is to have an update request automation on the master sheet, and another automation to copy again when it changes, but that would leave two records instead of just the updated one. Is there any way to avoid that so it is just one row per submission, even if an edit is needed?

Find more posts tagged with

Accepted answers

All comments

Kiela

Hi,

I too had the same issue, the sheets generally have a one-way flow. After talking to someone at Smartsheet I was advised I would need to have the Data Shuttle licence to be able to do the same thing as you are after.

Andrée Starå

Hi @Desertbird

I hope you're well and safe!

Do you only need to be able to update the Source sheet and then have that reflected on the Destination sheet?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Gita Mooney

To answer this comment -

When you do use the Data Shuttle, it does not update attachments, comments etc. Just FYI

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.