% Selected Option in a column

I am trying to create a formula to display % of selected option from a dropdown in a column. The options are:

I do not know
Yes, I heard about it
Yes, I read it

The column will be populated continuously, therefore 100 or more rows will be eventually populated.

From the column, how do I create a formula to represent % each of the option selected? I should therefore be able to ascertain, for example,

Screen Shot 2022-06-03 at 8.01.02 AM.png

75% of persons selected "Yes, I heard about it". See attached how the column will be represented.

Find more posts tagged with

Accepted answers

Paul Newcome

You are going to need something like this...

=COUNTIFS([Dropdown Column Name]:[Dropdown Column Name], @cell = "Yes, I heard about it") / COUNT([Dropdown Column Name]:[Dropdown Column Name])

All comments

Paul Newcome

You are going to need something like this...

=COUNTIFS([Dropdown Column Name]:[Dropdown Column Name], @cell = "Yes, I heard about it") / COUNT([Dropdown Column Name]:[Dropdown Column Name])

Vinton Douglas

Works perfect! Thank you very much

Paul Newcome

Happy to help. 👍️

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.