IF formula not working for a drop down list

Courtney M

Hello,

I'm trying to equate a numerical value to a drop down list when I receive a form entry. Here is my list:

4 - very clear

3 - clear

2 - somewhat clear

1 - not clear

The formula I entered was =IF([Training Objectives]@row = "1 - not clear", 1, IF([Training Objectives]@row = "2 - somewhat clear", 2, IF([Training Objectives]@row = "3 - clear", 3, IF([Training Objectives]@row = "4 - very clear", 4,)))))

It results in unparseable. I also tried it without the [ ] referring to the column. Can anyone advise what I am doing wrong, thank you!!!

Nick Korna

Hi @Courtney M,

It's an easy fix - you have an extra comma and bracket at the end of your formula. It should be:

=IF([Training Objectives]@row = "1 - not clear", 1, IF([Training Objectives]@row = "2 - somewhat clear", 2, IF([Training Objectives]@row = "3 - clear", 3, IF([Training Objectives]@row = "4 - very clear", 4))))

Hope this helps!

Nick Korna

Hi @Courtney M,

It's an easy fix - you have an extra comma and bracket at the end of your formula. It should be:

=IF([Training Objectives]@row = "1 - not clear", 1, IF([Training Objectives]@row = "2 - somewhat clear", 2, IF([Training Objectives]@row = "3 - clear", 3, IF([Training Objectives]@row = "4 - very clear", 4))))

Hope this helps!

Courtney M

@Nick Korna OMG, that's embarrassing! Thank you so much!!!

Nick Korna

No problem, glad it is fixed now for you. 😊