Custom Sort

sdbex

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

jmyzk_cloudsmart_jp

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.

https://app.smartsheet.com/b/publish?EQBCT=4fda5286bae9435d85c284c0b175f1db