Dropdowns not populating after VBA operation on excel import into Smartsheet
Hi All,
We are facing a scenario where we need to use a VBA to populate dropdown options in excel but as this excel is imported into the Smartsheet the dropdowns are not available any longer.
However if we do not use a VBA but a simple cell validation to populate dropdown options in excel, when this excel is imported into the Smartsheet the dropdowns are available and works fine.
Let us know if anyone has faced this situation and any workarounds/solution for the same.
Thanks
Dhanush
Answers
-
Do you have access to DataShuttle? I use that function w/ the offload/upload for dropdown updates. It is effective and you can provide 1 source sheet for the dropdown to be maintained on and have several other sheets updated automatically and not individually/manually.
Thanks - Liz
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives