Populate Fields Based on Pull Down Selection

I have a sheet that lists information (Project Number, Project Name, Contact Person, Contact Number, etc) for projects. The sheet is rows containing this information.


I'd like to have another sheet were there is a pull down for are all of the Project Numbers. I'd like for the user to pull down the Project Number and when this happens for the appropriate Project Name, Contact Person, etc from the first sheet to auto-populate on this second sheet.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!