Another possible workaround, and a solution that would be perfect for this use-case is the premium add-on, Data Uploader.
Is that an option?
I hope that helps!
Be safe and have a fantastic week!
Workflow Consultant / CEO @ WORK BOLD
✅Did my post 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 PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
This does seem like something that should be part of Smartsheet already.
I agree with @Erik Jensen. Our company has multiple projects with hundreds of people on site. I want each project team to maintain a contact list for their site. When someone is doing a safety inspection of that site, they fill out a webform and assign the issue to someone. That form field should should be pulled from the contact list pertaining to only that project. There needs to be a way for the dropdown options to reference data elsewhere...
By the way, These inspection forms are filled out on people's phones...
I am evaluating this platform and agree that this is a pretty basic requirement. How do you relate information without foreign keys (drop downs lists from another smartsheet)?
Resonating Phil's question, Is it possible to achieve this ? We are trying to manage a machine master sheet, and reference machine name/id in another sheet via a dropdown
I've been reading all the threads on this and I didn't like any of the workarounds for various reasons, but I finally found it!
There's an app built just for this issue: https://dropdown.anvil.app/
Thank goodness. I was legit looking an not switching everything over to smartsheet just because of this lack of feature alone. Problem solved.
Hi @Nick Jarvis
Thanks for posting your solution! I removed out the detail on cost as it could be seen as promotional, which actually goes against our Community guidelines (see here). Interested members can visit the third party's website to find out more information.