What's wrong with my "IF" formula?


I wrote this formula to populate a cell based on info in a different cell. I keep getting the "UNPARESEABLE" message. Please help! What am I missing in this formula?

Thank you, in advance!


Best Answer


  • John Walden
    John Walden ✭✭✭
    edited 03/22/21

    Hi Lisa,

    Try removing the spaces between the IF (Influence...). i.e., IF(Influence@row = "High", 3, IF(Influence...

    Also, you'll need another ) at the end of the formula.

    =IF(Influence@row = "High", 3, IF(Influence@row = "Medium", 2, IF(Influence@row = "Low", 1, IF(Influence@row = "None", 0))))

  • Lisa Matthews2
    Lisa Matthews2 ✭✭✭✭
    Answer ✓

    Hi John,

    Thank you so much! I just copied your formula into my sheet and it worked beautifully!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!