Dynamic shuttle - Drop down to show alphabetically
I have a Program drop down in my projects sheet which currently is manually populated using a report from the programs list. With data shuttle, I have managed to get an extract of program names into the attachment and then data upload to the drop down. However, this is not alphabetical anymore and takes the literal order from the program list - which makes sense from the way it would work.
How can I make it such that the drop down list is alphabetically ordered with minimal manual intervention?
There are new programs added every week and hence, an automated process will help.