Using the same column in more than one sheet.
I have one sheet created of active projects with columns such as project name and department. I need to create another sheet that will have mostly different information but the project list and departments are the same (both are drop downs). Instead of recreating these columns, can I reference these columns in the new list? This is not inserting a value based on a selection in the column of first sheet but having the same drop down lists in both sheets (one column in use on two sheets) so when a new item is added to the drop down of the project list in the first sheet, then it is shown as an option in the second sheet because essentially it is the same column. Does that make sense and can I do that?
Best Answers
-
You would have to do this manually or you would need to look into the add-on Data Mesh or Data Shuttle.
-
@Paul Newcome , it's only possible in Data Shuttle as far as I know.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
You're more than welcome!
✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
To add to this question, for those familiar with SharePoint, it is the same as creating a LookUp column. I assume the answer if possible is some type of formula. Any help with creating this formula would very appreciated.
-
You would have to do this manually or you would need to look into the add-on Data Mesh or Data Shuttle.
-
Hi @Delilah
I hope you're well and safe!
Unfortunately, it's not possible now, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment.
Here's a possible workaround or workarounds
- I recently developed a centralized dropdown update solution for a client using the premium app, Data Shuttle.
Is that an option?
I hope that helps!
Have a fantastic week & Happy Holidays!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå I may be remembering incorrectly, but isn't there an option within Data Mesh to update the dropdown lists, or am I thinking of Data Shuttle?
-
@Paul Newcome , it's only possible in Data Shuttle as far as I know.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thank you both for the answers. Disappointing it is only available with the add-ons. I don't know anything about either one mentioned. I'll look into them.
-
@Andrée Starå Thanks. I don't use Data Mesh as often, so I couldn't remember off the top of my head.
-
Thank you both for the answers. Disappointing it is only doable with the add-ons. I don't know anything about either one mentioned. I'll look into them.
-
You're more than welcome!
✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives