Create a list from column data within existing(current sheet)
Hi All,
Quick query, I have a sheet of data with my Issue Key column holding data that I want to reference. I have a secondary column that i want to have a list generated based off that data. this is all within the current sheet.
so;
Issue Key | linked item
a | (this is a look up that contains a - e)
b | (this is a look up that contains a - e)
c | (this is a look up that contains a - e) .....
d |
e |
I'd like to be able to select multiple items if possible with out additional sheets and hundreds of helpers.
Any thoughts?
Thanks TWC
Best Answer
-
Hi @TWC
If I'm understanding you correctly, as values are added into one column (Issue Key), the same value appears in the dropdown list as part of the column properties of the second column.
So if this is the current list:
Then I add another row with a unique value:
And that value appears in the dropdown. Is this your request?
If so, this currently isn't possible in the core Smartsheet application, but if you have access to either Bridge or DataShuttle you can update column properties automatically.
Here's more information: Update your dropdown columns with Bridge workflows and Create an upload workflow in Data Shuttle
Please feel free to add your vote and voice to this Product Idea thread: Datasources for Dropdown Menus
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
just to add for clarity, an item listed, say Issue Key D, is connected to the Issue Key A I want to be able to select that Issue Key D is linked to Issue Key A.
This is not a smartsheets link just a parent child type situation. The challenge i have is taking all the data in column "Issue Key" and adding this to a drop down in Column "Linked Item"
hope that adds some clarity
thanks TWC
-
Hi @TWC
If I'm understanding you correctly, as values are added into one column (Issue Key), the same value appears in the dropdown list as part of the column properties of the second column.
So if this is the current list:
Then I add another row with a unique value:
And that value appears in the dropdown. Is this your request?
If so, this currently isn't possible in the core Smartsheet application, but if you have access to either Bridge or DataShuttle you can update column properties automatically.
Here's more information: Update your dropdown columns with Bridge workflows and Create an upload workflow in Data Shuttle
Please feel free to add your vote and voice to this Product Idea thread: Datasources for Dropdown Menus
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Genevieve, Sadly, Yes this answers my question. not the way I wanted but now I know. I was trying to look at a way to link Subtasks to Tasks, Task to Stories...... in a more programmatic way that would allow me to work with Jira a little better. Will see if we have either of the 2 options. Many thanks for the detailed reply. - Happy Holidays!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!