如何在共享點列表中指定定義的排序 (How do you specify a defined sort in sharepoint list)

問題描述

如何在共享點列表中指定定義的排序 (How do you specify a defined sort in sharepoint list)

我有一個共享點列表，其中包含以下選項（InProgress、Done、NotStarted、Abandoned 等）的選擇列我想做的是按此列對列表進行排序，但將排序順序定義為 NotStarted , InProgress, Done, Abandoned 而不是字母排序。

有沒有辦法做到這一點？我已將我的列表轉換為 XSLT 數據視圖並查看了排序對話框，但看不到這樣定義排序的方法。

任何幫助將不勝感激。

謝謝基督徒

參考解法

方法 1:

The easiest way is to rename your choices in the choice column from NotStarted, InProgress, Done, Abandoned to (1) NotStarted, (2) InProgress, (3) Done, (4) Abandoned. This is how the Priority column is setup in out of the box Tasks lists.

方法 2:

Try creating a calculated column that will assign numerical values based on your text ones. Go to Add Column > More... and select Calculation. In the formula box below, try something like

=IF(EXACT(Priority,"High"),1,IF(EXACT(Priority,"Normal"),2,3))

Here's a solid reference for Examples of common formulas in lists.

(by chrisp_68、Kit Menke、Sam Shinn)

參考文件

1. How do you specify a defined sort in sharepoint list (CC BY‑SA 3.0/4.0)