Topics help categorize Community content and increase your ability to discover relevant content.
I'm not clear on what you mean by "share columns on a grouping"? A couple of questions:
1. Forgetting about groupings, are your shared columns working for the two fields you want to see joined together on the report?
2. What type of report is this? A task report?
3. What object is this custom field on? Task or Project?
You can do this using sharecol=true, but you may want to take a bit of time to read through our help article to make sure you don't miss a beat there.
My trick when combining to columns is to add a blank column between the 2 with the following text:
Note: you can use near anything for the value, but the biggest point is you want that to be there, so there's a way to separate the data in the columns you're combining.
Once you've saved that column, it'll automatically pull the column directly to the right into it.
Once you're back to your 2 columns, you'll click on the left column, go to text mode, and add sharecol=true to it. Once again, when you save it, it will pull the column to the right into it.
Here's what it looks like step by step:
Step 1: https://cl.ly/d843f2d820df
Step 2: https://cl.ly/c67e3ef8e040
Step 3: https://cl.ly/cf1e39735374
Step 4: https://cl.ly/20d843512ec1
Step 5: https://cl.ly/03de21c80962
If you'd like to provide a name on the column, look for the column.#.displayname= (if it doesn't exist, feel free to create it.)
Then you can call it whatever you'd like.. IE: column.0.displayname=Name & Status
Hope this helps.
Thank you all. This is a Task Report and I've tried with both Task & Project level custom forms. When I say, Shared Columns, that could be inappropriate for this specific ask but I knew we'd get the point. More or less, "Row".. If you were to have a report that has 2 levels of groupings, I would like to just combine them into 1 "row" essentially vs the two blue rows that currently display. I will take a look at some of the info above. Sorry for the delays, I shall fix these going to my junk and thank you!
Additionally & maybe more important.. in the attached screenshot, we have two groupings.
1 by project name (joel)
1 by task description (SL1)
On the grouping of description (SL1) is there a way with an IF statement, to have it display the value of either the assigned to name OR the field you see, "Project:SL1"?
Trying valueexpressions, etc.
There's not a way to combine groupings like you can columns, so that's out.
As for the IF statement, it's totally doable, though it's something you'd probably want to reach out to our consulting team for help on.
There is a way to combine the grouping rows which may work for you: