Please help me figure out how to display a widget on the Dashboard that would show the general state of several projects of the program in the form of a pie/doughnut chart.
SmartSheet issues a message - Invalid Data. To create a chart you must use numeric data.
As the next step I tried to create additional smartsheet to put together RYG Statuses statistics and show how many of tasks are Red, Yellow and Green.
Then I would like to show it in percentage ratio in Dashboard.
So far, the idea of using an additional smartsheet doesn't work.
Is it possible?
I would appreciate for any advise or link.
Thanks in advance
Help Article Resources
Check out the Formula Handbook template!