Novice Smartsheet user here. I created a Likert-syle survey using a Smartsheet form that has about 20 questions on it. I have results from five respondents so far. I would like to present this data in a Dashboard using the chart widget - one chart per question. Ideally, the chart would show how many respondents answered "agree", "neutral", or "disagree" for each of the questions.
Additionally, I'd like to set it up so that as more respondents complete the survey, the data updates in real-time.
Is this possible? Does anyone have a resource to share that indicates the steps to take to turn each question into a Dashboard chart?