=IF assistance (beginner/novice)
Good afternoon. Trying to state, IF Communication Column is "5 - excellent", then communication rating is a 5. I've written the code below however '5' is not populating. Any thoughts to the formula or should I make Communication column read 'Excellent' only that then converts to a '5' rating?
=IF(Communication@row = "5-EXCELLENT", 5, IF(Communication@row = "4 - Good", 4, IF(Communication@row = "3 - Average", 3, IF(Communication@row = "2 - Poor", 2, IF(Communication@row = "1 - Very Poor", 1)))))
Best Answer
-
Hi Hilda,
It looks like your error is coming from your first IF statement. Your logical expression is for 5 - EXCELLENT however you have written it as "5-EXCELLENT" in your formula. Add in a space to either side of the dash and the formula will work.
Best,
Hannah
Answers
-
Hi Hilda,
It looks like your error is coming from your first IF statement. Your logical expression is for 5 - EXCELLENT however you have written it as "5-EXCELLENT" in your formula. Add in a space to either side of the dash and the formula will work.
Best,
Hannah
-
Hannah - four eyes are better than two! I <3 u! 😘
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!