Form Entry Metrics by Category

kss5229
kss5229 ✭✭
edited 01/27/25 in Smartsheet Basics

I'm creating a metrics sheet that will have data input by external parties via a form. I'm trying to think of a simpler/more user friendly way to display categories on the sheet and form.

There are many category options and I need the # of occurrences entered for each category to tabulate monthly metrics. Most of these categories will have no occurrences, while several will have many. The only way I can currently think to display this information in my sheet (and form) is to have a column for each category I.e. "# of Occurrences of Category A" (and so on through Z). And then there would be a line item in the form for each category, most of which would be left blank, but several will have entries. Is there a way to simplify this in the form and sheet such that all the categories are available, but only the relevant ones are displayed (when selected)?

Best Answer

Answers