Paul Rosas
Paul Rosas ✭✭
edited 11/01/21 in Smartsheet Basics

I have a sheet that has a drop-down menu with 9 different options. This sheet is attached to a form that will have random inputs, however every one of the 9 options from the dropdown will be selected every time someone fills out the form and a row is populated in the sheet. I have a dashboard that is also attached to this form that shows a bar chart that represent the 9 different options. However, for every time that one of the 9 options was inputted, it shows a different bar---- I would like for it to be cumulative data that shows a bar for each of the 9 options, that represents all of the rows that are inputted perhaps as an average.

Any help would be appreciated. Thank you!


Best Answer