Querying a column from another spreadsheet
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?