Dynamic View does not show Conditional Formatting in Blank Cells

bethle

Dynamic View seems stumped by blank cells and doesn't properly apply conditional formatting. In the screenshot below, each of the white cells should have a color.

As a workaround, we colored the entire column in the source sheet, which seemed to work initially. But then we realized that conditional formatting to change the cell color in blank cells was still not working.

See screenshots below (first screenshot is of the dynamic view with incorrect colors; second is a screenshot of the source sheet showing the correct formatting).

Has anyone been able to make this work properly?

Samuel Mueller

Probably not ideal, but you could automate that if a cell is blank, add a character, like a bullet • or dash -

bethle

Hi @Samuel Mueller I actually thought the same and tried that. Once I got to the Date type columns, I hit a wall because there isn't an automation to log a specific value in a Date field :( I wouldn't want to record today's date just to make it non-blank.

I could still do that for the non-Date fields, though. That's probably the best workaround at the moment, though it doesn't fully address the issue.

Do you have any other ideas? Thanks for the suggestion!

Samuel Mueller

@bethle do you have datamesh?

Samuel Mueller

also you should submit this as an enhancement request, because you are right, these are just workarounds and it really should be implemented into the tool.

New Idea — Smartsheet Community