Nesting multiple IF statements inside OR statement

Best Answer

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓

    Hi @Jezza

    I hope you're well and safe!

    Try something like this. (update columns names to yours)

    =IF(CheckA@row = 1, 10, IF(CheckB@row = 1, 20, IF(CheckC@row = 1, 30)))

    Did that work/help?

    I hope that helps!

    Be safe, and have a fantastic week!

    Best,

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

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

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

Answers

  • Jezza
    Jezza ✭✭

    Hi,

    I'm trying to do something that seems very basic and yet SS keeps providing #parseable errors. I have 3 check box columns and want to return a result based on WHICH box is checked. I.E. if column 1 is checked = 10, if column 2 checked = 20, if column 3 checked = 30, etc etc.

    Only one column would ever be checked. Individually the formulas work (checking IF a box is checked) but combining them gives me an error every time.

    Can you not create nested formulas in SS such as: =OR( IF statement1, IF statement 2, ETC)

    This is the formula I am using that gives me the error:


    =OR((IF(A@row = 1, "20", "")),(IF(B@row=1,"35","")),(IF(C@row=1,"12,"")))

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓

    Hi @Jezza

    I hope you're well and safe!

    Try something like this. (update columns names to yours)

    =IF(CheckA@row = 1, 10, IF(CheckB@row = 1, 20, IF(CheckC@row = 1, 30)))

    Did that work/help?

    I hope that helps!

    Be safe, and have a fantastic week!

    Best,

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

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

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

  • Jezza
    Jezza ✭✭

    Andrée,

    Thank you! This worked perfectly. I had assumed it would require an OR statement with multiple IFs but I guess not.

    Cheers!

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    @Jezza

    Excellent!

    Happy to help!

    Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!