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

Question

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.&nbsp;

kevinslider · Answer

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 · Answer

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?

kevinslider · Answer

May I see your formula now?

kevinslider · Answer

Please confirm the field type is Formula - Text?

jassyjackson · Answer

That was the problem :) I had it as numeric. I changed it to Text and it works perfectly. Thanks for your help.&nbsp;

Forum Discussion

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

Related Content

Roundup whole number

Converting delimited text into checkboxes

Add button to create record in different app

Calculating number of days between two date fields

converting text to number