Make conditional formatting refresh all source pages for report and dashboard accuracy

swilly

Reports and Dashboards do not currently update the colors of conditional formatting. For instance, I have it set to change the color when it's 3 days away.

Unless I open the source sheet, the reports in dashboards will not update. Even if I press the refresh button on the report or the dashboard, it doesn't actually refresh the source sheets.

Since I have a multitude of sheets it is not possible for me to open every single source of sheet just to have the reports and dashboard show the correct conditional formatting color change.

I'm not sure what it would take to do this, as it would require some way to refresh all of the sheets automatically, or with one button click somewhere in the interface. I'm prepared to invest in your program, but unfortunately without the reports and dashboards update and correctly it does not suit my needs.

swilly

NEED CONIDITONAL FORMATTING ON REPORTS!!!!

Having to open each source sheet to have the conditional formatting reload is not efficient.

Paul Newcome

You can insert a hidden date type column then use a Record A Date automation set to run daily to record the date in the hidden column. This will force refresh your sheet and in turn solve your issue.