Drop down list data from column in another sheet

AndrewM

I would really like this feature to be a part of Smartsheet as well.

evanevans

3 and a half years later, and they still haven't added this critical capability. SmartSheet should be Excel/GoogleSheets PLUS more. Instead it's more like half Excel/Sheets PLUS more. Well, half excel/sheets is not good enough for our enterprise.

evanevans

Same.

evanevans

And for that reason ... I'm out.

Andrée Starå

Hi MR,

Here's a possible workaround.

https://hubs.ly/H0gdlzd0

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Andrée Starå

Hi Andrew,

Here's a possible workaround.

https://hubs.ly/H0gdlzd0

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Andrée Starå

Hi Evan,

Here's a possible workaround.

https://hubs.ly/H0gdlzd0

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Matt_01

Bump

JeremiahHorstick

Nested dropdowns:

The options of the second column are filtered based on the selection in the first column and the 3rd filtered based on the 2nd...etc...

That would really be something. 

pm.naplesflooring89761

SUPER!!!!!!!!!!!!! 100 % and very easy

 

Thank you!!!!

JeremiahHorstick

Thanks for the comment!

-J

krunalpatel

Hi, I'm using ddupdate

 

but getting this error. 

AnvilWrappedError: 'ascii' codec can't encode character u'\u2019' in position 39: ordinal not in range(128)

JeremiahHorstick

DDUpdate is now supporting non-ASCII characters. You're all set. 

krunalpatel

Hi There,



I would like to know more about this tool and want to how it's works 

After configuring this tool. I've noticed that there are some delay in working with smartsheet.

Thanks,

Krunal

JeremiahHorstick

Here's a YouTube video. When the source sheet is saved, the destination dropdown options are updated in less than a second. https://www.youtube.com/watch?v=rv0M5dwwKuY