Multiple IF Formula

Options

Hi,

I am looking for a formula to return a value 1-5 in a column based on a dropdown selection in another column. the options are

Strongly Agree, Agree, Neither Agree/Disagree, Disagree & Strongly Disagree.

I would like them to return a value (5,4,3,2,1)

I have tried to use a multiple IF Function and it is not working correctly.

=IF([Arrived on Time]@row = "Strongly Agree", 5), ([Arrived on Time]@row = "Disagree", 4))

Thanks!

Answers

  • Nic Larsen
    Nic Larsen ✭✭✭✭✭✭
    Options

    You just need to stop closing off your arguments, more like this:

    =IF([Arrived on Time]@row = "Strongly Agree", 5, IF([Arrived on Time]@row = "Disagree", 4, and so on

  • KPH
    KPH ✭✭✭✭✭✭
    Options

    I think you're almost there!

    Try adding an IF to the second function like this and removing the closing parenthesis after the 5:

    =IF([Arrived on Time]@row = "Strongly Agree", 5, IF([Arrived on Time]@row = "Disagree", 4))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!