Dynamic View does not show Conditional Formatting in Blank Cells
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?
Answers
-
Probably not ideal, but you could automate that if a cell is blank, add a character, like a bullet β’ or dash -
-
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!
-
@bethle do you have datamesh?
-
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.
-
@Samuel Mueller Yes, I do have DataMesh!
-
So.. with a helper column and a unique id column, you could use datamesh to populate the blank date fields with a dash or bullet. You can use the same sheet as the source and target in datamesh, and then have a helper column ="-" and use the unique ID as the unique identifier and set it not to overwrite data. map the helper column with each of your date columns and it will populate the date fields with dashes.
-
That's great. I will definitely try that!
