I know there are many different discussions requesting dynamic dropdown functionality native in Smartsheet without a third party solution but I feel the need to start another to emphasize the importance. I believe the need makes even more sense with Card View functionality Smartsheet recently introduced…especially in an enterprise setting. I’m not sure how votes are tallied but count mine (10 fold!) as well as many others in my organization for dynamic dropdown functionality (the need to centrally maintain drop downs that can accessed across multiple smartsheets via multiple users).
The Card View functionality to the best of my knowledge is only available for drop down list columns. For our large organization with multiple Smartsheet users the value of this functionality becomes frankly somewhat unusable when multiple team members (and members outside of our team) may be creating similar but different drop down entries that are viewed collectively as a team or an enterprise. Yes, we can manually try to teach users to utilize the same drop downs we dictate but that takes away the value of using an automated tool that costs our organization money. Dynamic dropdowns would be great for maintaining a uniform list of project names in a portfolio, names of multiple enterprise teams, uniform project statuses, assigned team resources, and many others. Any user could leverage these centrally maintained lists in their individual Smartsheet columns ensuring an accurate/uniform view in Card lanes.
Centrally maintained Dynamic drop down lists obviously benefits more than just card view…it benefits reporting in general especially from an enterprise perspective. We highly utilize reports for our team but to make them valuable outside of a small team to the enterprise as a whole we must be assured we are providing management apples to apples report vs potentially apples to oranges across multiple teams. Controlling the dropdown lists centrally would let us exercise thoughtful control of what we are looking for in reports and to be tracked in our projects as an enterprise.
I really hope this functionality is considered as our large IT organization is seriously considering using Smartsheet as an enterprise tool. Currently my team has been the guinea pigs for experimenting with Smartsheet and I think I’d have a tough time selling the benefits to our larger organization if we can’t have some uniform control of the data we are viewing/reporting on an enterprise level.
Thanks for considering and we love your product as a whole!
