Drop down list data from column in another sheet

JeremiahHorstick

www.ddupdate.com does what you are looking for and it's free.

JeremiahHorstick

I wanted drop-down options from another sheet so badly that I built it. You can use it for free @ www.ddupdate.com

Tana Rucker

Ha! I'm dying over here. Your timing is perfect, and I'm trying this out now. As of right now, we have two use cases that would benefit from this today, and more likely.

After logging in and clicking "map relationships", I receive an error: AnvilWrappedError: 'ascii' codec can't encode character u'\xf6' in position 1: ordinal not in range(128). Once I get it to work, holler if you'd like some additional feedback.

JeremiahHorstick

Tana,

谢谢你的反馈!我们发现了错误have addressed it. You're good to go. Thanks for testing our beta version. Please send any feedback directly to us at[email protected].

-J

JeremiahHorstick

Did you see www.ddupdate.com?

It allows you to update drop down options with a column in another sheet.

VanessaK_SRR

I am going to try this right now. THANK YOU!

JasonBEE

Kudos to Smartsheet for making this now available.

I would encourage Smartsheet to include this as part of its basic package. I used Smartsheet a few years ago, and am revisiting it for another purpose, which happens to need the use of drop-down data from another sheet.

Having drop-down boxes from another sheet of data is last century technology that we should definitely not be paying extra for. Seems a little greedy, as I believe it should have been there as a basic feature. I realize it is probably more difficult to implement than what we think, but it kind of defeats the purpose of calling the current suite "Smartsheet", if its not much smarter than Excel.

Again, sorry to say, but it does seem a little greedy having to pay for something that should already be there.

I just want to now do a shout out to the gentleman who createdwww.ddupdate.com. Looks great, and will look into that, but the data I am working with is sensitive, and I have concerns about security regarding that. Any thoughts of reassurance would be helpful. Thanks

JeremiahHorstick

Hi Jason,

Where do you see that Smartsheet is now making this functionality available!?

www.ddupdate.com employs the OAuth 2.0 protocol to connect to Smartsheet, storing only data which are vital to the function which it provides on highly-secure AWS servers with strong safe-guards including multiple layers of domain restricted access, encryption, and secret containers.

We have quickly gained a healthy user base in our first week since our beta release and plan to add some documentation and functionality based on the feedback we have received. Focusing on security first, we are confident that we meet or exceed your security standard and are happy to have a more in depth discussion. You can reach me directly via[email protected].

-J

DIV

This is rediculous that SS doesnt have dropdown lists! 2 years of discussion and no feedback on core feature.

Without dropdowns what processes you can run? Order office paper from one vendor?

I dreamed how i can start SS on 400 people business to boost digital transformation, but now i do not see any possibility to use this service in any serious processes.

JeremiahHorstick

What's your solution?

DIV

http://www.ddupdate.com- site does not open

J. Craig Williams

I would suggest you avoid giving your Smartsheet credentials to anyone you do not trust. And most of the anyone's that you do.

This goes for your Facebook, Google, and other SaaS credentials.

I would certainly not give my credentials without seeing what the company agrees to do / not do with the information.

I have the same functionality in my API tools, from the description, with very similar concept. There ARE ways to do this with more security, such as creating a dummy user with access to only a few Sheets. However, to accomplish what this does via the API, the credentials MUST have Admin privileges on the destination sheets.

Use at your own risk.

Craig

JeremiahHorstick

Hi James,

We at On Time Solutions builtwww.ddupdate.comto update drop down options from another sheet.

Here's aYouTube videoto show you how simple it is.

-J

JeremiahHorstick

https://www.ddupdate.com/

Implementing a Smartsheet OAuth Flow means others can use the integration to interact with their Smartsheet data without any sensitive information (username, password, etc.) actually changing hands.

//www.santa-greenland.com/blog/tips-maximize-your-smartsheet-api-integrations

MR

I also need this feature. Please implement.