# Nesting multiple IF statements inside OR statement

✭✭

Tags:

• ✭✭✭✭✭✭

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: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.

• ✭✭

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,"")))

• ✭✭✭✭✭✭

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: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.

• ✭✭

Andrée,

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

Cheers!

• ✭✭✭✭✭✭

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: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.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!