Help with formula

I am setting up as simple tracking of an annual communications plan and have a Platform of Engagement column with about 12 drop down platforms to select from. I want a formula to track the amount of engagement on each platform selected within this column. The following formula works counting for one platform of engagement, selection was Community Partnership:

=COUNTIF([Platform of Engagement]:[Platform of Engagement], "Community Partnership")

But when I try this same formula in another cell with "Website" for example, I get circular reference and blocked. But I can't work out why? I can't work out where the circular reference is? Or why this

Find more posts tagged with

Formulas

Countif

Accepted answers

All comments

Genevieve P.

Hi @JudyQ

Are you pasting the formula within the same column as the data you're looking at? (In the Platform of Engagement column?)

You can reference the current column once. As soon as you need to reference the same column for multiple formulas, these should be put in a separate column looking over at it:

Let me know if this was your issue or not! If not, it would be helpful to see a screen capture but please block out sensitive data.

Cheers,

Genevieve

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