All,
I have a list report that has three columns. The first column has conditional formatting that causes the column to be invisible when the condition is met. When that is true, the values all shift over one column, but the headings remain the same, causing the report to look like this (H=header, V=value):
H1 H2 H3
V2 V3
Any idea how to fix this? I want the H1 header to appear even when the condition is met, but I don't want the values to shift over.
H1 H2 H3
V2 V3
Thanks!