Chart on dashboard does not dynamically update
I am new to this forum and Smartsheet and your help is appreciate it.
I have created a dashboard which has a Chart widget. I have selected the data from my sheet which is linked to the chart. When I add a new row of data into the sheet the chart on the dashboard does not refresh to show the new information. I have to manually go and edit data and change the range to include the new row. Even when I edit the chart and choose columns it still the same problem. My sheet is a simple name of task, start date, end date, assigned to, % complete and my chart shows assigned to and percent complete columns
Any hep is appreciate it