Querying a column from another spreadsheet

shecodesit

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?

 

 

Andrée Starå

Hi,

I have a workaround for a dynamic project list, but it only works on the desktop and not the mobile app.

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

shecodesit

It would as I don't use the mobile app anyway.   What is your idea?

Andrée Starå

Ok.

Here's a link with an explanation on how it's done.

Link Reference Sheet Dropdown

Let me know if you have any questions or if I can help you with anything else!

Best,

Andrée