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?
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!