Need to be able to organize summary sheet data for dashboard widgets

pzupan

I have over 100 sheet summary data sets that I have nicely organized on the main smartsheet I'm pulling data from. However, when I try to set up widgets using the same data, there is no rhyme or reason to how they are organized. It's not even alphanumerical, so I have to go searching for all the matching sets.

For example, I have 1100 Incoming, 1100 Outgoing, 2100 Incoming, 2100 Outgoing. They should be organized like that, but instead they might show up on the select data screen like 2100 Incoming, 1100 Outgoing, 2100 Outgoing, 1100 Incoming. I'm trying to create a widget for each, so just a widget for 1100 and a separate one for 2100, so trying to go through hundreds of entries and having to scout around is incredible time consuming and annoying.