Converting an Excel IFS statement to SmartSheets

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
    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","")))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!