#unparseable error on multiple IF statement have tried everything!
I've got a simple multiple if statement. If column A is X then return Y and it's giving me Unparseable. Any advice gratefully received.
Best Answer
-
The first thing I notice is that you have one too many ) at the end of your formula. It should be
=IF(Activity@row = "CB FUNDING","Running the Game", IF(Activity@row = "T1 Rugby", "In the Game", IF(Activity@row = "EXPAND CLUB AND INCLUDE L&D FOR VOLUNTEERS", "In the Clubhouse")))
The way to look at is is you only have 3 if statements and no other formulas so to close off all three you need ))). If you notice in your formula the ) changes color to match the formula its closing off. If it turns to black you have too many.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Answers
-
The first thing I notice is that you have one too many ) at the end of your formula. It should be
=IF(Activity@row = "CB FUNDING","Running the Game", IF(Activity@row = "T1 Rugby", "In the Game", IF(Activity@row = "EXPAND CLUB AND INCLUDE L&D FOR VOLUNTEERS", "In the Clubhouse")))
The way to look at is is you only have 3 if statements and no other formulas so to close off all three you need ))). If you notice in your formula the ) changes color to match the formula its closing off. If it turns to black you have too many.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
You're a legend. How I didn't spot that I don't know. Thank you so much!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives