I have a cognito form with questions that allows the user to vote (select) for all the checkboxes that apply to them. I need to map those answers to the respective column in excel so I can track how many votes each option gets.
For example, if they form submitted was for this:
Then I need to add a row that looks like this:
I know I need to use formatter but I’m not sure where to start with this one. If I can get the #’s, that’s fine, I can work with the actual option such as “Ancillary products” in the cell but must be in the correct column.
