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".


Best Answer

  • Sean Morgan
    Sean Morgan Employee
    Answer ✓

    Hello @Stan Kinney ,

    You may instead wish to create a Metric Sheet that contains E.G counts of each status type. Please see my example below:

    Source Sheet:


    Metric Sheet:

    These cells contain the following Formula: =COUNTIF({Automation test Range 1}, HAS(@cell, [Primary Column]@row))

    Dashboard Chart View:

    This way the Metric Sheet will allow for ease of use with Charts by collecting values from the Sheet, and if none are present, it populates with 0 so the Chart remains empty until populated in the Source Sheet, and then fed into Metric Sheet

    Let me know if you have any questions!

    Regards

    Sean

Answers

  • Sean Morgan
    Sean Morgan Employee
    Answer ✓

    Hello @Stan Kinney ,

    You may instead wish to create a Metric Sheet that contains E.G counts of each status type. Please see my example below:

    Source Sheet:


    Metric Sheet:

    These cells contain the following Formula: =COUNTIF({Automation test Range 1}, HAS(@cell, [Primary Column]@row))

    Dashboard Chart View:

    This way the Metric Sheet will allow for ease of use with Charts by collecting values from the Sheet, and if none are present, it populates with 0 so the Chart remains empty until populated in the Source Sheet, and then fed into Metric Sheet

    Let me know if you have any questions!

    Regards

    Sean

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!