Formula not working for creating a score in a survey

=IF(OR([Is the agency's experience with local, state or fe]@row = "≤ 1 year", 1), IF(OR([Is the agency's experience with local, state or fe]@row = "≥ 5 years", 2), ([is the agency's experience with local, state or fe]@row = "> 5 years",3)))

I'm willing to change the formula completely if there is a better form or function to accomplish getting the score.

Background: I have a survey and there is a drop down where the survey taker can choose three options and get a score based on which one they select.

👀

Find more posts tagged with

Accepted answers

All comments

Nic Larsen

Try: =IF([Is the agency's experience with local, state or fe]@row = "≤ 1 year", 1, IF([Is the agency's experience with local, state or fe]@row = "≥ 5 years", 2, 3

Dramos

This really helped!

THANK YOU!!!!

Here's the final working solution:

=IF([Is the agency's experience with local, state or fe]@row = "≤ 1 year", 1, IF([Is the agency's experience with local, state or fe]@row = "≥ 5 years", 2, IF([Is the agency's experience with local, state or fe]@row = "< 5 years", 3)))

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.