# Help with nested IF AND statements

edited 10/12/20

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

Tags:

• Thankyou so much for your help.

• ✭✭✭✭✭✭

You're more than welcome!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.