Nested If Statement - help needed

Jed RusyniakJed Rusyniak ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions
05/02/19 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. 

Screen Shot 2019-05-02 at 10.42.05 AM.png

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    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 PARTNER & CONSULTANT / EXPERT

    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.

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    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

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

    Nice catch!

    Thanks!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    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.

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    No worries. yes

    thinkspi.com

  • Jed RusyniakJed Rusyniak ✭✭✭✭✭

    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.

    Screen Shot 2019-05-04 at 6.41.17 AM.png

  • Jed RusyniakJed Rusyniak ✭✭✭✭✭

    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. 

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

    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 PARTNER & CONSULTANT / EXPERT

    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.

  • Jed RusyniakJed Rusyniak ✭✭✭✭✭

    thanks...now I am in business. 

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    edited 05/04/19

    Excellent!

    I'm always happy to help!

    Best,

    Andrée

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    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.

Sign In or Register to comment.