How to pull data from one sheet to another easily
Hi everyone, I manage smartsheet for my company even though I have nothing even resembling training in spreadsheet manipulation, formulas, etc. So I'm just learning on the fly. We have one sheet that has all of the projects we are currently working on, listed by project number and then a bunch of data specific to the project, each project only taking up one row. We have a few other sheets that reference those same projects from the first sheet, but for different purposes. What I'd really love to do, is set it up so that when I punch in the project number in one of those secondary sheets, it scans the first sheet for that number and auto inputs several relevant data points so we don't have to manually do it for every project. Is this possible? If so, can someone explain to me how?
Help Article Resources
Check out the Formula Handbook template!