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?
Best 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
Reach out for any help on licenses, configuration, or training
Answers
-
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
Reach out for any help on licenses, configuration, or training
-
Thank you so much!
Help Article Resources
Categories
Check out the Formula Handbook template!