Expand my Community achievements bar.

Is it possible to conditionally hide an entire report column?

Avatar

Level 3

In the attached screenshot, my organization would like to hide the Release 2 and Release 3 columns entirely if the Number of Releases custom form field is set to only 1. Is it possible to conditionally hide those columns based off of the selection made on the custom form field? I also have a boat-load of column sharing going on with these reports which hopefully shouldn't complicate it too much, but wanted to at least mention it.

0690z000009DAf0AAG.jpg

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

5 Replies

Avatar

Level 3

Closing my own loop if anyone ever has the same trouble. I just re-organized the layout of the report to get around this, so never figured out a solution.

Avatar

Level 2

Facing a similar challenge here. In my case, I would like to hide a report column in case all cells in that column are blank. No luck so far.

Avatar

Community Advisor

I don't think this is possible (columns in a view do not delete themselves for any reason) but what you can do, is some conditional formatting. This is what we do in our system: for release column 2, if the number of releases =1, make the cell background black and all the text black. At least this way, there won't be distracting text in the report. (obviously only usable on reports that you don't download)

Avatar

Level 2

Thanks a lot @Skye Hansen‚

In my case I have several columns in that report and most of them will be empty depending on the prompt selection. To paint them black would still present a huge report only with only a few cells with valid numbers among hundreds of empty cells. If I find any other approach to deal with this, I will post it here.

Avatar

Community Advisor

depending on what the fields contain, you might be able to somewhat work around this by merging multiple columns into one. The blanks would just be left out. The only challenge is the formatting of the blank lines (specifically paragraph breaks), which would have to be kept to a minimum.