Combine values into new field with count

Hi Stephanie,

To combine some of these statuses into one field I created a new formula-text field and used the following formula...

Case([Status], 
"Accepted", "COMPLETED", 
"Sent", "COMPLETED", 
"Completed", "COMPLETED",
"", "NEW")

It works by using your current status field and changing the input value into the output directly next to it. So for example, "Accepted" in your old status field would turn into "COMPLETED" in this field. You can also add in any additional inputs and simply change the output to "NEW", "IN PROGRESS" or "CANCELLED", like I did with the last line.  Here it is displayed in a quick report I created!

I hope this helps! Please let me know if you have any questions or the formula does not work correctly as you intended.