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

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
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. 
Photo of Jassy Jackson

Jassy Jackson

  • 130 Points 100 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of Slider

Slider

  • 1,326 Points 1k badge 2x thumb
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")
(Edited)
Photo of Jassy Jackson

Jassy Jackson

  • 130 Points 100 badge 2x thumb
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?
Photo of Slider

Slider

  • 1,326 Points 1k badge 2x thumb
May I see your formula now?

Photo of Slider

Slider

  • 1,326 Points 1k badge 2x thumb
Please confirm the field type is Formula - Text?

Photo of Jassy Jackson

Jassy Jackson

  • 130 Points 100 badge 2x thumb
That was the problem :) I had it as numeric. I changed it to Text and it works perfectly. Thanks for your help.