If statement not working

Options

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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Options

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

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    Hi @Robert S Fike

    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.

  • Robert S Fike
    Robert S Fike ✭✭✭✭
    Options

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

  • Robert S Fike
    Robert S Fike ✭✭✭✭
    Options

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

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    @Robert S Fike

    Oh, good catch!

    I don't see any others, so try it now and see if it works.

    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.

  • Robert S Fike
    Robert S Fike ✭✭✭✭
    Options