How do I create a widget from results based off stars

Julieann

I created a form to get results for a menu we were tasting

I have all of the results but I now want to display the results to show how many people liked the dish / didnt like the dish etc..

How do I do this ideally in a graph

Amit Wadhwani

Hi @Julieann

You can use below formula in a new column to convert rating into a number, and then use the number. Create summary field to count the occurrences of each number. These summary fields can be used to create a widget on dashboard.

=IF([ColumnName]# = 1, "1", IF([ColumnName]# = 2, "2", IF([ColumnName]# = 3, "3", IF([ColumnName]# = 4, "4", IF([ColumnName]# = 5, "5")))))

Best Regards

Amit Wadhwani, Smartsheet CoE, Ignatiuz Software, Exton, PA

https://www.linkedin.com/in/amitinddr/

Andrée Starå

Hi @Julieann

I hope you're well and safe!

To add to Amit's excellent advice/answer.

If you want the result to be a number, you'd have to remove the " " surrounding the numbers because otherwise, Smartsheet will read it as text.

Like this.

=IF([ColumnName]# = 1, 1, IF([ColumnName]# = 2, 2, IF([ColumnName]# = 3, 3, IF([ColumnName]# = 4, 4, IF([ColumnName]# = 5, 5)))))

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Julieann

hi there,

Thank you for your help. I did end up using powerpoint in the end because I couldnt resolve the issue in time. I have used the form again now though and would love to create a dashboard!

MY feedback was captured using the star option in the form so rate your meal out of 5 stars - what is the best way to display this? baring in mind there was 17 different items tasted.

Any help would be appreciated.