If statement not working
Can anyone see why this is not working. I keep getting #UNPARSEABLE.
=IF([Neighborhood Lots]@row = "Kinsley 50’", 45, IF([Neighborhood Lots]@row = "Kinsley 60’", 46, IF([Neighborhood Lots]@row = "Kinsley 70’", 47, IF([Neighborhood Lots]@row = "Kinsley 85’", 48, IF([Neighborhood Lots]@row = "Kinsley 100’", 49, IF([Neighborhood Lots]@row = "Hedgefield 50’", 43, IF([Neighborhood Lots]@row = "Hedgefield 60’", 44, IF([Neighborhood Lots]@row = "Stoneybrooke", 7F, IF([Neighborhood Lots]@row = "Woodland Creek 50’", 82, IF([Neighborhood Lots]@row = "Woodland Creek 60’", 83, IF([Neighborhood Lots]@row = "Woodland Creek 70’", 84, IF([Neighborhood Lots]@row = "Woodland Creek 85’", 85, IF([Neighborhood Lots]@row = "Woodland Creek 100’", 86, IF([Neighborhood Lots]@row = "Sturbride RB", 24, IF([Neighborhood Lots]@row = "Sturbridge Oaks", 25, IF([Neighborhood Lots]@row = "Sturbridge YC", 29, IF([Neighborhood Lots]@row = "Sturbride TR", 27, IF([Neighborhood Lots]@row = "Sturbridge PP", 28, IF([Neighborhood Lots]@row = "Wynrdige", 22, IF([Neighborhood Lots]@row = "New Park 50’", 92, IF([Neighborhood Lots]@row = "New Park 60’", 91, IF([Neighborhood Lots]@row = "New Park 75’", 90, IF([Neighborhood Lots]@row = "Summerlin", 94, IF([Neighborhood Lots]@row = "Camelot", 95, IF([Neighborhood Lots]@row = "Silver Hills", 26, IF([Neighborhood Lots]@row = "Cotton Terrace", 81, IF([Neighborhood Lots]@row = "Deer Creek", 65)))))))))))))))))))))))))))
Answers

Can you provide a screenshot of the formula open in the sheet as if you are about to edit it?

I hope you're well and safe!
At a glance, I can't see any issues. Have you doublechecked the column names?
Try this and see if it makes a difference.
=
IF([Neighborhood Lots]@row = "Kinsley 50’", 45,
IF([Neighborhood Lots]@row = "Kinsley 60’", 46,
IF([Neighborhood Lots]@row = "Kinsley 70’", 47,
IF([Neighborhood Lots]@row = "Kinsley 85’", 48,
IF([Neighborhood Lots]@row = "Kinsley 100’", 49,
IF([Neighborhood Lots]@row = "Hedgefield 50’", 43,
IF([Neighborhood Lots]@row = "Hedgefield 60’", 44,
IF([Neighborhood Lots]@row = "Stoneybrooke", 7F,
IF([Neighborhood Lots]@row = "Woodland Creek 50’", 82,
IF([Neighborhood Lots]@row = "Woodland Creek 60’", 83,
IF([Neighborhood Lots]@row = "Woodland Creek 70’", 84,
IF([Neighborhood Lots]@row = "Woodland Creek 85’", 85,
IF([Neighborhood Lots]@row = "Woodland Creek 100’", 86,
IF([Neighborhood Lots]@row = "Sturbride RB", 24,
IF([Neighborhood Lots]@row = "Sturbridge Oaks", 25,
IF([Neighborhood Lots]@row = "Sturbridge YC", 29,
IF([Neighborhood Lots]@row = "Sturbride TR", 27,
IF([Neighborhood Lots]@row = "Sturbridge PP", 28,
IF([Neighborhood Lots]@row = "Wynrdige", 22,
IF([Neighborhood Lots]@row = "New Park 50’", 92,
IF([Neighborhood Lots]@row = "New Park 60’", 91,
IF([Neighborhood Lots]@row = "New Park 75’", 90,
IF([Neighborhood Lots]@row = "Summerlin", 94,
IF([Neighborhood Lots]@row = "Camelot", 95,
IF([Neighborhood Lots]@row = "Silver Hills", 26,
IF([Neighborhood Lots]@row = "Cotton Terrace", 81,
IF([Neighborhood Lots]@row = "Deer Creek", 65)
Did it work?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:andree@workbold.com  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

I did. the columns are the same. I will try yours and let you know. Thank you very much

This was causing the issue thus far. Still typing. Had to list it as "7F" and not just 7F.

SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:andree@workbold.com  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

That fixed it
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives