Skip to main content
Question

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. 
    This topic has been closed for replies.

    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")
    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?
    May I see your formula now?

    Please confirm the field type is Formula - Text?

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