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
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives