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
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives