Hide report column that conditional formatting is based off

Question

I'm working on a dashboard with a series of task reports. I would like to color code each row (the entire row) based off of the Progress Status. Late = red, At Risk/Behind = yellow. I also don't want the Progress Status column to actually show up on the report.

I've tried switching the Column view to text mode and adding

textmode=true

usewidths=true

width=0

but it doesn't work. I also tried the same but with width=1 and it doesn't work.

I was able to make the column disappear once, but my conditional formatting of the entire row went with it.

Is there a way to hide a column that is being used to conditionally format the entire row?

Thank you!

skyehansen · Accepted Answer

brain fart... the conditional formatting doesn't have to be on the progress status column... you literally could find any other column on there and specify the progress status formatting. Have you tried this yet?

skyehansen · Answer

you can't hide it. Best thing to do is just hide or replace the content in it. You can do this a number of ways. I usually just replace the valuefield line withvalue=(i.e. a blank line)

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded