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?

Find more posts tagged with

Reports

Support

Conditional Formatting

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

How to restrict Form responses to data existing in the related Sheet
I am trying to create a Form that requires the user to supply information related to any item existing in the Primary Column. If I pull that existing field into my form, the user entry is a free-form field and I can't figure out how to restrict it (other than validating by data types). If I add a new field with a dropdown…
Sheet -Ganhtt Chart
Is it possible to display both the planned and actual duration for a single task on a Smartsheet Gantt chart? I would like the Gantt bar to show the planned duration (e.g., in blue) based on a Planned End Date column, and then show the actual duration (e.g., in green) based on an Actual End Date column. Can the Gantt view…
Color-Coded Tags in Board View
I noticed in the Board View tags are grey by default but in the how to videos, in the Board View some of the tags are colorful. I'd like to leverage that same functionality as I'm building a research repository with many different types of research in it and a visual cue would be lovely. Can anyone assist? I attached a…