Expand Count formula (To provide a list of names from another column)

ProductDan

Hi All,

This one may not be possible, but will drop it into here to see if it is, thanks in advance for your help.

I have a "COUNTIF" Statement in place which is counting the number of times "Red" is listed in a column.

In a corresponding column I have a reference to a company name which I would really like to display on a Dashboard.

Is there a way to reference COUNTIF value, then list out corresponding company names from a difference column?

Would like to use formula to ensure were capturing any updates to the data sheet, without Manually tweaking it.

Thanks,

ProductDan

Find more posts tagged with

Formulas

Accepted answers

Andrée Starå

Hi @ProductDan

I hope you're well and safe!

Have you explored using a Report?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

@ProductDan

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

All comments

Andrée Starå

Hi @ProductDan

I hope you're well and safe!

Have you explored using a Report?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

ProductDan

Thank you @Andrée Starå ,

The report worked, I was completely overcomplicated the problem Vs Solution.

The Report has done exactly what I wanted, the only pitfall is that I am not able to edit / customise the Font or colour of the text, But we can live with this :)

Thanks for bringing me back safely to ease!

Andrée Starå

@ProductDan

Excellent!

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