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.
Topics help categorize Community content and increase your ability to discover relevant content.
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.
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)
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.
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.