Formula for counting values from single-select drop down on a form

Hello,

I'm trying to figure out how i can count or which formula i can use to count how many people selected their desired choices from three different categories (single-select dropdown) that falls under 3 different groups. I created a form out of a sheet and my question is when people are going to pick their top 3 choices for each of those 3 categories what can i do or use to count those selections on the sheet. Let me know if you have any additional questions or if this all makes sense. I was thinking to use Count formula but then I am thinking do i have to put that formula under each column (9 columns for 3 categories).Ex:

1- Goals for the next 1-3 months:

a) First Choice: (Single-select dropdown)

b) Second Choice: (Single-select dropdown)

c) Third Choice: (Single-select dropdown)

2- Goals for the next 3-6 months:

a. First Choice: (Single-select dropdown)

b. Second Choice: (Single-select dropdown)

c. Third Choice: (Single-select dropdown)

3- Goals for the next 9-12 months:

a. First Choice: (Single-select dropdown)

b. Second Choice: (Single-select dropdown)

c. Third Choice: (Single-select dropdown)

Find more posts tagged with

Accepted answers

Paul Newcome

There is a section in the Form Settings that allows you to have the form populate either the bottom or the top of the sheet.

All comments

Paul Newcome

I can not say for sure, but I believe it depends more on the sharing permissions.

Saadia Ashraf

So an admin or the owner can make the edits. But, isn't admin tied to license?

Paul Newcome

Sharing permissions and licenses are not necessarily tied together. You could share an unlicensed user to a sheet as admin.

Saadia Ashraf

Oh makes sense. Thank you so much for your help as always. :)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.