Conditional Formatting not applying to entire column, even with helper column added

Bradhickswa

Hi -

I have a colleague who has a sheet with conditional formatting that turns the cell and text in a particular column GREEN if the date is within the last 31 days. As you can see below, only half the conditional formatting not applying to certain rows. I've gone and done the "helper column" trick and tried it that way, and it doesn't fix the problem either. The CF rule is top of the list, so it takes precedence over other rules in the sheet, so it's not that. I've checked over the entire sheet and cannot figure why it still won't fix itself. Here's a snapshot of the issue below:

Any thoughts on how to fix this? Is it a bug within Smartsheet?

Thanks,

Brad

Michelle Choate 2

@Bradhickswa - Can you show us a screenshot of your conditional formatting rules?

Bradhickswa

@Michelle Choate 2 Here it is.

Michelle Choate 2

@Bradhickswa - This is very strange. I have never seen it act this way before, where it will color the text but not the cell. I would definitely recommend opening a ticket with Smartsheet support and report back what the issue is in case it happens to someone else!

Bradhickswa

@Michelle Choate 2 thanks for trying! The problem ended up working itself out, somehow haha. Maybe a glitch in the system or something!