Sign in to submit new ideas and vote
Get Started

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

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.

3 votes

Idea Submitted · Last Updated