Update Sheet 1, Based on Submission to Sheet 2

I have a quick question. I have 2 sheets (Sheet 1 and Sheet 2). In Sheet 2, users submit a form and a field (which is hidden) is automatically checked indicating it's been submitted. What I'm wanting to do is - essentially - notify Sheet 1, that a user submitted something on Sheet 2.

My first thought, is to use a VLOOKUP between the sheets, but I'd like to stay away from that if possible. Any other solutions that might work?

Find more posts tagged with

Formulas

functionality

Cell linking

Accepted answers

All comments

Danielle Roach

Use the copy row function - note the column names will have to match or it will add the unmapped columns to the end of sheet 2

Mike Rini

Thanks. That would work, but Sheet 1 already has a mirrored row, with all the same data in it, that Sheet 2 is receiving.

What's happening is that, people submit a form in Sheet 1, that in turn creates a dynamic/query URL for them to then re-submit (essentially) the same data in Sheet 2 (there's a logical reason why). When the information hits Sheet 2, I'd like Sheet 1 to know.

I have a VLOOKUP, and it works, but I just don't love them because they can break so easily if you move a row.

Andrée Starå

Hi @Mike Rini

I hope you're well and safe!

To add to Danielle's excellent advice/answer.

When you say the VLOOKUP break, what do you mean?

I'd recommend using a combination of INDEX/MATCH instead. It's more secure and takes fewer resources.

Would that work/help?

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 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!

Mike Rini

Sorry, when I say break, I mean if somebody moves a column around or something like that. They're nice, but if you have to span 50 columns, and the sheets grows in length (in terms of rows), it can get taxing

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.