Dashboard chart data changes randomly
I have a chart on a dashboard that shows values from a sheet. The sheet itself is summarizing data from another sheet, to show AVG and MEDIAN values. When I access the dashboard, the values on the chart will change and I have to view the underlying sheet before the chart will refresh with the correct values. Has anyone else experienced this type of issue?
Answers
-
Hi @Laura B.
I hope you're well and safe!
It's because the sheet with the data has to be "activated" to update the data. I'm guessing you're using the TODAY function or similar in the sheet, correct?
Here's a workaround that I developed, so the sheet is updated automatically.
More info:
Would that work/help?
I hope that helps!
Be safe and have a fantastic day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi @Andrée Starå - it does appear that the sheet needs to be activated, but there are no dates in my formulas. Here is one for reference:
=ROUND(MEDIAN(COLLECT({Price}, {Price}, IFERROR(ISNUMBER(@cell), 0), {Category}, "A", {Type}, "B")), -2)
-
It's not only for the TODAY function, but it's the most common one that needs to be activated.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Can you explain why the sheet needs to be activated? Is it related to my formula? I haven't seen this happen on other charts or sheets.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 405 Global Discussions
- 215 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives