This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm looking at survey data that has standard Likert type repsonses (Agree, Strongly Agree, etc.) and i'd like to update these responses to numerical values rather than the text (e.g. Strongly Disagree = 1, Disagree = 2, etc.). I thought that the Multi-Field Formula tool would be the way to go but can't figure out if I have it configured correctly. Any thoughts?
Replace([_CurrentField_], 'Strongly Disagree', '1') AND Replace([_CurrentField_], 'Disagree', '2')