Change output wording in Appfire Report

[Donovan Godt]

I am looking to group the names of statuses in my reporting - Similar to status categories, but we aren't looking to make changes to those. We have multiple statuses for UAT (UAT in progress, UAT, in UAT, UNIT TEST) and then multiple statuses for Development (Development in progress, Design, In Progress). I am looking for the column to lump those together as either "UAT" or "Development"

I've figured out how to do that, but we have other statuses listed - To Do, Ready for Review - that need to remain. I'm using AppFire and not the advanced add-ins and have attempted to create a calculated field with no luck.

Any suggestions to get around not being able to use IF statements? 

[Pallavi Shirodkar]

Hi @Donovan Godt 

If AppFire allows basic formula fields, use pattern matching (such as CONTAINS or REGEX) to assign new group values. For example, create a single calculated field that checks if Status contains "UAT" or "UNIT TEST" and outputs "UAT," else checks for "Development," "Design," "In Progress" and outputs "Development." If neither are matched, return the original status.

Try this once.