Charts From Drop down Data

Anna Mullins

I have a sheet which lists loads of data on one column there is a selection of option (open, closed, etc....) Is it possible to put a widget or chart on dashboard showing the quantity of each option? 

Ofir Marco

Hi Anna,

From what i know you will have to do the calculations somewhere in the sheen and then pull it to the chart.

See example of the calculations below.

It means you will need to have a small table, one value for each status and calculate count-if based on the status and then add the widget with this data