AnsweredAssumed Answered

Print Columns - Show/ Hide column headers

Question asked by lindseym on Nov 14, 2016
Latest reply on Nov 15, 2016 by lindseym

Hello,

 

I have layout the prints to two columns.

 

What I want is when the 2nd column is needed the right column headers will show. When only  1 column is needed, only the left headers show.

 

 

Screen Shot 2016-11-14 at 3.46.12 PM.png

 

Only 1 column is needed, but the titles remain.

Screen Shot 2016-11-14 at 3.42.43 PM.png

 

Screen Shot 2016-11-14 at 3.43.22 PM.png

 

I thought about doing a white box over  the 2nd column headers and doing a conditional formatting.

 

Am I on the right path?

 

Each column can contain 20 lines, but there is technically no limit on how many pages (though 200 lines should be plenty). But if 2 pages are needed but only 5 print column, I would like the 3rd page to have only the right column headers.

 

I am not sure how to write an in between calculation.

 

Formula is: ((WEIDNER MSG SCHEDULE::Count Sign Types ≥ 3) and (WEIDNER MSG SCHEDULE::Count Sign Types  ≤ 5))

 

Screen Shot 2016-11-14 at 3.51.28 PM.png

 

I thought this would change the color of the box if the count of the sign types was 3 , 4, or 5

 

But it does nothing.

 

I don't have an issue when I create a formula of one parameter ( Count Sign Types >3  )

 

 

Thanks -

 

-L

Outcomes