Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

How can I get data to auto populate from a sheet to another when I select a category?

Hello, we have about 280 different type of jobs and I would like my sheet to pull the according salary from another sheet. I would like my cell in sheet A to be auto populated with the salary when I select a job category. The salary infos are in sheet B. The category names are the same in both documents. How would I go about doing that? Thank you!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions