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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!