Conditional Formatting doesn`t apply to Report

Raste

Hi there,

I was playing arround with the conditional formatting and stumbled across a problem. I have some rules, based off the "Modified" column. When those rules are used on a custom column, it works just fine. If the rule is used on a system column (Modified in my case) it doesnt seem to apply the colours in the report. See the screenshot. (Report is left and sheet is right)

Is there anything I can do to fix this?

Cheers

 

edit: Just found out that if the format is being used for the whole row, the modified column will change its color in the report as well.

edit #2: Okay, this is weired. I want those colours inside my dashboard. For some reason, the coloures are visible on my dashboard but not in the report. That solves the problem then.

Andrée Starå

Hi Raste,

Glad to hear that you solved it. Didn't it work when you selected the column in the rule? Does it only work if you choose the row?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

 

 

Raste

Correct. I selected the "Modified" column and the formatting applies in the sheet but not in the report. If the entire row is selected, the formatting works in the report as well.

Selecting the entire row won`t work for me tho, so I diddn`t solve it yet.

Andrée Starå

Strange!

If you haven’t already, I would recommend that you reach out to the Smartsheet Support Team. Smartsheet Support Team