# =IF assistance (beginner/novice)

Options

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)))))

• ✭✭✭✭✭
Options

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

• ✭✭✭✭✭
Options

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

• Options

Hannah - four eyes are better than two! I <3 u! 😘

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!