Pulling information based on dropdown selection

I'm pulling information from 1 sheet into another to be used as a dashboard reference and i'm having trouble with a formula.. I need to collect names if "awarded" is selected in a separate column's drop-down. Is there a way to do this?

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!