Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Display Pie Chart in a Dashboard

I have a sheet that is linked to another sheet that counts how many RED, YELLOW, GREEN, and BLUE dots. My problem is when I try to make a Pie chart from this data in a Dashboard, the Pie chart icon is greyed-out and not available?


Thoughts?

ds

Best Answer

  • Community Champion
    Answer ✓

    Hello @1996mustang

    This is typically a problem when you have more information on a sheet than just numeric values, and text to describe those values. If you create a report from that sheet with the first column as the information label, and the second column as your numeric count, you should be able to create a pie chart from the report.

    Hope this helps! Thanks

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions