Data Shuttle - Alpha/Numeric Sort of Dropdown lists

Chuck G

Would love to have the ability to Alpha or Numeric order my Data Shuttle Offload List so then when I go to do my Upload file, the new list has been Alphabetized or put in Numerical order. This way when my end user sees their dropdown list, it's easy to read or lookup values.

Chizu Hieida

YES!!!!! I need his function!!!!! Currently, I read the community thread for workaround. (Using Power Automate/Office Script) and I'm trying this right now but struggling. 🙃 it keeps giving me error to offload data now I set up Office script. Not sure why. 😵

I have so many use of this Drop Down value update using Data shuttle to automate so many of our works!!! but I need this sort function to go with it to make sense.

Community thread:

https://community.smartsheet.com/discussion/105324/data-shuttle-update-dropdowns-alphabetically

AdamF

Hello, I added a comment in the discussion area as well, but thought copying it here might be a good idea since it's where the community is voting on the idea. Hope it helps someone:

Another workaround since Data Shuttle doesn't yet have built-in sorting… You can use a process like this: Source Sheet (messy data) > SmartSheet Report (sorted data) > SmartSheet Pivot (uses report sort) > DataShuttle.

For example, our organization is frequently updating our Contract list based on the business we win or work that is not renewed. So while there is a source sheet with all of the Contract Names, the sheet contains both old data and rows that are not sorted since the new rows come in via automation or form entry. However, we want the Contract drop-down in our other processes such as Risks to always be up-to-date and sorted alphanumerically.

Step 1) Create a report with the filters and sorts desired for the dropdown list.

Step 2) Create a Pivot with that new report as a source option. This can be a very simple pivot with the 1 row selected for the data you want, no columns, and maybe a simple count of something in that row

Please note: That since a report is the source you wouldn't be able to have the pivot update automatically upon a sheet update, but you can configure to run every hour, or every day or whatever interval is best.

Step 3) Run the new Pivot, it will create a brand new sheet in the folder you designated during setup, with the data sorted the way you want.

Step 4) Since you have a self-updating sheet now, you can use that sheet as the source for DataShuttle, you'll just likely have to filter out any blank rows and the "Grand Total" row created by the pivot process.

Chuck G

Thanks AdamF! I was wondering why so many people haven't voted for this yet. I utilize Data Shuttle and dropdown list a lot and this could save a ton of time for end users if everything was sorted.