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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives