Pulling Data from Smartsheet with a form to another Smartsheets
Hope someone can help!
I have a form set up on one smartsheet (1) which is to be sent to new onboarding colleagues to get some information. When the fill this out this auto-populates the rows in that smartsheet (1) which is fine.
But I have their names listed on another smartsheet (2).
Once they have filled in the info on the form from smartsheet (1), and selected their name from the drop down, I need all data to then transfer to the other smartsheet (2).
Is there a formula for this?
I tried cell linking but it erases the names from Smartsheet (2) which I need to keep.
Help Article Resources
Check out the Formula Handbook template!