Querying a column from another spreadsheet

shecodesit ✭✭
edited 12/09/19 in Smartsheet Basics

I have two tasks sheets. I use one to monitor "projects". I use another to monitor "tasks". I would like to add a column called "Associated Project" to the tasks sheet.  I know I can go in individually to each cell and have it link to a cell in the projects sheet. I also know I can set up a dropdown list with a projects.  Can this list be dynamic and associated with a column in the project smartsheet?