Nested Ifs not working

Hey,

I'm trying to create some nested ifs for grid logic.

This works perfectly for one if statement

=IF(LOE@row = "Large", "12", β€œEmpty”)

But once I start to nest, it does not, and I've tried multiple combinations of parens and read the articles, etc, but it keeps saying #UNPARESEABLE"

=IF(LOE@row = "Large", "12", IF(LOE@row = β€œSmall”, "4”, "Empty”))

Where I am trying to go is something like this, but I need above to work first!

=IF(LOE@row = "Extra Large", "20", IF(LOE@row = β€œLarge”, "12", IF(LOE@row = β€œMedium”, "8", IF(LOE@row = β€œSmall”, "4", IF(LOE@row = β€œExtra Small”, "1”, "Empty”)))))

(I also tried IF([LOE]@row based on other articles, but Smartsheet just deletes the [] brackets)

What am I doing wrong?

Tags:

Best Answer

  • AravindGP
    AravindGP Community Champion
    Answer βœ“

    Hi Rebecca,


    When you're entering numeric values as results in formulas, you don't need to add it in quotes. It is only needed for strings. Here's the formula you can use.


    =IF(LOE@row = "Extra Large", 20, IF(LOE@row = "Large", 12, IF(LOE@row = "Medium", 8, IF(LOE@row = "Small", 4, IF(LOE@row = "Extra Small", 1, "Empty")))))

    Thanks,

    Aravind GP| Delivery Manager

    Atturra Data & Integration

    M: +61493337445

    E:Aravind.GP@atturra.com

    W: www.atturra.com

Answers

  • AravindGP
    AravindGP Community Champion
    Answer βœ“

    Hi Rebecca,


    When you're entering numeric values as results in formulas, you don't need to add it in quotes. It is only needed for strings. Here's the formula you can use.


    =IF(LOE@row = "Extra Large", 20, IF(LOE@row = "Large", 12, IF(LOE@row = "Medium", 8, IF(LOE@row = "Small", 4, IF(LOE@row = "Extra Small", 1, "Empty")))))

    Thanks,

    Aravind GP| Delivery Manager

    Atturra Data & Integration

    M: +61493337445

    E:Aravind.GP@atturra.com

    W: www.atturra.com

  • rebeccakbaker
    rebeccakbaker ✭✭✭

    Thank you so much!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!