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

Best Answer

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!