Is it possible to combine multiple columns into one column for a list report

[Thomas19]

Hi all,

I'm making a dashboard that holds multiple list reports in it, to work more efficiently and have a lot of info within 1 field. 

One of the reports I'm using is based on the Task Table and shows incidents, changes and tasks that are assigned to my team. So far, I've been using the "created by" column as a field to show who requested the incident, change or task. 

However, that's not accurate enough, as incidents are often requested by some who's not the "caller" and is thus not experiencing the issue. So showing that person's name isn't accurate. 

Is it possible to combine multiple columns in the results list and show it as 1? 

For example, instead of displaying 3 columns: 

• Requested for (Request task)
• Requested by (Change Request task)
• Caller (Incident task)

Can I combine this into one? Because three columns takes up a fair bit of my screen's "real estate". 

Thanks!

[Ishita Shrivast]

Hi Thomas, try giving condition like below screenshot.

Hope this helps. If it doesn't work then do tell me, will try something else.

Regards,

Ishita Shrivastava.

[Thomas19]

Hi Ishita,

Thanks for the answer, but this doesn't really help my case :). 

What I'm looking to do is combine 3 columns in my result list into one single column. So it's not related to the assignment group.

[Alok Das]

Hi Thomas,

Unfortunately we can not combine the columns into a single one, because different column may be of different type and values in it. Suggest you to use the most appropriate column instead of combining.

Kindly mark my answer as Correct and Helpful based on the Impact.

Regards,

Alok

[DirkRedeker]

Hi

You could add a "calculated" field on your table, which adds all the three fields together.

Then you can report on that field.

Let me know if that solves your issue and mark my answer as correct and helpful, please.

BR

Dirk