IF statement not working
Can anyone tell me what i am doing wrong here.
=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")
Best Answer
-
Hey @Robert S Fike
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hey @Robert S Fike
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
TYVM
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives