NEED A WAY TO REFRESH ALL SOURCE SHEETS AT ONCE!!!

swilly

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

The refresh on reports and dashboards do not update the conditional formatting for each row.

Every single sheet must be opened every day for them to display the correct colors (ex: 3 days away - blue, 1 day away - purple).

I log on and something "3 days overdue - red" is still showing "3 days away - blue", when I click the source sheet it quickly shows the wrong color then updates to the new color.

When I go back to the report, the row displays correctly - in this example it would show 3 days overdue - red color (rather than the incorrect: 3 days away - blue color, that had be displayed on the report before opened that single source sheet).

NEED A WAY TO APPLY CONIDITONAL FORMATTING TO REPORTS

or

NEED A WAY TO REFRESH ALL SOURCE SHEETS AT ONCE (so the reports and dashboards will have truly updated information from source sheets without having to manually open each one)

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.

Melitta

@swilly

https://help.smartsheet.com/articles/2482767-automatically-update-today-in-formulas

Paul is correct. I include the link to that above. If you set this up on all of your source sheets, they will auto update each day.