Creating a graph in Dashboard

Please see the attached snip-it. I am counting the checked boxes in the columns and I want to display this in a graph format in a Dashboard.

When I add a graph widget to the dashboard using the checkbox count totals, I get a message that says the data cannot be displayed in a graph format? I tried linking the total to another sheet and using that sheet for the graph but that didn't work either.

Any Suggestions?

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    @1996mustang You would type out

    =VALUE(


    Then in the formula helper box there should be a blue link that says something along "Reference another sheet". Click on that and a new window should pop up. Select the appropriate source sheet from the list on the left, click on the cell you want to link, then click on the blue box in the bottom right corner that says something like "Insert Link".


    The window should disappear, and you should now see something along the lines of

    =VALUE({Source Sheet Name Range 1})

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!