Forum Discussion

JassyJackson's avatar
JassyJackson
Qrew Trainee
7 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 t...
Formulas and functions
KevinSlider's avatar
KevinSlider
Qrew Trainee
7 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")