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
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!