How do I change the "Not Available" displayed when I Icon in the Dashboard status updates?
When creating a dashboard I have selected to have a Chart Widget to display a summary of information on the Dashboard. When there is no information in the Open status in the Sheets where the data is being pulled from. the current display in the Chart Widget reads "The source data for this chart has been changed. This chart type must have one set of labels and one set of values." The display is a caution triangle.
How do I resolve this so that when there are no open items in this area instead of this results; I can get a zero displayed instead of the erroneous message".
Help Article Resources
Check out the Formula Handbook template!