ContributionsMost RecentMost LikesSolutionsRe: Formula to count values in a fieldI am in need of something like this. Rebecca were you able to get a formula for this?How do I color code a table report for fixed fields?How do I color code a table report for fixed fields? No matter what goes in the field I want the field to show up in the table as a certain color.Re: How do I make a new field that converts a number from a different field entry to text?That was the problem :) I had it as numeric. I changed it to Text and it works perfectly. Thanks for your help.Re: How do I make a new field that converts a number from a different field entry to text?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?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.