Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

Combining field values into a "super field".

Avatar

Level 2

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?

1 Reply

Avatar

Community Advisor

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