Converting an Excel IFS statement to SmartSheets

Leduct

Having trouble understanding why this keeps being unparseable in SmartSheets.

Original Excel formula: =@IFS([@Total]>=20, "Prioritize These",AND([@Total]<20, [@Total]>10),"Small Quick Wins",AND([@Total]<=10,[@Total]> 0), "Major Projects")

My SmartSheet attempt: =IF(Table22[[#This Row],[Total]]>=20, "Prioritize These"), IF(AND(Table22[[#This Row],[Total]]<19, Table22[[#This Row],[Total]]>11),"Small Quick Wins"), IF(AND(Table22[[#This Row],[Total]]<=10,Table22[[#This Row],[Total]]> 0), "Major Projects")

Any advice out there?

Sameer Karkhanis

Try below, (Replace "Total" with your column name in the sheet. In case your column name is more than one word then you should replace with [Column Name]. For example, if your column name is Weighted Total then it will be [Weighted Total]

IF(Total@row >= 20, "Prioritize These", IF(AND(Total@row < 20, Total@row > 10),"Small Quick Wins",IF(AND(Total@row <= 10, Total@row > 0),"Major Projects","")))