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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!