Multiple values from one column, into dropdown options of another column?
I am trying to grab unique job numbers from a column in one sheet (Sheet A), to populate as options for a single select dropdown in another sheet (Sheet B), to essentially be able to have a spreadsheet to create, track and log daily activities of larger projects.
Sheet A (Master list of projects):
Column values to collect: Project Number
Condition: Where status is NOT "Completed"
Sheet B (daily worklog):
Project Number (dropdown list of projects from Sheet A, where the status is NOT "Completed")
Ultimately, I'd like to have this in a form where managers can select a project from the master list, and create smaller daily tasks. Am I over complicating this/going about this the wrong way? I've gotten quite turned around trying to use the INDEX function.
Thank you in advance for any help. From what I've seen, the community here seems quite helpful and professional! 😁
Answers
-
Hi @Paul Wheeler ,
Unfortunatley this capability doesn't exist. You can submit an enhancement request at:
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
To add to Mark's excellent advice/answer.
A solution that could be perfect for this use-case is the premium add-on, Data Uploader.
Is that an option?
More info:
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as 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.
-
@Paul Wheeler Hi Paul, take a look at our Drop Down Sync app which may be able to help you https://projectplanservices.co.uk/dropdownsync
Please let us know if you would like a trial
Thanks
PPS
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!