IF formula not working for a drop down list

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!!!

Find more posts tagged with

Accepted answers

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!

All comments

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:

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. 😊

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.