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 double-checked 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.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives