Nested if statement not working, am I doing the formula wrong or is it not working correctly?

Hi all - I am trying to do a nested if statement for an approval chain but I can not get it to return a value different than #UNPARSEABLE. Can someone check my formula and tell me where I am going wrong?

=IF([Cell 1]@row = "No", "Rejected", IF([Cell 1]@row = "More Info Needed", "More Info Needed", IF([Cell 1]@row = "Yes", =IF([Cell 2]@row = "No", "Rejected", IF([Cell 1]@row = "Yes", =IF([Cell 2]@row = "More Info Needed", "More Info Needed", IF([Cell 1]@row = "Yes", =IF([Cell 2]@row = "Yes", "Yes", "")))))))))

Tags:

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 10/12/21

    Hi @Michael Goodman 

    Hope you are fine, please try the following formula:

    =IF([Cell 1]@row = "No", "Rejected", IF([Cell 1]@row = "More Info Needed",
    "More Info Needed", IF([Cell 1]@row = "Yes", "Yes")))
    


    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!