Combining field values into a "super field".

[ShaneLa]

We have a number of custom form fields that we use to "bucketize" our work. It is helpful they are separated for conditional logic and user experience. For some of our more advanced reporting we are running into needing a number of field values to be combined into a "super field". We are able to do this with out data team as a transformation outside of the system but wondering if we can use a calculated field with if/then statements or something else to accomplish this natively. Anyone had success doing this? Any other ideas?

[Heather_Kulbacki]

If you just need to combine multiple fields into a single column on a report, CONCAT works well

https://one.workfront.com/s/article/Calculated-data-expressions-679086747

I also seem to wind up using IF/THEN statements frequently - and sometimes combining those with CONCAT