Custom Sort
I have multiple spreadsheets (Excel) that I sort in a specific order. Excel has a "custom sort" feature that allows me to take my cells, copy them then create a custom sort using those copied cells. We are starting the process of transitioning to SmartSheet and I just realized that I cannot sort by the way I need to. Trying to see if there is any possibility for this.
Example:
I have rows that contain a specific number (Excel spreadsheet). I need my SmartSheet document sorted in that same way (for example):
21277
21278
213079
716531
718959
213065
213066
102946
107410
Answers
-
Hi @sdbex
To simulate Excel's "Custom Sort', you can create a separate "Custom Sort" sheet with the values you want to sort and the corresponding order.😀
Then, using the cross-sheet-reference formula, like INDEX(MATCH()), you can get the sort order.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives