=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

  • Hannah H
    Hannah H ✭✭✭✭✭
    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.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!