I am trying to rank our open orders. Once it meets one of the criteria, I would like to filter the order# so it can't be used to meet another critera. Anotherwards I want to avoid duplicate order numbers in the same table. How I presently have it, an order# number can occur in more than one rank.
Priority =
SWITCH(
TRUE(),
//TODAY
Sheet1[Shippable]==True() && Sheet1[Useable Schedule Date].[Date]==Sheet1[CurrentDate].[Date] && Sheet1[SB / SC]=="SC" && Sheet1[Parts Class]=="A","RANK1",
Sheet1[Shippable]==True() && Sheet1[Useable Schedule Date].[Date]==Sheet1[CurrentDate].[Date] && Sheet1[SB / SC]<>"SC" && Sheet1[SKUs]==1 && Sheet1[Parts Class]=="A","RANK2",
Sheet1[Shippable]==True() && Sheet1[Useable Schedule Date].[Date]==Sheet1[CurrentDate].[Date] && Sheet1[SB / SC]=="SC" && Sheet1[Parts Class]<>"A","RANK3",
Sheet1[Shippable]==True() && Sheet1[Useable Schedule Date].[Date]==Sheet1[CurrentDate].[Date] && Sheet1[SB / SC]<>"SC" && Sheet1[SKUs]==1 && Sheet1[Parts Class]<>"A","RANK4",
Sheet1[Shippable]==True() && Sheet1[Useable Schedule Date].[Date]==Sheet1[CurrentDate].[Date] && Sheet1[SB / SC]<>"SC" && Sheet1[Kit]="0","RANK5",
//PAST DUE
Sheet1[Shippable]==True() && Sheet1[Useable Schedule Date].[Date]<Sheet1[CurrentDate].[Date] && Sheet1[SB / SC]=="SC" && Sheet1[Parts Class]=="A","RANK6",
Sheet1[Shippable]==True() && Sheet1[Useable Schedule Date].[Date]<Sheet1[CurrentDate].[Date] && Sheet1[SB / SC]<>"SC" && Sheet1[SKUs]==1 && Sheet1[Parts Class]=="A","RANK7",
Sheet1[Shippable]==True() && Sheet1[Useable Schedule Date].[Date]<Sheet1[CurrentDate].[Date] && Sheet1[SB / SC]=="SC" && Sheet1[Parts Class]<>"A","RANK8",
Sheet1[Shippable]==True() && Sheet1[Useable Schedule Date].[Date]<Sheet1[CurrentDate].[Date] && Sheet1[SB / SC]<>"SC" && Sheet1[SKUs]==1 && Sheet1[Parts Class]<>"A","RANK9",
Sheet1[Shippable]==True() && Sheet1[Useable Schedule Date].[Date]<Sheet1[CurrentDate].[Date] && Sheet1[SB / SC]<>"SC" && Sheet1[Kit]="0","RANK10",
//FUTURE "A" CLASS
Sheet1[Shippable]==True() && Sheet1[Useable Schedule Date].[Date]>Sheet1[CurrentDate].[Date] && Sheet1[SB / SC]=="SC" && Sheet1[Parts Class]=="A","RANK11",
Sheet1[Shippable]==True() && Sheet1[Useable Schedule Date].[Date]>Sheet1[CurrentDate].[Date] && Sheet1[SB / SC]<>"SC" && Sheet1[SKUs]==1 && Sheet1[Parts Class]=="A","RANK12",
//TODAY WITH WAREHOUSE 10
Sheet1[Shippable]==False() && Sheet1[Useable Schedule Date].[Date]==Sheet1[CurrentDate].[Date] && Sheet1[WH7/WH10 Complete Order]="WH7/WH10 Complete" && Sheet1[Parts Class]=="A", "RANK13",
Sheet1[Shippable]==False() && Sheet1[Useable Schedule Date].[Date]==Sheet1[CurrentDate].[Date] && Sheet1[WH7/WH10 Complete Order]="WH7/WH10 Complete" && Sheet1[Parts Class]<>"A", "RANK14",
//PAST DUE WITH WAREHOUSE 10
Sheet1[Shippable]==False() && Sheet1[Useable Schedule Date].[Date]<Sheet1[CurrentDate].[Date] && Sheet1[WH7/WH10 Complete Order]="WH7/WH10 Complete" && Sheet1[Parts Class]=="A", "RANK15",
Sheet1[Shippable]==False() && Sheet1[Useable Schedule Date].[Date]<Sheet1[CurrentDate].[Date] && Sheet1[WH7/WH10 Complete Order]="WH7/WH10 Complete" && Sheet1[Parts Class]<>"A", "RANK16",
//FUTURE
//Sheet1[Shippable]==True() && Sheet1[Useable Schedule Date].[Date]>Sheet1[CurrentDate].[Date] && Sheet1[SB / SC]=="SC" && Sheet1[Parts Class]<>"A","RANK17",
//Sheet1[Shippable]==True() && Sheet1[Useable Schedule Date].[Date]>Sheet1[CurrentDate].[Date] && Sheet1[SB / SC]<>"SC" && Sheet1[SKUs]==1 && Sheet1[Parts Class]<>"A","RANK18",
//Sheet1[Shippable]==True() && Sheet1[Useable Schedule Date].[Date]>Sheet1[CurrentDate].[Date] && Sheet1[SB / SC]<>"SC" && Sheet1[Kit]="0","RANK19",
"NULL"
)