Chart Live Update
We are experiencing an issue with the chart functions within Smartsheet. We are currently using Smartsheet to collect and process help desk tickets. We have a form hosted on our intranet where users can submit help desk tickets. Those are collected and processed by our help desk team all in one sheet within Smartsheet (Screenshot 1). We then have a second sheet that provides some simple, summary statistics of those help desk tickets by month by status (Screenshot 2). Finally, we are experimenting with a 'dashboard' of sorts that just provides a visual summary of the information compiled in the second sheet (Screenshot 3). This final piece is where the problem lies. We have it set to update every 2 minutes, and it appears to be functioning properly in terms of rendering the data as expected. However, when anything changes on the original source sheet (Screenshot 1), all of the charts fail (Screenshot 4). The only way to fix the issue is to navigate to the second, summary sheet (Screenshot 2) to, in-effect, synchronize the middle-man. Any way to fix this that doesn't involve pointing the charts directly at the form data?