Automatically import data from one sheet to another?
I'm finding a few different answers but not sure which one pertains to my situation exactly. I have created a smartsheet with a form that is an application for students to apply to be a part of a team. I then have a second smartsheet where their applications will be scored. Is there a way to send certain data (not all) from the first sheet (application) automatically to the second sheet (scoring) as it comes in?
I know I can link the cells, but to my knowledge, I would have to go in and link each individual column and it wouldn't be automatic. I'd have to update manually every so often. I've also read about formulas but none of them seem to apply to my exact situation.
Is this possible or no? If so, how, please?
Help Article Resources
Check out the Formula Handbook template!