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?
Help Article Resources
Check out the Formula Handbook template!