Discussions

Expand all | Collapse all

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

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

    Posted 08-29-2018 21:56
    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. 


  • 2.  RE: How do I make a new field that converts a number from a different field entry to text?

    Posted 08-31-2018 03:14
    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")


  • 3.  RE: How do I make a new field that converts a number from a different field entry to text?

    Posted 08-31-2018 18:24
    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?


  • 4.  RE: How do I make a new field that converts a number from a different field entry to text?

    Posted 08-31-2018 18:25
    May I see your formula now?



  • 5.  RE: How do I make a new field that converts a number from a different field entry to text?

    Posted 08-31-2018 18:26
    Please confirm the field type is Formula - Text?



  • 6.  RE: How do I make a new field that converts a number from a different field entry to text?

    Posted 08-31-2018 18:35
    That was the problem :) I had it as numeric. I changed it to Text and it works perfectly. Thanks for your help.