Conditional Formatting and Reports on a Dashboard
Answers
-
I'm having a similar issue — in the underlying data sheet, the conditional format "highlights events posted in the last two days". The sheet feeds into a report. That report is part of a dashboard. Sometimes (I haven't figured out what causes it), a row on the report on the dashboard will be highlighted, even though it falls well outside of the "last two days" dictated by the underlying conditional formatting on the sheet. For example, I have one right now that was posted 7 days ago, but the conditional formatting is still appearing on the dashboard (but does not appear conditionally formatted on the underlying sheet or report). Today is July 8, 2024. I have attached two screenshots. The first is the conditional formatting formula on the sheet. The second is the dashboard, pulling from a report based on that sheet.
-
Try inserting a date type column then creating an automation that runs every day (I use 1:00am) to record the date in this new date type column.
That should force a daily refresh on the sheet even if no one interacts with it directly.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives