# Nested If Statement - help needed

✭✭✭✭✭✭
edited 12/09/19

I'm trying to get this formula to work.

=IF([PRO Number]9 - [Trailer #]9 > 10), " PRO Levels: OK", IF([PRO Number]9 = [Trailer #]9, "Yusen Needs PRO#s")))

I want to trigger the IF/Then statement if the value of ([PRO Number]9 - [Trailer#]9) is equal to or less than 10.  See screen shot below.

Tags:

## Comments

• ✭✭✭✭✭✭
edited 05/03/19

Hi Jed,

Try something like this.

=IF([PRO Number]9 = [Trailer #]9; "Yusen Needs PRO#s"; IF([PRO Number]9 - [Trailer #]9 <= 10; " PRO Levels: OK"))

The same version but with the below changes for your and others convenience.

=IF([PRO Number]9 = [Trailer #]9, "Yusen Needs PRO#s", IF([PRO Number]9 - [Trailer #]9 <= 10, " PRO Levels: OK"))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

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 about help with Smartsheet, integrations, general workflow advice, or something else entirely.

• ✭✭✭✭✭✭

Missed an operator in the second IF...

=IF([PRO Number]9 = [Trailer #]9, "Yusen Needs PRO#s", IF([PRO Number]9 - [Trailer #]9 <= 10, " PRO Levels: OK"))

thinkspi.com

• ✭✭✭✭✭✭

Nice catch!

Thanks!

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 about help with Smartsheet, integrations, general workflow advice, or something else entirely.

• ✭✭✭✭✭✭

No worries.

thinkspi.com

• ✭✭✭✭✭✭

Thanks for the help guys.  It is working, but not exactly how I need it to.  I need the cell to return the value "Yusen Needs PRO#s" if the difference in the count from ([PRO Number]9 - [Trailer#]9) is equal to or less than 10.

• ✭✭✭✭✭✭

For example in the screen shot above the value of 11-3 = 8 and should be returning the value of Yusen Needs PRO#s but it isn't doing that.

• ✭✭✭✭✭✭

Happy to help!

If I understand you correctly you'd probably only have to change places between the text.

OK and Need.

Ok?

Best,

Andrée

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 about help with Smartsheet, integrations, general workflow advice, or something else entirely.

• ✭✭✭✭✭✭

thanks...now I am in business.

• ✭✭✭✭✭✭
edited 05/04/19

Excellent!

I'm always happy to help!

Best,

Andrée

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 about help with Smartsheet, integrations, general workflow advice, or something else entirely.