IFS formula in Excel conversion to Smartsheet
I have the following formula in an Excel sheet that I'm trying to replicate in Smartsheet.
=IFS(F2=0," ",F2<3,"Controlled",F2<8,"Serious",F2<10,"Disruptive",F2<20,"Severe",F2<26,"Critical")
I've tried a few variations, the below being the last one, but continue to receive #UNPARSEABLE errors, etc.. I'm not sure where to go now.
=IF(([Severity Value (auto shaded)]@row=0,""), IF(AND([Severity Value (auto shaded)]@row>0,[Severity Value (auto shaded)]@row<3,"Controlled",""), IF(AND([Severity Value (auto shaded)]@row>=3,[Severity Value (auto shaded)]@row<8),"Serious",""), IF(AND([Severity Value (auto shaded)]@row>=9,[Severity Value (auto shaded)]@row<10),"Disruptive",""), IF(AND([Severity Value (auto shaded)]@row>=11,[Severity Value (auto shaded)]@row<20),"Severe",""), IF(AND([Severity Value (auto shaded)]@row>=21,[Severity Value (auto shaded)]@row<26),"Critical",""))
Thank you for any advice you can provide.
Best Answer
-
Lets try some syntax cleanup first and see where that gets us...
=IF([Severity Value (auto shaded)]@row=0,"", IF([Severity Value (auto shaded)]@row<3,"Controlled", IF([Severity Value (auto shaded)]@row<8,"Serious", IF([Severity Value (auto shaded)]@row<10,"Disruptive", IF([Severity Value (auto shaded)]@row<20,"Severe", IF([Severity Value (auto shaded)]@row<26,"Critical",""))))))
Answers
-
Lets try some syntax cleanup first and see where that gets us...
=IF([Severity Value (auto shaded)]@row=0,"", IF([Severity Value (auto shaded)]@row<3,"Controlled", IF([Severity Value (auto shaded)]@row<8,"Serious", IF([Severity Value (auto shaded)]@row<10,"Disruptive", IF([Severity Value (auto shaded)]@row<20,"Severe", IF([Severity Value (auto shaded)]@row<26,"Critical",""))))))
-
Thank you...the correct placement of parens was throwing me off!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!