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 GP Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
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 GP Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com

Thank you so much!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!