Forum Discussion

JassyJackson's avatar
JassyJackson
Qrew Trainee
6 years ago

How do I make a new field that converts a number from a different field entry to text?

I have an NPS application where I'm collecting the 0-10 rank on the question and would like a field that converts the answer from 0-6 to "Detractor, 7-8 to Neutral and 9-10 to Promoter" I can't seem to find the right formula to make this field happen. 
Formulas and functions

5 Replies

Sort By
  • KevinSlider's avatar
    KevinSlider
    Qrew Trainee
    6 years ago
    Hello, sounds like a Case formula would work for you. let me know if this helps.

    Case([NPS Rank],
    0,"Detractor",
    1,"Detractor",
    2,"Detractor",
    3,"Detractor",
    4,"Detractor",
    5,"Detractor",
    6,"Detractor",
    7,"Neutral",
    8,"Neutral",
    9,"Promoter",
    10,"Promoter")
  • JassyJackson's avatar
    JassyJackson
    Qrew Trainee
    6 years ago
    Thanks for the update, the field just gives me a number instead of "detractor" etc... it also has an error where it says that it was expecting a number instead of text. What is the "type" for the field?
  • JassyJackson's avatar
    JassyJackson
    Qrew Trainee
    6 years ago
    That was the problem :) I had it as numeric. I changed it to Text and it works perfectly. Thanks for your help.