Hello
I'm new to Smartsheet and looking for help to convert a really long excel formula into Smartsheet. Is there a maximum number of nested statements? I have pasted it into Smartsheet as is, and get the Unparse error.
Essentially, what I want to do is display specific text when two criteria are met. My formula in Excel is:
=IF(AND(A13="Rare",B13="Insignificant"),"Low",IF(AND(A13="Rare",B13="Minor"),"Low",IF(AND(A13="Rare",B13="Moderate"),"Low",IF(AND(A13="Rare",B13="Major"),"Moderate",IF(AND(A13="Rare",B13="Catastrophic"),"Moderate",IF(AND(A13="Unlikely",B13="Insignificant"),"Low",IF(AND(A13="Unlikely",B13="Minor"),"Low",IF(AND(A13="Unlikely",B13="Moderate"),"Moderate",IF(AND(A13="Unlikely",B13="Major"),"Moderate",IF(AND(A13="Unlikely",B13="High"),"Low",IF(AND(A13="Possible",B13="Insignificant"),"Low",IF(AND(A13="Possible",B13="Minor"),"Moderate",IF(AND(A13="Possible",B13="Moderate"),"Moderate",IF(AND(A13="Possible",B13="Major"),"High",IF(AND(A13="Possible",B13="Catastrophic"),"High",IF(AND(A13="Likely",B13="Insignificant"),"Moderate",IF(AND(A13="Likely",B13="Minor"),"Moderate",IF(AND(A13="Likely",B13="Moderate"),"High",IF(AND(A13="Likely",B13="Major"),"High",IF(AND(A13="Likely",B13="Catastrophic"),"Extreme",IF(AND(A13="Almost Certain",B13="Insignificant"),"Moderate",IF(AND(A13="Almost Certain",B13="Minor"),"High",IF(AND(A13="Almost Certain",B13="Moderate"),"High",IF(AND(A13="Almost Certain",B13="Major"),"Extreme",IF(AND(A13="Almost Certain",B13="Catastrophic"),"Extreme","Not right")))))))))))))))))))))))))
May I please have some help to use this in Smartsheet?
Thankyou