Formula to move over one cell
It looks like there's not yet a solution to move over columns/selected data from one sheet and merge it into another. However, I was wondering if I could move over one cell from sheet 1, based on an update in Sheet 1, into a cell in Sheet 2.
Sheet 1. Approved Column is updated to "Yes, Approved..."
Sheet 1. Student ID# would copy over
Sheet 2. Student ID# from Sheet 1, would copy over to Student ID# column in Sheet 2.
I can create a match formula to bring over name and email. I just need to get the Student ID# from Sheet 1 to Sheet 2, but ONLY when the Approved Column from Sheet 1 is updated to "Yes"
Help Article Resources
Check out the Formula Handbook template!