# IF statement not working

Options
✭✭✭✭

Can anyone tell me what i am doing wrong here.

"Donna”, IF([Neighborhood]@row = “Hedgefield”,

"Donna”, IF([Neighborhood]@row = “New Park”,

"Donna”, IF([Neighborhood]@row = “Stoneybrooke”,

"Donna”, IF([Neighborhood]@row = “Woodland Creek”,

"Donna”))))), "Shauna")

• Employee
Options

It's the quotes! I can see that they're curved here, which likely means the formula was typed out in a different platform or on a note pad. Smartsheet needs quotes to be the straight version: " versus curved ”

Try it again by either typing the formula in the cell (so the quotes are correct), or by copy/pasting this:

=IFERROR(IF([Neighborhood]@row = "Hampstead", "Donna", IF([Neighborhood]@row = "Hedgefield", "Donna", IF([Neighborhood]@row = "New Park", "Donna", IF([Neighborhood]@row = "Stoneybrooke", "Donna", IF([Neighborhood]@row = "Woodland Creek", "Donna")))), "Shauna")

You could also simplify the formula with an OR statement if that would help:

=IF(OR([Neighborhood]@row = "Hampstead", [Neighborhood]@row = "Hedgefield", [Neighborhood]@row = "New Park", [Neighborhood]@row = "Stoneybrooke", [Neighborhood]@row = "Woodland Creek"), "Donna", "Shauna")

Cheers,

Genevieve

October 8 - 10, Seattle, WA | Register now

• Employee
Options

It's the quotes! I can see that they're curved here, which likely means the formula was typed out in a different platform or on a note pad. Smartsheet needs quotes to be the straight version: " versus curved ”

Try it again by either typing the formula in the cell (so the quotes are correct), or by copy/pasting this:

=IFERROR(IF([Neighborhood]@row = "Hampstead", "Donna", IF([Neighborhood]@row = "Hedgefield", "Donna", IF([Neighborhood]@row = "New Park", "Donna", IF([Neighborhood]@row = "Stoneybrooke", "Donna", IF([Neighborhood]@row = "Woodland Creek", "Donna")))), "Shauna")

You could also simplify the formula with an OR statement if that would help:

=IF(OR([Neighborhood]@row = "Hampstead", [Neighborhood]@row = "Hedgefield", [Neighborhood]@row = "New Park", [Neighborhood]@row = "Stoneybrooke", [Neighborhood]@row = "Woodland Creek"), "Donna", "Shauna")

Cheers,

Genevieve